GTJohnson73 (8/13/2013)

---

I am working off of a view, that has a huge amount of columns...for the data I need here is the structure information

pyEventID = (Varchar (255), null)

ProviderName = (varchar(64),...

I am confused. Are you typing in a query or using the Edit top 200 menu option? I would urge you to write your queries instead of using the edit...

GTJohnson73 (8/13/2013)

---

Here is my attemp at the Cross Tab and I am getting invalid column with the unline being on all of the Selects in the "WITH" section. I am...

Ed Wagner (8/13/2013)

---

jasona.work (8/13/2013)

---

Oh what a fun little car the BRZ is!

The last time I was in a car that felt this sure-footed on the road, was a 1996-7 Eagle...

nuchbcc (8/13/2013)

---

Thank you for being patient.

To create a FK so the query output would replace the value with the StatusName, from SMS;

On table1 right-click on Keys,...

GTJohnson73 (8/13/2013)

---

Thank you for the welcome...For the I-##### in the code, can I replace this with the column name, etc.?

i.e. select eventID, P_Num, 1, 'Company', 1 union all

...

bgrossnickle (8/13/2013)

---

I am rying to run a TSQL SELECT Count(*) that has a @Tablename variable in it.

My Tablename name needs to be variable and I will build it on...

jamesheslin123 (8/13/2013)

---

Hmm... the only problem with this is I don't think the code takes into account what the SpaceType is.

I need the Name1 column to say Vacant "SpaceType" only...

And the second rule is "Sean should shut his hole!!!". 😀

Hi and welcome to the forums. What you are describing is known as a cross tab. It will generally outperform a pivot. The challenge is that you posted some data...

nuchbcc (8/13/2013)

---

I tried the JOIN query separately and received the output that I needed but when I added it to the existing query, it failed.

I guess what I'm trying to...

Jeff.MSSqlSage (8/13/2013)

---

Sean Lange (8/13/2013)

---

You do know that this violates the agreement for the exam right? Your page discusses exam content with things like the percentages of...

nuchbcc (8/13/2013)

---

I have table1 with multiple columns, the Status column has 3 possible values (1,2,3). I created another table(2) named status_lut (below). When I query table1 I need it...

You do know that this violates the agreement for the exam right? Your page discusses exam content with things like the percentages of questions for certain...

jamesheslin123 (8/13/2013)

---

Now there is one last slightly more complicated piece to this puzzle that I have... and then I think I am actually 100% done with this project.

I think...