Excellent post, Steve.  What we need now is someone that's an expert in QA or an expert system designer to provide people that write requirements with knowledge and techniques the...

A much better idea is to find out why the batch job is taking 7 hours.  Is it actually because this stored procedure taking 7 seconds?  While that may certainly...

This is a duplicate post.  Please use the following link to get to the duplicate and the answers.  No posts on this link, please.  It will only dilute the information...

I end up having that same problem.  I did the very same thing yesterday.

Unfortunately, this is a 2008 forum and so the IIF functionality will need to be converted to CASE statements if you're truly using 2008.

Thanks Jonathan for the query... 🙂

Output data is coming correctly but is it possible to get output data into corresponding pivoted columns.

I attached sample data in excel for better...

I think that Jeff has covered most of the salient points involved with using synonyms.  I have used them for everything allowable, including stored procedures.  We had a routine...

Jeff Moden,

Thanks for your input.  I am familiar with IF statements and looping statements a bit.  Your example will help me to get use to the programming side of...

From the Article

Plenty of others are trying to help you build a smoother database DevOps process, including Microsoft.

DevOps is NOT a process! 😉

As many folks do, we have many databases associated with one "system".  We have many uses for synonyms.

It's important to also know that database naming can change and tables can...

To add to what DesNorton posted, you can also check for existence of a constraint and take a conditional action in T-SQL.  For example...

   ...

Awesome job, Michael!

I know it'll sound strange for me to say so but I'm also impressed that you took the time to discover the setting...

I...

I might be missing something but that looks an awful lot like JSON.  Is it?

Thanks for your input. I've done some thinking about this and might be able to work something out querying the sys.syslogins. Since a trigger will catch every login it's...