Hi and welcome to the forums. What you are describing is often called a cross tab or pivot. Personally I prefer using the cross tab method instead of pivot because...

mtlsql (7/7/2015)

---

Is there a way to remove a table-type variable when you're done with it?

I have a large procedure that declares a table-type variable, loads data into it with a...

SQL006 (7/13/2015)

---

Hi

I have a requirement where i have to insert empty string in column whose datatype is decimal.

I have to replace the column value if it is null then...

Great work. Congratulations!!!

Alvin Ramard (7/10/2015)

---

It would make more sense to me that they would be able to request for the database to be backed up.

If they must be allowed to back...

Kelly

Ed Wagner (7/10/2015)

---

Eirikur Eiriksson (7/10/2015)

---

SQLRNNR (7/10/2015)

---

Sean Lange (7/10/2015)

---

Just saw this posted as an explanation to a problem.

I'm new to SQL already researched in the Chinese do not think swimming on...

Just saw this posted as an explanation to a problem.

:w00t:

All the columns in the...

Rod at work (7/9/2015)

---

Matt, I definitely like your suggestion of giving the users a compiled version of the .MDB. Right now what some of them do (fortunately not many) is...

dopydb (7/9/2015)

---

hi sean

did you view the link above?

definitely is a tab to me - i can count the 40 Chars including spaces then the space after the , is...

How do you...

Hi and welcome to the forums! As posted your question is extremely unclear. I am unable to determine what you are trying to do and what the question is. Please...

dopydb (7/9/2015)

---

hi

i am getting a tab character at the end of my query fields, been trying various things to fix, such as using the replace function below but still i...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1701441-17-1.aspx