You're welcome. 😀

Do you remember basic order of operations from math class?

You have this.

Since you didn't use any parenthesis this is nothing like what...

halifaxdal (11/14/2013)

---

Select Distinct Category from menuGroup

ORDER BY (CASE Category

WHEN 'SVP' THEN 1

WHEN 'OS' THEN 2

WHEN...

//Ravi (11/14/2013)

Sean, yes it is Looping/cursor type of insert. I hate using cursors, but the application, into which the data is being inserted in, can't handle set based...

Grant Fritchey (11/13/2013)

---

Lynn Pettis (11/13/2013)

---

Just finished the interview, and I feel like a...

brad.mason5 (11/13/2013)

---

I am not sure what the "new code" added means. This returns exactly same set as Sean but using PIVOT. Just a different approach. I compared the...

Here is the output I get with the code I posted.

LocationBatch IDFile #Last NameFirst NameCancel PayPay #Reg EarningsRate CodeTax...

Something like this should do it.

SELECT

B.Location,

'EXEMPT' as 'Batch ID',

A.EmpId as 'File #',

B.EmpLastName as 'Last Name',

B.EmpFirstName as 'First Name',

'y' as 'Cancel Pay',

NULL as 'Pay #',

NULL as 'Reg Earnings',

2 AS 'Rate Code',

NULL...

I saw this thread earlier and totally agreed with Koen about the syntax errors. The way it was posted is just completely illegible. I took your post and ran...

Well the sample data seems to match up with the description. However, the description is totally unclear. Why do values start changing in July? You mention something about multiple intersections,...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

Take a look at the links in my signature about cross tabs. It explains how to do this thing quite nicely.

duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1513950-391-1.aspx

duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1513950-391-1.aspx

SteveEClarke (11/13/2013)

---

I am looking at updating a table with a trigger and have attached the code - but am getting basic errors with the case functionality - it is not...