Viewing 15 posts - 12,436 through 12,450 (of 18,923 total)
Implement change management and see what you changed. other than that sql server doesn't keep that info.
October 24, 2005 at 9:47 am
Select top 1 PosterID from Replies where ThreadID = @Somevariable order by PostDate DESC
October 24, 2005 at 9:03 am
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...
October 24, 2005 at 8:53 am
Is the query you are executing exists as a saved query?
October 24, 2005 at 8:43 am
Not a diplomate.
Not gonna stand having someone blatantly lie to me and expect me to be nice about it.
October 24, 2005 at 8:41 am
Redo the backup and resend maybe???
Then go do the restore for him if it still doesn't work ![]()
October 24, 2005 at 8:12 am
Yup, that ranks everyone... but the subquery can be used to evaluate only one of the members, speeding up the process in the meantime.
October 24, 2005 at 8:11 am
READ THE LINK.
The Curse and Blessings of Dynamic SQL
and don't ever lie to me again... I'll still know it.
October 24, 2005 at 8:09 am
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.
October 24, 2005 at 8:03 am
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...
October 24, 2005 at 7:51 am
Not the way you're doing it. You should use static sql for this.
UPDATE dboTable set Col1 = @Param1, Col2 = @Param2 where DateKey = @DateVariable
October 24, 2005 at 7:34 am
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...
October 24, 2005 at 7:27 am
CREATE NONCLUSTERED INDEX IX_FuelCOMP ON dbo.Fill (filldate, companyno)
October 24, 2005 at 7:16 am
Viewing 15 posts - 12,436 through 12,450 (of 18,923 total)