Viewing 15 posts - 6,601 through 6,615 (of 13,469 total)
it looks like you are testing the number of records that match...so i'd cosnider changing ti to simply IF EXISTS:
IF EXISTS(SELECT f.name
...
October 10, 2011 at 2:04 pm
YSLGuru (10/10/2011)
October 10, 2011 at 1:14 pm
GSquared (10/10/2011)
Are you just auditing the commands, or do you need to audit the actual data changes as well?
C2 will audit both, but...
October 10, 2011 at 12:13 pm
no...I say use the undocumented stuff whenever it's needed.
technically sp_MSForEachdb and sp_MSForEachTable are undocumented and unsupported, but widely used.
many times, MS is calling something an "undocumented feature", but added needed...
October 10, 2011 at 7:32 am
maybe i'm oversimplifying, but can't you simply wrap the query results with the RANK function ?
SELECT RANK() OVER (ORDER BY [MashupMetaInfo_Id], MashupMetaInfo_Title, MashupMetaInfo_Tag) AsTheRank,
MySubQuery.*
FROM
(
...your original query goes here....
) MySubQuery
ORDER...
October 10, 2011 at 5:38 am
yes, Full Text indexing has a thesaurus ; so if you searched for "camero", that's a synonym for "chevy"
you can do the same for expected misspellings of your search terms,...
October 9, 2011 at 6:16 am
reformatted for readability:
SELECT wooBillingAmount_Cp,
worIsBillable,
bcoUserValue1,
bcoID,
...
October 8, 2011 at 9:12 am
Steve Jones - SSC Editor (9/16/2008)
Which results?The alias ones? Use
where [10%] > 1000
Jeffry Williams nailed the right techniques;
you can reference an alias in the ORDER BY clause, but not the...
October 8, 2011 at 8:20 am
one of the more advanced features in SQL Server is the ability to use Extended Events.
those events allow you to capture certain events and respond to them asynchronously, like logging...
October 7, 2011 at 1:09 pm
shilpa.shankar87 (10/7/2011)
Hi Friends,Is there any way to get email notifications from triggers if any new db is created in the sql server?
Thanks in advance.
you would have to use Extended...
October 7, 2011 at 11:36 am
when the trace is running and active, the operating system will not be able to report the file size, so it's not suprising it's still showing 0kb;
only when a rollover...
October 7, 2011 at 11:31 am
WaitingWonder2 (10/1/2011)
October 6, 2011 at 12:49 pm
Tom would some4thign like this bee what you are looking for?
select
InvoiceNumber,
InvoiceDate,
Month(InvoiceDate) AS Mn
from sometable
where InvoiceDate < dateadd(dd,-45,getdate)
Group By
InvoiceNumber,
...
October 6, 2011 at 11:15 am
Ninja's_RGR'us (10/6/2011)
Lowell (10/6/2011)
Ninja's_RGR'us (10/6/2011)
you're telling the server to do this, which is impossible :update set colum = (SELECT col1, col2, ... FROM )
sigh...Ninja'd again...well deserved nickname, for sure.
Well you...
October 6, 2011 at 6:32 am
Ninja's_RGR'us (10/6/2011)
you're telling the server to do this, which is impossible :update set colum = (SELECT col1, col2, ... FROM )
sigh...Ninja'd again...well deserved nickname, for sure.
October 6, 2011 at 6:24 am
Viewing 15 posts - 6,601 through 6,615 (of 13,469 total)