You mean your mother??

Implement change management and see what you changed. other than that sql server doesn't keep that info.

HTH.

Select top 1 PosterID from Replies where ThreadID = @Somevariable order by PostDate DESC

Here's an exemple of what you have to do. This returns a scalar vaue but it could as well return a recordset or not be used as a function...

Is the query you are executing exists as a saved query?

Not a diplomate.

Not gonna stand having someone blatantly lie to me and expect me to be nice about it.

Redo the backup and resend maybe???

Then go do the restore for him if it still doesn't work

Yup, that ranks everyone... but the subquery can be used to evaluate only one of the members, speeding up the process in the meantime.

READ THE LINK.

The Curse and Blessings of Dynamic SQL

and don't ever lie to me again... I'll still know it.

You can't use your own query definition and a stored definition at the same time.

If you are using a stored query, then you must set the parameter values.

Let me rephrase what I meant this whole time in clearer terms.

1 - You totally missed out the real point of store procs.

2 - You're going against every...

Not the way you're doing it. You should use static sql for this.

UPDATE dboTable set Col1 = @Param1, Col2 = @Param2 where DateKey = @DateVariable

Select whatever, (Select count(*) from sameBaseTable where AllTheRowsThatComeBeforeThatOne) AS Rank from BaseTable

would work great if there's never more than one row to retrieve... but still waiting for an answer on...

CREATE NONCLUSTERED INDEX IX_FuelCOMP ON dbo.Fill (filldate, companyno)