ISNULL needs to be part of the SELECT, not the PIVOT.

Modified code:

CREATE TABLE Sales (EmpId INT, Yr INT, Sales MONEY)

INSERT Sales VALUES(1, 2005, 12000)

INSERT Sales VALUES(1, 2006, 18000)

INSERT Sales VALUES(1,...

julie.breetzke (8/13/2014)

---

apologies for my ignorance however im new at this..

Must i not use a trigger or must i just use a different trigger?

How would i incorporate the code above into...

Don't get too attached to the idea. It's more of a quick fix, and could be problematic in terms of applying it to a larger set of data,...

Just uploading the execution plan so you can see what you might be in for. The estimates aren't very good on number of executions, so the potential for...

Okay... Now we have something better to work with. The query below includes your original example code, but modifies the table to have a clustered index based...

Somebody correct me if I'm wrong, but I'm pretty sure CDC is for SQL Server as opposed to any kind of ODBC data source. You'd probably have to...

I have a working solution, but before I present it, you need to know that what you're asking for looks like a homework assignment rather than a real-world business problem....

Okay, now I'm wondering what, exactly, you're doing. Apparently, it's not anywhere near as simple as your original post suggested. If you can post a...

Let's first clarify the objective. Your post says you have 5,000 records, but you have to loop through it 5 times to get 1,000 records in each of...

Um... that's not actually an option. Don't get me started on the why...

Jeff,

I'm not sure we're dealing with some kind of SQL script - either for when they copy production down to a lesser environment (DEV, TEST, etc.), or for a conversion...

If you cancel a query in SSMS, then the entire query's actions get rolled back, although I don't know what would happen if there were separate batches within what was...

tstagliano (8/8/2014)

---

We have a query that is performing a number of counts for a certain selection set and we would like to add a select statement that would take the...

Gail Shaw? Jeff Moden? Anyone?

Vantigate (7/31/2014)

---

You have to run a dtsx package from within Microsoft BIDS, SQL Server, or command prompt (http://technet.microsoft.com/en-us/library/ms138023(v=sql.105).aspx)

You probably want to select the option "Run immediately" instead of "Save...