I look forward to it.

Hi and welcome to the forums! It is nearly impossible to provide any kind of assistance based on the limited amount of information you provided. It sounds like maybe you...

timwell (11/18/2013)

---

Sean Lange (11/18/2013)While the pivot seems a bit contrived here it does a good job of demonstrating how it can be used. ...

The question does test your knowledge of...

maheshbabukadiyala 5816 (11/18/2013)

---

Hi,

I have a data like as follows

Trandate ProductID CustomerID TranValue

21-Nov-13 0233 GB10856 24

and...

Actually it doesn't really work ok. See the posts on...

Revenant (11/18/2013)

---

Sean Lange (11/18/2013)

---

Revenant (11/18/2013)

---

Sean Lange (11/18/2013)

---

. . . While the pivot seems a bit contrived here it does a good job of demonstrating how it can be used. It...

Revenant (11/18/2013)

---

Sean Lange (11/18/2013)

---

. . . While the pivot seems a bit contrived here it does a good job of demonstrating how it can be used. It seems to be...

Stewart "Arturius" Campbell (11/18/2013)

---

Sean Lange (11/18/2013)

---

Technically speaking there are 2 possible correct answers.

E,D,C,B,A,NULL is also a valid answer. The only ordering going on is to sort NULL to the end....

maheshbabukadiyala 5816 (11/18/2013)

---

Hi all,

i have a trandate and tranvalue,customer,product now i need to poulate a table with trandate,tranvalue(sales amount),customer,product,py_tranvalue and i need to populate cy_WTD,cy_MTD,CY_YTD and py_WTD,PY_MTD,PY_YTD in sql...

Lowell (11/18/2013)

---

George i have the Redgate SQL Search plugin added, and it searches meta data only: object names from sys.objects, and definition text from sql_modules.

Sean Lange And I have a...

Technically speaking there are 2 possible correct answers.

E,D,C,B,A,NULL is also a valid answer. The only ordering going on is to sort NULL to the end. The order of the non...

halifaxdal (11/15/2013)

---

I am looking for the best and simplest solution to quickly replicate data in the same table. e.g. I have 100 sample records in my table, how can I...

TeraByteMe (11/15/2013)

---

Using the term "Where Filter" is a pretty common way of referring to the WHERE clause conditiional filter. It maybe shorthand'ish but I don't see how anyone without putting...

You should look at the excellent code from Lowell. You should not be using a cursor for this...and NOLOCK is most certainly a bad idea here. Do you know all...

TeraByteMe (11/15/2013)

---

I am at my wits end to figure out why when i run the below code from within SSMS it returns no record but when it is used within...