I don't know whether this is an option for you, but you can encrypt your package (or parts of it) by user key, which means nobody would ever need to...

REVERSE the string, use SUBSTRING, and then REVERSE it again.

John

I agree with others that this is a bad idea. Would you be able to tell us more about the reason for the requirement, please - we may be...

Since I can't see the picture you attached, my advice can only be very general: use a FOR XML clause to concatenate values from different rows into a single row.

John

That's the name of the table you gave in your original post.

John

Several ways to do this. Probably the easiest is something like this:

INSERT INTO #order

EXEC xp_cmdshell 'dir /b \\order\2016'

John

I copied and pasted those very words into my favourite search engine. The question was answered in the very first result.

John

The first thing I would try is to change SQL Server Agent to run under a domain account instead of a built-in account. I appreciate that it's frustrating that...

It's not what you can access that's important - it's what SQL Server can access. If I remember correctly,...

Not necessarily. The query below...

Grumpiness will be the least of your worries. It will be more difficult to validate entries, and you're breaking the rules of normalisation by forcing two attributes into one...

You can't fit a square peg into a round hole. If you don't want to add and extra column to t3, you'll have to resort to unsatisfactory methods such...

Do you have sp_whoisactive on your server? If not, look it up, install it on a test server, and when you're happy with it, put it on your live...

Gail is right about Task Manager, of course. But even if we assume Task Manager is telling the truth,...

What details of the password policy are you looking for? As far as I know, the password policy is inherited from Windows and doesn't change from login to login.

John