You might want to read:

http://msdn.microsoft.com/en-us/library/ms190686(v=sql.100).aspx

Which states:

When a stored procedure is created, the statements in the procedure are parsed for syntactical accuracy. If a syntactical error is encountered in the procedure...

sathishkumar.k (2/8/2012)

---

Great question... Is that mean when any object with SP_ prefix used in combination with if (as in this case) would be searched in the current DB first and...

Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at...

Good question - jogged my memory and by gosh I had not forgotten it.

Unless it is extremely important to you now I suggest you leave things as they are. Why do I say that - well read the following:

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

Which in part states

In...

SGT_squeeqal

If you do use a cursor, you might want to compare its performance with a

CTE such as this sample. I believe if you do and have a reasonable

number of...

I suggest you read the following before upgrading.

http://msdn.microsoft.com/en-us/library/ms144267(v=sql.90).aspx

And understand the effect of the upgraded database by reading about the compatability mode at:

http://msdn.microsoft.com/en-US/library/ms178653(v=sql.90)

SGT_squeeqal (2/6/2012)

---

Bring you results into a cursor and then use rowcount -1 row to delete like for example, this will then delete all your duplicate rows bar 1

declare @col1 datatype,

@col2...

I suggest you start reading here:

http://sqlcat.com/sqlcat/b/whitepapers/archive/2007/12/16/sql-server-2005-security-best-practices-operational-and-administrative-tasks.aspx

preetpalkapoor (2/6/2012)

---

Thanks every one for your support.

i got 3 methods to do that.

1. To make temp table with i will check with my real time DB and is the easiest...

Including them inside the SQL statement

-- + 1

Might not be bad form, but I can just image the list of...

pwalter83 (2/6/2012)

---

Thanks Ron,

But the thing is I dont wish to join the values, instead...

You might want to read this and then decide which method is best for you situation

http://blogs.msdn.com/b/sqlcat/archive/2008/10/09/table-variable-vs-temp-table-and-estimated-vs-actual-query-plan.aspx

Once you have eliminated the commas then use

DECLARE @Res VARCHAR(10)

SET @Res = 'KNL RTM'

SELECT REPLACE(@Res,' ','')

Result:

KNLRTM