Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avijit111@gmail.com
Yak Posting Veteran
55 Posts |
 Posted - 2010-05-03 : 08:19:47
|
| compare with system date and stored table date.is it possible that compare with system date means current date with date stored in the table with varible name delivered_date.IN THAT THE MODIFIED DATE IS STORED.FROM THEIR I NEED TO FETCH MODIFIED_DATE.IN THAT TABLE WE HAVE A PROCESS PERIOD THATS ACTUALLY NUMERIC NUMBER WHICH INCREASING EVERY AFTER THREE MONTH THREE DIGIT. .LIKE JANUARY TO MARCH THE NUMBER WILL BE 3 AND MAY JUNE JULY THAT DATE WILL BE 6 LIKE THAT. IF U SUGGEST ME THAT IF I CAN INCREASE THE NUMERIC NUMBER WITH 3 THEN WE CAN GROUP THE TABLE PROPERLY. THANKS |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-03 : 09:55:03
|
| are you expecting a SQL query or .net logic?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
avijit111@gmail.com
Yak Posting Veteran
55 Posts |
Posted - 2010-05-04 : 04:28:25
|
| Hi,I am expecting sql query |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-04 : 12:45:48
|
| just do like ((MONTH([MODIFIED DATE])/3)+1)* 3 for getting the increemental number------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
compare with system date and stored table date