You can use a CTE in combination with a MERGE statement. Something along these lines should work for you:

WITH cte

...

Please post the DDL for your tables, some DML to create sample data and the desired resultset.

if you have questions as to what I mean please read this article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Hey Jeffery, I am not seeing a -S on your new bcp command-line. If it is not provided bcp will try to connect to the local default instance. Is it...

That's one a my biggest strengths and biggest weaknesses 😀

There is a lot going on in the thread you linked to...can you please post the connection string you are now using, the one that solved your data type problem?

My take-away is to use config files (or tables) for parameter data 😀 Thanks for posting back.

Congrats on getting people out of the sysadmin role! That's a huge win!

Unfortunately (for your situation) a login can only be associated with one and only one Database User in...

Progress...excellent. Please post the code you're trying, including the DENY statement and the EXECUTE AS code you're using to test the permission change.

I promise I am not making this stuff up 🙂

Things to check:

1) are you in the right database?

2) does the username sqluser1 exist in that database?

3) do you have sa...

It's a bit of a hack, and you still need to test, but you can use the Table Designer^Edit Query Designer in SSMS to convert queries for you. The majority...

This video demos the ForEach Loop container in SSIS which may be able to help you to arrive at a solution:

http://www.sqlshare.com/looping-through-and-loading-files-with-ssis_34.aspx?searchid=155499

Ditto. Good luck 🙂

Lutz has a link to it in his post, but links are not easily visible in this forum so in case you missed it you can read this article: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

It...

I recently read this whitepaper ( http://research.microsoft.com/apps/pubs/?id=64525 ) while researching the same topic, however it was strictly for academic purposes. I have not been pressed to decide whether to implement...

If you're looking for any row with a value that contains a character that is not 0-9 then drew.allen's solution will work but that seems slightly different than what you...