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 |
|
bheema
Starting Member
12 Posts |
 Posted - 2011-11-16 : 01:02:23
|
| hi,this is bheema..and i have requirement like thisdate time sno16-11-11 12:00am 116-11-11 11:59pm 217-11-11 12:00am 1 i have requirement like this that means if date and sno recycle every 24 hours.plz give me the ansthanks in advanceBheema |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 01:13:48
|
| how will you get initial values for sno? is it already stored in table? or will you pass as an input?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
bheema
Starting Member
12 Posts |
Posted - 2011-11-16 : 01:52:36
|
| we wil pass as input |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 01:53:52
|
| so what all will be input values you pass?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bheema
Starting Member
12 Posts |
Posted - 2011-11-16 : 01:58:36
|
| if i generate pl/sql query i need o/p like that...that means we to create the sequence to date and it wil be reset every 24 hours |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 02:06:15
|
quote:
Originally posted by bheema
if i generate pl/sql query i need o/p like that...that means we to create the sequence to date and it wil be reset every 24 hours
this is ms sql server forum. if its pl/sql query you want, please try in some oracle forums like www.orafaq.comyou stil didnt give us any information on input values though------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bheema
Starting Member
12 Posts |
Posted - 2011-11-16 : 02:10:26
|
| k.thanq |
|
|
|
|
|
|
sequency_date