Try this one.......

Declare @position Varchar(255)

Set @position ='Product Development Manager'

;WITH H_LIST AS

(

SELECT S.LevelID, S.Position , S.ReportingLevelID , 0 AS H_LEVEL , S.Position AS STRING

FROM dbo.SampleOrg S

WHERE S.Position = @position

UNION...

Please cast month, day and year into varchar to get rid out of it.

Hi Catcha,

Do u got what you was looking for ??

Thanks,

Amit Khanna

Hi Sg,

WITH C_TEMP AS

(

SELECT T.num,T.OP_Bal,T.quantity,T.OP_Bal + T.quantity AS Closing_Bal

FROM #Temps T

WHERE T.num = 1

...

Another alternative may not be the best one

SELECT

YOURCOLUMN,

CASE WHEN PATINDEX('%[~,!,@,#,$,^,&,*,(,),_,+,=,-,|,\,:,;,",?,/,.,>,<,`]%',YOURCOLUMN) !=0

THEN 'Non - Alphanumeric'

ELSE 'Alphanumeric'

END AS FLAG

FROM YOURTABLE

Thanks,

Amit Khanna

Try PATINDEX Function.

In the sub query following sub query , replace "select * " with " select top 1 1 " as it will not be useful with correlated subquery.

Thanks,

Amit Khanna

Thanks chirag for the compliment. 🙂

yes arjun you are right..

Hi,

Please find the below code:

WITH C_TEMP AS

(

SELECT T.num,T.OP_Bal,T.quantity,T.OP_Bal + T.quantity AS Closing_Bal

FROM #Temps T

WHERE T.num = 1

UNION ALL

SELECT T1.num,C.Closing_Bal,T1.quantity,C.Closing_Bal + T1.quantity AS Closing_Bal

FROM #Temps T1

INNER JOIN C_TEMP C ON...

Hi Catcha,

Please find the code below:

Declare @position Varchar(255)

Set @position ='Project Lead'

;WITH H_LIST AS

(

SELECT S.LevelID, S.Position , S.ReportingLevelID , 0 AS H_LEVEL

FROM dbo.SampleOrg S

WHERE S.Position = @position

UNION ALL

SELECT S1.LevelID,...

Hi Dr. Andras,

Is there any freeware tool that read the transaction log out of those that you are mentioned ?

Thanks,

Amit Khanna

SELECT * FROM SYS.TABLES WHERE NAME LIKE '%string%'

where string is word or table name to be serached

Thanks,

Amit Khanna

Please give the exact scenario as the Performance depends upon many factors.

It depends upon data and requirement.

Thanks,

Amit Khanna

Hi.

id Code Text Parent

001 A ...

Hi kumar99ms ,

Can you please elaborate your question clearly?

Thanks,

Amit Khanna