Yes like this:

DECLARE name CURSOR ...

FOR SELECT ....

OPEN name

FETCH NEXT FROM name INTO @var

WHILE @@FETCH_STATUS = 0

BEGIN

... Do some work

...

You should move your second

FETCH Next From MPDV INTO @QId,@MPDV,@answer,@dtLogged,@strRemarks,@strLogged

inside of loop

The same is for

FETCH Next From Pers INTO @Personnel

I guess it's cut-&-paste one 😉

Script file is the text isn't it?

So nvarchar(max) is the best for this. There is an option to store nibanry data in ntext, text ot image datatype, but it's...

SQL2000?

Good Luck!

Ok, you will need to use temp table:

SELECT IDENTITY(int,1,1) idn,

0 AS RN,

...

You are posting to fast 😀

Check the previous post!

If your scripts...

karthikeyan-444867 (8/17/2011)

---

I just came to know i need to implement the same against a table data.

CREATE TABLE W

(

ID INT,

val varchar(255)

)

insert into W

select 100, 'D,20.5%,10.25%,A account is being linked to B...

Not bad, but try to set your input variable to:

select @_sPlatform = 'D,20987987.5%,A account is being linked to B account'

Sample I've gave you would work;-)

However, using Tally method would...

sharath.chalamgari (8/17/2011)

---

but still the statement in the link you provided says that

"After declaration, all variables are initialized as NULL, unless a value is provided as part of the declaration."

so when...

It's duplicated thread from TSQL(2005) forum...

As you ingoring the forum advise to present your question in a polite way, I can only show you a generic sample:

DELETE fk

FROM TableWithFK fk

JOIN TableWithPK...

If your read: http://msdn.microsoft.com/en-us/library/ms188927.aspx

You will find that the scope of a local variable is the batch in which it is declared (you are not in c# or vb :-)).

That's...

Jason-299789 (8/17/2011)

---

I've never come across this syntax in 10 years of T-SQL programing, but its good to see it, and the explination for it.

I think 98% of people would...

Yep, as simple as this:

declare @_sP varchar(1024)

select @_sP = 'D,20.5%,10.25%,A account is being linked to B account'

declare @cA varchar(1024),@cB varchar(1024),@cC varchar(1024),@cD varchar(1024),@p int

SET @cA=@_sP

SET @p=CHARINDEX(',',@cA); IF @p>1 SELECT @cB=SUBSTRING(@cA,@p+1,1024),...

If you are splitting just one single value, anything would do!

You can use just SET operators to check next position of comma and to get one value after another.

If you...