Your search condition exceeds the maximum length for a varchar which is 4,000. You are trying to pass it over 6,000 characters.

Check out BOL for CONTAINS, http://msdn.microsoft.com/en-us/library/ms187787.aspx

A quote from that...

You are welcome. Glad I was able to help you find a solution and thanks for letting me know.

I use KeePass and like it well enough. I able to synch the password file between my desktop, laptop and phone. Really makes it handy and since I have copies...

Or even simpler would be to change the loop condition.

WHILE EXISTS(SELECT * FROM #TempTable)

You posted in the sql 7, 2000 forum. Are you actually using an old version of sql?...

GilaMonster (7/17/2013)

---

You can't put an Order By...

krypto69 (7/17/2013)

---

Hi,

I have a project I'm working on that has two SQL tables. I need to create a query that joins the two tables by org level and by date.

Table...

riya_dave (7/17/2013)

---

hi

my query is giving me erro

delete top(1000) from table a

join table b

on a.id = b.id

and b.date < getdate()

error: incorrect syntax near a.

i want to delete top 1000 from...

s_v_narayanan (7/17/2013)

---

Thanks for the reply.

Please find below the sample and expected output -

CompanyCustomer IDAccount IDAmountTransaction Date

100 C001 ...

I would suggest that using XML is not going to be as fast as the one found by following the link in my signature about splitting strings. That article has...

Glad that worked for you and thanks for letting me know. Come back anytime you need help.

jplankenhorn (7/17/2013)

---

I have a stored procedure that passes in several parameters that can be blank or a list of selected filter values. For each parameter, I split the values...

twoeyed (7/17/2013)

---

Thank you for your reply Sean.

The query is generated by an application, so not much room for change at query level.

You are right in saying that the list is...

Here is a rough stab at converting this to the newer join syntax.

SELECT 'SELECT ' AS [Selection], C.[OPCD] AS [OpCode], C.[DSCT] AS [Description]

FROM t2 A

join t3 C on A.[OPCD] =...

Parameter sniffing.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D

Also, you should consider using the ansi-92 style joins instead of the older style joins. You also have a number of nonSARGable predicates.

Can you turn the list of 25,000+ hard coded values into a table? I have never come anywhere close to a list that extensive like this. I am 99.999% certain...