Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 10
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 10 votes cast
Mar
2
accepted Field Prerequisite on Another
Mar
2
comment Field Prerequisite on Another
Brilliant, this is precisely what I needed, thank you. Your truth table is exactly what I wanted and yes of course my bits are non-nullable. Cheers! :)
Mar
2
asked Field Prerequisite on Another
Dec
17
awarded  Notable Question
Dec
8
awarded  Popular Question
Nov
28
awarded  Popular Question
Jul
2
awarded  Curious
Nov
25
awarded  Popular Question
Jan
28
accepted Conditional WHERE clause
Jan
28
comment Conditional WHERE clause
Brilliant use of COALESCE! I would have never thought of that. :) I also added set @filter = nullif(@filter,'') just before that to ensure an empty string is never passed in which would create an invalid SQL statement. I also if object_id(N'tempdb..#tbl') is not null drop table #tbl before the #tbl create to ensure I'm starting with a clean slate.
Jan
28
comment Conditional WHERE clause
I probably should have stated that I would LIKE to use a table variable because I prefer to keep my SQL clean rather than dealing with a bunch of temp table cleanup and if-else statements.
Jan
28
comment Conditional WHERE clause
@StrayCatDBA For future reference, would this create a permanent defined type in the database? Server? Thanks for the answer anyway! :)
Jan
26
asked Conditional WHERE clause
Jan
11
comment SQL Server Event Alerts Lack Enough Details
@mrdenny That's very unfortunate. This level of error logging is completely useless to me then as it provides no means of investigation the cause of said errors. Why is virtually everything about SQL Server Administration so disappointing until 2008 and above? :(
Jan
10
comment SQL Server Event Alerts Lack Enough Details
@mrdenny SQL Server 2005
Jan
10
comment SQL Server Event Alerts Lack Enough Details
@MitchWheat For example, the Server they were trying to login to? What application were they using? Etc. In this case the user is a utility account which is using SQL Server authentication and is used for many of our applications to connect to various databases.
Jan
10
asked SQL Server Event Alerts Lack Enough Details
Dec
19
awarded  Commentator
Dec
19
accepted Securely Send Database Mail via an Insert Trigger
Dec
19
comment Securely Send Database Mail via an Insert Trigger
@CadeRoux Wow! I had no idea SQL Server actually had built-in EmailQueues, I was reading up on them and they're FAR more robust than our queue tables. Wish I had time to re-architect our whole email paradigm, but alas I have only 2 days left so it will have to be the quick fix for now. :( Thank you so much for all your wonderful advice. :)