COOL 🙂

There are lot of date format in sql server. Use "CONVERT" function for neccssary data format.

And also ref this URL:

http://msdn.microsoft.com/en-us/library/ms187928.aspx

Hi Timothy,

Normalization and decoupling are one and the same?

Change the datatype as datetime instead of int and then check.

Can you check the Event Viewer, what it says?

DECLARE @STR NVARCHAR(888)

SET @STR = '43.39985323'

SELECT SUBSTRING(@STR,1,CHARINDEX('.',@STR) + 4)

Try some thing like this....

DECLARE @Cnt int

DECLARE @CASCADELevel TABLE

(

AID INT,

ADESC nvarchar(max),

BID INT,

BDESC nvarchar(max),

CID INT,

CDESC nvarchar(max),

DID INT,

DDESC nvarchar(max)

)

;WITH CTEDELETE (AID,ADESC,BID,BDESC,CID,CDESC,DID,DDESC,Level)

AS

(

SELECT

A.A_ID AS AID,

A.[DESC] AS ADESC,

B.B_ID AS BID,

B.[DESC] AS BDESC,

C.C_ID AS CID,

C.[DESC]...

Its good to learn something like this 🙂

Thanks

Good Question. Thanks...

But, can you tell me how to delete the "@Sql_str" string value without restarting the sql services?

Thanks Gail ...

Please elobrate more on Index Scan Properties. 🙂

Yes, you are correct. It would be better if you are going to delete like E,D,C,B and then A.

ohh ... yes, that makes good... 🙂

Thanks for your reply.

There are 10 different part of script for 10 issues....

Thanks for your reply.

I think i believe,it will through...