Well you can't use a subquery in CONTAINS like that. What exactly are you trying to do here? This looks like part of where clause in dynamic sql but your...

So is this a question or just explaining how you fixed it?

Do you get an error message? Is the sql service running?

Jeff Moden (5/24/2012)

---

dwain.c (5/24/2012)

---

Jeff - I've been a fan of this splitter for a long time even though I've been a slow adopter, 🙂 recommending it highly around my office...

Do these jobs call stored procs? It could possibly be parameter sniffing.

ananda.murugesan (6/20/2012)

---

as of now all the database sql 2008 collation is SQL_Latin1_General_CP1_CI_AS but still database user password working as case senstive only.. how to reslove user password case insenstive? which...

mvillegascuellar (6/19/2012)

---

Sean Lange (6/19/2012)

---

That is a bit vague in requirement but there are some things you can do. Are these queries pass through queries or stored procs? That will make...

This works on your sample data. I added the outer query because at least in your sample data the first row has a Event_Type_Id = 3. In the real data...

Excellent!!! Glad you get it working and thanks for letting me know. Super cool of you to post your solution so others can glean some info from your hard work....

Grant Fritchey (6/19/2012)

---

All the hints included in a query are stored with the execution plan, so you could query the plans, using XML, to pull the information out of the...

That is a bit vague in requirement but there are some things you can do. Are these queries pass through queries or stored procs? That will make a big difference...

From your description it sounds like a solid design.

For your query question, you said you had around 60 meters? So you want a column for every meter? That isn't...

river1 (6/19/2012)

---

and inside the proc 1

proc 2

...

Siten0308 (6/19/2012)

---

Hello Dwain,

maybe you can help me answer my other question, which might solve the problem, i am going to make a temp table, then insert the records I want...

ramadesai108 (6/19/2012)

---

Hello All,

I ended up doing this and it worked:

AND ',' + @EmployeeId + ',' LIKE '%,' + CAST(e.ID AS varchar(10)) + ',%'

Thank you all for...