-
need help in writing T-Sql Querey
hi There,
I have a Database table which has about 90 columns in it.
But for writing this particular querey It needs only few of them.
I'll list them here!
Acc BegDt EnDt J F M A MY Jn Jy Au S O N D
10 1/2008 12/2008 1 1 1 1 1 1 0 0 0 0 0 0
First Querey:
"Based On The BegDt, Count the no of months that has a value>0 for acc10, and continues until it reaches a 0 value."
Note: BegDt n EnDt are in Char DataType:
Second Querey:
"Find The Value of The 'number' . where number is the value for acc 10 based on the startdate."
Can Any one please Help me soon. Its really very Urgne..!!
ThAnKs..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|