Ram,

Its just the basic stuff, but anyhow thanks for appreciating....:):)

Adam,

Where R U?:hehe: Have you got what you wanted or you've found some other way around?

wrong forum dude...

Here is what i got...

I think there's still some room for improvement....:D:D

IF OBJECT_ID( 'tempdb..#Cars' ) IS NOT NULL

DROP TABLE #Cars

IF OBJECT_ID( 'tempdb..#Colours' ) IS NOT NULL

DROP TABLE #Colours

CREATE TABLE #Cars(...

I guess CTE is best suited for recursive logic...

Also, please provide us with some sample data and the output that you require, without which we're just working blindly....

John,

I think its a text column...

Lim,

I just misread your post...

I guess you want to extract the all records when value of your memo column ends with some defined string...(say ABC), then you can use...

Use PATINDEX for searching patterns....

SELECT (CASE WHEN PATINDEX('%ABC%', YourMemoField) > 0 THEN 'Match' ELSE 'No Match' END )

FROM YourTable

Its a great article and thanks for sharing it...

I wonder, is there's any way of knowing the existence of a key before reading it?

Search the forum you will surely find many articles on it...

Noel,

Full text search is a service named as Microsoft Search OR MSFTESQL...

You can go to services console & check what account is used to start the service...

Just use..

EXEC sp_fulltext_database 'enable'

Sandy,

I guess this is what you require...

UPDATE t2

SET t2.salary = 5000

FROM

#Tb1 t1 INNER JOIN #Tb2 t2

ON t1.id = t2.id

May be you can try the below query....I hope it works :D:D

WITH StepCTE

AS

(

SELECT from_step_id, to_step_id, 0 as rlevel FROM yourtable WHERE from_step_id = 0

UNION ALL

SELECT CTE.to_step_id, T.to_step_id, CTE.rlevel + 1...

You can use the link what Tommy has provided...

I wondering what errors you're getting in date calculations...:cool:

May be you can have a look at your server's default date/time settings...