It's called parameter sniffing. Basically the first time you execute the SP a plan is generated and saved. But that plan is generated based on the value of...

Thanx for the info .

Any type.

The only information about indexes is if you create a unique index or primary key. Then the creation date information would be available in sysObjects.

Well you can... but you MUST expect errors if you do that, so don't .

HTH.

Yes but like this :

FROM Table1

LEFT OUTER JOIN Table2 ON Table1.Id = Table2.Id

LEFT OUTER JOIN Table3 ON Table2.id = Table3.Id

Is it just me or you posted the same code twice??

Assuming you meant to swap the inserts, it will fail because the foreign key will cancel the transaction because no...

That's why you keep this stuff for the friday afternoons .

That's the problem. That route creates a new job. You need to do in the sql server agent section and you'll see the times where it has been...

Something like this?

Select Columns from dbo.TableName where StartDate @EndDate

Where is it showing 12:00AM and at what time are they scheduled?

Post the table definition, some sample data and the required results... I'm sure we'll figure it out.

Select

CASE WHEN CaseStatus = 'closed' THEN 'Closed' ELSE NULL END AS Closed,

CASE WHEN CaseStatus 'closed' THEN CaseStatus ELSE NULL END AS Opened

from ...

What do you want to do with that file afterwards?