Viewing 4 posts - 46 through 49 (of 49 total)
Abhijeet
Thanks for the feedback.
December 22, 2010 at 11:41 pm
#1265785
you need to first create the function
create Function [dbo].[fnSplitter] (@IDs Varchar(8000) )
Returns @Tbl_IDs Table (ID Int) As
Begin
-- Append comma
Set @IDs =...
December 22, 2010 at 10:48 pm
#1265776
for your example you can write
select * from @tab1
where (@var1 <> 1) or (id in (1,2))
December 22, 2010 at 10:23 pm
#1265771
You can use GETUTCDATE() function to get UTC datetime Probably you can select difference between GETUTCDATE() and GETDATE() and use this difference to ajust your dates to UTC
you now that...
December 10, 2010 at 3:27 am
#1260948