I usually do that to get a single value but don't have a clue why I did that....

First, I don't know if you noticed or understood the motivation by Luis' comment in his code about why he changed it to varchar(8000) from varchar(max). You only want to...

It is worth noting that you will need an ORDER BY in your OVER clause for this to work.

I terminate all my SQL statements with a semicolon because, apparently, you are supposed to. If anyone is interested in an intellectually stimulating article on the subject see Itzik Ben-Gan's...

First, below is a simple and easy solution that is much less complicated than a loop-based, multi-variable solution. It also performs quite well (for when performance does matter).

DECLARE @rng-2...

I think there are three problems:

1. The genuine need for talented data pros is growing much faster than the supply of talented data pros.

2. Many (perhaps most) companies...

Brandie Tarvin (11/30/2015)

---

Luis Cazares (11/30/2015)

---

Brandie Tarvin (11/30/2015)

---

Eirikur Eiriksson (11/27/2015)

---

Brandie Tarvin (11/27/2015)

---

My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.

And now my head...

jmpatchak (11/21/2015)

---

My apologies. H/T to Alan for the script to set up the DDL:

/****************************************************************************************

(1) Setup DDL

****************************************************************************************/

IF OBJECT_ID('dbo.Chooser') IS NOT NULL DROP TABLE dbo.Chooser;

IF OBJECT_ID('dbo.Book') ...

omegadev21 (11/20/2015)

---

@jeff Moden, yeah that's the sample...

If only I...

This seems like a fun little exercise and this kind of thing sharpens your skills for sure. +1000.

Here's what I put together. Note that I cleaned up your DDL....

There's a bunch of ways to do this using T-SQL, a CLR, Powershell, cmdexec, etc. You should copy an attachment of what the text file looks like (you don't need...

I'm currently on a project migrating an Oracle-based data warehouse / Cognos Reporting solution over to...

A purely T-SQL solution:

Consuming JSON Strings in SQL Server[/url] by Phil Factor

Jacob Wilkins (11/20/2015)

---

Perhaps something like this?

CREATE TABLE Query_Test

(

CPU INT ,

ApplicationName VARCHAR(100) ,

...

This should do the trick. I just cooked this up and only had like 10 SSIS pacakages available to test against so there is likely more stuff you can extract....