Looking at the execution plan it seems like the statistics for PostingYTD are "slightly" off (estimated 43k rows vs. actual 2.000k rows).

Is there any index maintenance performed regulary?

New question - new...

Please remove the last line

@database_name = N'master', @flags = 0

and the preceeding comma.

I accidentally copied the last two parameter of the sp_add_jobstep parameter. I'm sorry.

Ok, here's a first draft that might help you to get started.

After a closer look to the code you've posted I don't think there's a need to use a parameter...

I guess you're not referring to those on the ground, are you? 😀

Are you familiar with writing stored procedures?

I would break the sproc into three parts:

1) get the html table and assign it to @tableHTML

2) depending on an input parameter create [TJC_Custom].[dbo].[tblDailyJobStatus]...

Evil Kraig F (2/27/2012)

Jeff Moden (2/25/2012)

This is a YouTube video just...

Wouldn't it be easier to use a stored procedure that would create the html formatted table as a nvarchar(max) variable and call that sproc with @command?

I, personally, wouldn't put that...

Did you try to use UNPIVOT with tab1 to get a table with whatever_symbol, whatever_description and whatever_value that can be used in a join on with your current query (or,...

So, is SaraGate a new name for RedGate? :unsure:

And, thank you, Brandie. Now I know there's a key required. So the area seems to be locked. I'll keep asking questions...

Koen Verbeeck (2/27/2012)

This one obviously is (on another site):

interview questions

...

I wonder how he managed to get so many questions. If he doesn't know any answer after 5 questions, I would've...

Your requirement looks like a wildcard search:

WHERE (((CABWO_WO_DETAILS.TITLE) Like "*" & [Please Enter WO Title] &"*"));

@r.P.Rozema:

I absolutely agree. Completely missed the fact that we have a "known scenario" for step 2.

I'd go for the CHARINDEX approach then. Thank you for the correction!

Let me quote from my previous post:

Hi Richu,

I'm not sure if this is what you're looking for (especially in terms of the SED nodes), but here's something to start with:

SELECT

'@name' = n.Name,

'@desc' = n.Descr,

'Address/@name'...