Viewing 15 posts - 196 through 210 (of 345 total)
I've never seen that before. So ?currentdb.Name in the immediate window does not return the correct path?
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 24, 2011 at 9:44 am
james.morrison 19355 (6/22/2011)
mike.mcquillan (6/22/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 23, 2011 at 9:15 am
Ninja's_RGR'us (6/22/2011)
Nope and I'm on a )*(/$"*(U case sensitive server.
Ya, major PITA. Screw everything about that. :pinch:
On both my 2005 and 2008 servers, I get
Msg 4104, Level...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 22, 2011 at 3:29 pm
Very nice club to have in the bag. Saved.
I had to qualify this part
FROM
...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 22, 2011 at 2:58 pm
So here is my update, as promised, unabridged. I put the additional column and new trigger into production yesterday...and a part I didn't test before, the generate billing screen, returned...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 22, 2011 at 12:55 pm
You have to be very careful with this type of trigger. It's an UPDATE only trigger, which means if someone updates the date received field by itself in the ReceiveOrder...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 22, 2011 at 9:07 am
This is what your query looks like when formatted, but seems like an extra parentesis is at the end:
select answered = sum(
CASE WHEN
sf.answerNumeric IS NULL AND (sf.answerText IS NULL...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 21, 2011 at 12:32 pm
What do yall think about giving the interviewee a "broken" database to analyze? Script out one of your databases except remove some indexes, rewrite a basic update statement to use...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 21, 2011 at 11:04 am
tfifield (6/10/2011)
Messing with proprietary apps like this is probably asking for more trouble than it's worth. I've had to do it and I've found it's usually easier and more...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 16, 2011 at 9:47 am
chelta (6/14/2011)
...I'm attempting to print out the statement, however that is not helping either as it will not print when there is a variable name for the database name.
Why not?...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 15, 2011 at 12:30 pm
Use something like this to create your view (this creates a view a script that creates a view that combines all of my _Contacts tables, obviously.):
DECLARE @My_View VARCHAR(max)
DECLARE @stmt VARCHAR(1000)
PRINT...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 15, 2011 at 11:53 am
We use SQL Diagnostic Manager. http://www.idera.com/Products/SQL-Server/SQL-diagnostic-manager/
Lots of green and red buttons and dials and charts and alerts!
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 15, 2011 at 10:58 am
rjshupert (6/15/2011)
(COALESCE(Database_Status,Instance_Status) = N'deployed' or is null)
And it's now displaying the expected results. Thanks so...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 15, 2011 at 9:02 am
Coalesce returns the first non-null argument in the list. So this statement will compare Database_Status when it is non-null, but compare Instance_Status when Database_Status is null.
Check out http://msdn.microsoft.com/en-us/library/ms190349.aspx
You can also...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 15, 2011 at 8:55 am
If you want to switch on null, use this
WHERE
(COALESCE(Database_Status,Instance_Status) = N'deployed')
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 15, 2011 at 8:35 am
Viewing 15 posts - 196 through 210 (of 345 total)