SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 count transaction by month
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

dayna
Starting Member

Philippines
14 Posts

Posted - 12/10/2012 :  19:41:05  Show Profile  Reply with Quote
( DTTPRODUCTCODE, DTTBRANCHCODE, DTTSEQUENCE, DTTCHECKDIGIT) is already declared in my table columns,..no need to add that one.,same with the dttTransactionDate.,those transmonth, transyear,nooftranssymbls, and nooftrans supposed to be the additional names in my columns table.

dcometa
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/14/2012 :  02:08:29  Show Profile  Reply with Quote
To make matters easy for people trying to help you can you post some sample data from table and then explain what output you want from them?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

dayna
Starting Member

Philippines
14 Posts

Posted - 12/17/2012 :  20:35:05  Show Profile  Reply with Quote
yup, the columns( DTTPRODUCTCODE, DTTBRANCHCODE, DTTSEQUENCE, DTTCHECKDIGIT)are already their in the table..

dcometa
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2217 Posts

Posted - 12/17/2012 :  23:47:45  Show Profile  Reply with Quote
Hi dayna,
Still you are facing any difficulty in that query? If yes, show us your present query...

--
Chandu
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/19/2012 :  00:47:29  Show Profile  Reply with Quote
quote:
Originally posted by dayna

yup, the columns( DTTPRODUCTCODE, DTTBRANCHCODE, DTTSEQUENCE, DTTCHECKDIGIT)are already their in the table..

dcometa


Unless you post some data and explain what output you want people wont be able to help you out further

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2217 Posts

Posted - 12/19/2012 :  01:01:37  Show Profile  Reply with Quote
Hi visakh,
Dayna posted sample data in her post (Posted - 12/09/2012 : 20:48:42)
See once... u may help her

--
Chandu
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/19/2012 :  01:06:29  Show Profile  Reply with Quote
quote:
Originally posted by bandi

Hi visakh,
Dayna posted sample data in her post (Posted - 12/09/2012 : 20:48:42)
See once... u may help her

--
Chandu


It doesnt show what output OP expects. unless we get that we wont be able to make out what she's after

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000