Viewing 4 posts - 1 through 4 (of 4 total)
Hi,
Very easy, use this statement to check what your SQL is returning you
select CONVERT(VARCHAR,GETDATE())
then compare it with you @FDate parameter which is nVarchar. If these two don't match, then you...
May 12, 2010 at 2:04 am
Heres the exact code
declare @sometable table(id int, beg_date datetime,end_date datetime,rank int)
insert into @sometable values(1,'7/7/2005' ,'7/28/2005',null)
insert into @sometable values(1,'7/29/2005' ,'8/23/2005',null)
insert into @sometable values(1,'8/29/2005' ,'9/6/2005',null)
insert into @sometable values(1,'9/7/2005' ,'10/7/2005',null)
insert into @sometable...
May 19, 2009 at 3:00 am
Thanks GSquared, for your explanation. The word normalization would make more sense rather than column partitioning simply put.
A rather new guy to sql programming would go all around searching how...
May 7, 2009 at 6:53 am
Hey What are you talking about?? partioning columns, could you give an example??
Please do not misguide people
Partioning is only applicable for rows
May 6, 2009 at 3:00 am
Viewing 4 posts - 1 through 4 (of 4 total)