Here is one way:

-- Setup the variable for testing

Declare @value varchar(1000);

Set @value = 'select * from table 2 where something in (''a'', ''b'', ''c'')';

Select @value; -- this will look...

GSquared (6/3/2008)

---

I may be misunderstanding something here, but SQL Agent runs steps sequentially. It finishes each one, tests for success or failure, then does whatever has been set as...

The Execute SQL Server Agent Job Task starts an agent job - but does not wait for that agent job to complete.

The is the same as executing the following:

Execute dbo.sp_start_job...

Animal Magic (6/2/2008)

---

from the look of Jeffs post it looks like the CPU usage is taken in snapshots, and they are the results you are seeing in the table. ...

jryan_pun (6/1/2008)

---

thanks for you reply.. i appreciate all.. more than a month i edit this code but i cannot solve.. can you help if i need your help.. because im...

If I understand correctly, you have a view that is timing out. Can you post the definition of the view so we can see what is happening?

Yes - it is with the like statement that would cause an index scan. And, yes - using full text search would be a better solution if you need...

The first issue I see is this:

WHERE

(@Param1 = 0 OR Field1 = @Param1)

AND

(@Param2 IS NULL OR Field2 LIKE '%' + @Param2 + '%')

Prefixing your search criteria with a wildcard...

jarmstrong (6/1/2008)

---

I'm trying to create a query that uses a returned column as part of the name of another column in my query. Here is the code that I am...

Download SQL Server 2005 Performance Dashboard reports. The main report has a chart that shows CPU utilization.

If you really want to run a SQL statement that does this, then...

I don't know if there is a limit - at least, I cannot find anything that says there is. However, when I find that I have a very large...

Adding to what Matt stated - I see no reason to use dynamic SQL here. This can all be rewritten as a standard select statement. I have rewritten...

I think you can use the index id instead of the name in your table hint. Since you will only have a single index on this table - INDEX=1...

MohammedU (5/30/2008)

---

Either include the batch file process in the maintenace plan job as a first step or

check the file existance using xp_CMDSHELL OR some other extended proc and move to...

gwade (5/30/2008)

---

Excellent point about the index scan, Jeff.

I'm wondering with the new expresssion, if the date that the query is run is 2008-05-30 13:25:23.723 and the expiry value is...