| Author |
 Topic  |
|
dayna
Starting Member
Philippines
14 Posts |
 Posted - 12/10/2012 : 19:41:05
|
( 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 |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48072 Posts |
Posted - 12/14/2012 : 02:08:29
|
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/
|
|
|
|
dayna
Starting Member
Philippines
14 Posts |
Posted - 12/17/2012 : 20:35:05
|
yup, the columns( DTTPRODUCTCODE, DTTBRANCHCODE, DTTSEQUENCE, DTTCHECKDIGIT)are already their in the table..
dcometa |
|
|
|
bandi
Flowing Fount of Yak Knowledge
India
1711 Posts |
Posted - 12/17/2012 : 23:47:45
|
Hi dayna,
Still you are facing any difficulty in that query? If yes, show us your present query...
--
Chandu |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48072 Posts |
Posted - 12/19/2012 : 00:47:29
|
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/
|
|
|
|
bandi
Flowing Fount of Yak Knowledge
India
1711 Posts |
Posted - 12/19/2012 : 01:01:37
|
Hi visakh,
Dayna posted sample data in her post (Posted - 12/09/2012 : 20:48:42)
See once... u may help her
--
Chandu |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48072 Posts |
Posted - 12/19/2012 : 01:06:29
|
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/
|
|
|
|
Topic |
|
count transaction by month
