I think there was some problem while posting the thread. I have received some error message like

"contact board administrator". Thats why some threads are repeating more number of times in...

any idea about my requirement #2.

any idea about my requirement #2.

I followed Dave blog and wrote this query.

#1)

create table Contig(Id integer)

go

insert into contig values(1)

insert into contig values(2)

insert into contig values(3)

insert into contig values(5)

insert into contig values(6)

insert into contig values(7)

insert...

Please post the code.

Now I understood your point #2 and #3. But still #1 is not clear for me...

Again, if you could explain your...

RBarryYoung (6/8/2009)

karthikeyan (6/8/2009)

Left-hand Functions appear left of the assignment operator ("="):

Set @str = UPPER('Some text.')

These are normal functions, and AFAIK, in T-SQL,...

Declare @str varchar(5)

select @str = ''

select @str = @str + no from mystring

step 1: '' + '1'

step 2: '1' + '2'

step 3: '12' + '3'

step 4: '123' + '4'

step 5:...

Gail,

i expected this question from you. Since i studied these concepts just to pass the exams, beacuse that time i don't know the real time usage and it will be...

RBarryYoung (6/8/2009)

Pusedocursor is a name that some people (including me) use for the SQL Server (and Sybase too, I believe) trick of being...

If it...

RBarryYoung (6/8/2009)

For (1-3),...

Yes Gail...I have studied...But i don't remember the functionality...

I have reviewed the above mentioed URL, Since there are lot of formula's are there,it is confusing...

If you or anybody gave the...

A small modification in the code

SELECT TOP 1 id, Eff_Date, DATEDIFF( MINUTE, Eff_Date, GETDATE() ) AS DateDifference

FROM [log]

WHERE ecode = 200

ORDER BY DateDifference desc

will give the...

No...

Expected result:

100,2,'02/jun/2009'

200,3,'05/jun/2009'