A string splitter such as the delimitedsplit8k that can be found here on SSC would be a good start if the data is concatenated into a single string. This...

Thanks for the fun one today Steve.

I use VMs for a few different things.

I use VMs for my lab. I also use them to keep VPN clients separate.

Here's a series of articles I did on...

Barrier

?. ??, ????? ?? ??

Jack Corbett (2/13/2014)

---

Now onto the reason I had time to catch-up today. I was informed that due to financial problems at my now former employer, my position...

You can do that via a logon trigger at the server level.

Here is an article on that

http://jasonbrimhall.info/2010/04/06/ip-and-default-trace-t-sql-tuesday-005/

with just a couple of characters replace works quite nicely.

Another option that people use from time to time is a function that loops through the string to replace characters. ...

Try this article.

http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/

Eugene Elutin (2/13/2014)

---

Don't you worry, you are not alone!

Threre are plenty of cowboy developers around....

😉

Are...

You're welcome

You are welcome.

David answered the $ question. ...

David Burrows (2/13/2014)

---

It is to move the minus...

The use of sp_MSforeachdb can have unintended results. It will occasionally miss databases. There are better methods (such as a cursor - and considering msforeachdb is just a...

If you were to be using SQL 2012 or 2014, then this would work

DECLARE @dollar TABLE (id INT IDENTITY(1,1),Cost INT)

INSERT INTO @dollar

(...