According to MS doc, that applies only to SQL 2014 and...

sharonsql2013 (7/29/2015)

---

I have a query that brings in data to be displayed in a chart.

Since there are lot of values , I just want to bring in alternate rows but...

You might well find that the data is not actually correctly formatted for all records. If a humang being was ever editing the file, you might well have...

ben.brugman (8/3/2015)

---

This weekend I have been away from the keyboard. And as often the best idea's occure when away from the keyboard. E.g. on my bike (pushbike) or under the...

You can't run a DTS package unless SSIS is installed and running on the machine in question.

I don't see any obvious reason why you couldn't just do this in an SSIS package instead. SSIS can avoid the extra complexity of having to combine your...

SQL_Kills (7/30/2015)

---

Hi,

I want to get the latest comment for each id based on the maximum createdDate and not sure how to do this, tried to do Max but it...

Did you use ALL of Jason's query, including the part that has WITH at the beginning? That part is called...

Yeah, they went missing along with that blue moon we just had... :w00t:

paul.s.lach (7/31/2015)

---

OK, here is another solution that I believe is stripped down to the basics:

INSERT INTO [#gpa]

VALUES (1,'math',3),

(1,'eng',4),

...

Another alternative:

DECLARE @testing AS TABLE (

DepDate datetime,

val int

);

INSERT INTO @testing VALUES ('2014-01-10 00:00:00.000', 1);

INSERT INTO @testing...

Robert klimes (7/30/2015)

---

I'd like to thank everyone for their contributions.

Even if supplied solution did not give desired results, they did give me different ways of looking at problems and...

Robert klimes (7/29/2015)

---

First, is the right answer 4.3333 ? I changed the data type in your table to decimal(5, 4), as the float data type would be unable...

Robert klimes (7/29/2015)

---

I am trying to calculate cumulative GPA which is currently it is being done via a cursor and i was looking to change it to set based if...

I've updated my last posted query with Jason's update to the FOR XML PATH portion. FYI...