Thank u all
I am getting this error "' 80040e14' - too many arguments specified" in the line
rstStoredProc.Open cmdStoredProc, , adExecuteNoRecords
yes Adriaan<br /> its working<br /> Thanks a lot [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />And does anyone know any...
SELECT TOP 1 t1.*
FROM MyTable t1
WHERE ((t1.Year * 100) + t1.MonthCode) < ((YEAR(GETDATE()) * 100) + MONTH(GETDATE()))
ORDER BY t1.Year...
No Adriaan, I have tried ur query as well but sorry
what about the year!!!
It shud be month+Year I mean for June and 2005 it shud be "June,2005"
and month and year cannot be compared...
Hi All, [<img src='/community/emoticons/emotion-6.gif' alt=':(' />] <br />I dont know how to upload my sample data.Let me try this way.<br /><br...
say I have entry screen with month , year and amount1, amount2, amount3......amount100.
Now user wants that entry screen shud come up with last...
Madhivanan, first I have to find the "last" month , here in this case "June 2005"
Thank u all,
-Frank - I tried urs one as
"SELECT max(month_code) FROM storagecap WHERE [year]*10000+month_code*100+1<'20051001'"
but I m...
Thanks for such prompt reply,
And sorry , i cudnt get any help from the topic referred.
what I want is, that in my table I have month column and...
Is there a way in sql server to combine two columns of a table, month and year and get "date" so that the resultant date can be compared...
Separate names with a comma.