i've done a CLR which sends email, but that assumes you have the ability to install CLR assembleis on your machine; .NET has the built in classes to do that,...

ok this got interesting so i did the whole thing.

enjoy!

/*

valSkills

000010010011,8,64

0101111111,2,4,8,16,32,128

101011,4,16

10101004,16,64

*/

;WITH myStrings (val)

AS (

SELECT '00001001001' UNION ALL

SELECT '10101' UNION ALL

SELECT '1010100' UNION ALL

SELECT '010111111' )

,

FormattedStrings AS (

SELECT val,

right('0000000000000000000000000000000'...

Erin i have this saved in my snippets, that will get you 90% there;

this is enumerating the bits as to wether they are true or false.

;WITH myStrings (val)

AS (

SELECT '00001001001'...

a lot more information as far as details would help, but

if the data is important line by line, then for me, each line should be stored as a row/column in...

you said "Ignore the Data3 column"

if i do that, each set you posted are identical, with the exception of the id column, which seems to be incrementing?.

it seems the only...

Stubby Bunny (3/21/2014)

yes, I can see the trace, there is only one going, reading something about a defaut trace that runs on sql server, but whomever set up this server...

the trigger is always in an implicit transaction.

if your procedure is trying to update the same table the trigger is on, it will block itself, and can never complete.your proc...

by import, do you mean insert?

typically i would join the new data against the destination table,and check...

first, make sure it hit the queue,a dn see if there is an error in the mail logs.

do you see your email in this select?

SELECT

sent_status As Reason,

err.[description],

...

yep it's possible, but it's not built in.

using the GUI or via SMO is infinitely easier; I know, because i poured weeks of effort down the TSQL-only method, and it's...

i've got SQL Enlight for SSMS, which is a static code reviewer, and it identifies all the missing semicolons , along with other best practices for SQL.

it's not cheap...

somewhere in your package, you've got a flat file connection manager.

if you go to it's details, and go to the columns column, you can change the column delimiter from a...

i would not put too much value in the local ip address; SQL's configured to listen to multiple ip addresses(including 127.0.0.1), and you can review them in the server configuration...

single table backup is a manual process, which is what the question is testing your knowledge for.

since you cannot take the application offline, which means you cannot restore the current...

a linked server , when joined against local data, is very slow.

what actually happens is the entire table from the linked server is copied over into local tempdb, and...