problem solved. Thank u all
Hi, I am getting this error "' 80040e14' - too many arguments specified" in the line rstStoredProc.Open cmdStoredProc, , adExecuteNoRecords where...
yes Adriaan<br /> its working<br /> Thanks a lot [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />And does anyone know any...
Adiraan “ 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
Madhivanan 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...
Hi All, 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.
