Easy question for the day! Thanks..

Select statement cannot be used directly to create headers. Here is how it can be done by creating a list of columns and then creating a PIVOT string which include...

This is how it can be done, using PIVOT function

SELECT paymentID, [ASD], [BG],[SD]

FROM (SELECT paymentID,

...

Try to do this yourself. Here is the link for your reference:

http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

Hey demonfox..spot on with regards...

Here you go:

CREATE TABLE Payment

(

PaymentHistoryID INT,

paymentID INT,

...

Thanks Tom!

Really appreciate the way solution is explained.

Thanks EdVassie, you reminded me of this.

OP, here is how this can be done.

In SSMS, right click on “Local publication” and click “properties”. In the “Publication properties” window, click on...

Thanks Dinesh 🙂

demonfox (2/3/2013)

---

pawan_rb (2/3/2013)

---

Thanks. Can you please also show me thae way to compose the sql? I was also thinking in the same line like in er joining and grouping but...

Your issue is not very clear! still trying to answer partially

If the retention of data in source is only 1 day, for reporting tables create a staging area in Reporting...

Good question. Thanks!

Here is a tip to understand:

1) This is how "0" and "114" will look like when converted to DATETIME

SELECT CAST(0 AS DATETIME) -- 1900-01-01 00:00:00.000

SELECT CAST(114...

Good one Thomas! I was aware that column values will be swapped 🙂

opc.three (1/31/2013)

---

In theory CHAR would perform slightly better than a VARCHAR because the length is known ahead of time so retrieving the value is as simple as fseek (drawing from...

+1 Same with me 🙂