Sean Lange (1/16/2014)

---

Nice job posting the ddl. Can you post some data? Remember we are...

raghuldrag (1/16/2014)

---

Hi dwain.c,

Thanks for ur reply.....

i need the o/p like each item wise (i.e you wrote the code for max item ,

now each item...

Sorry to tell you this but I don't open zip files from unknown sources (virus-phobia).

Post the SQL in line using the SQL code tag to make it pretty.

pooja.sharma 54426 (1/15/2014)

---

declare @cols NVARCHAR(MAX)

select @cols = STUFF((SELECT distinct ',' + QUOTENAME(c.propName)

...

Maybe this will help then.

CREATE TABLE #TxCycle(

Cycle INT NOT NULL,

PatientID INT NOT NULL,

ALOPECIA TINYINT,

Causality1 TINYINT,

Relatedness1 TINYINT,

ANEMIA TINYINT,

Causality2 TINYINT,

Relatedness2 TINYINT,

BLOOD TINYINT,

Causality3 TINYINT,

Relatedness3 TINYINT);

SELECT OBJECT_ID('tempdb..#TxCycle')

SELECT name

FROM tempdb.sys.all_columns

WHERE object_id = OBJECT_ID('tempdb..#TxCycle') AND...

pooja.sharma 54426 (1/15/2014)

---

HI,

I am not getting how to use Table valued functions as columns that i need to fetch are not constants rather they are dynamic "' + @cols +...

pietlinden (1/15/2014)

---

CREATE TABLE #TxCycle(

Cycle INT NOT NULL,

PatientID INT NOT NULL,

ALOPECIA TINYINT,

Causality1 TINYINT,

Relatedness1 TINYINT,

ANEMIA TINYINT,

Causality2 TINYINT,

Relatedness2 TINYINT,

BLOOD TINYINT,

Causality3 TINYINT,

Relatedness3 TINYINT);

The one thing I was wondering was this: how do I...

pooja.sharma 54426 (1/15/2014)

---

Hi,

Actually my function is returning a dynamic query .

Step 1 : Create a function returning property names in CSV format

Create FUNCTION dbo.fxnGetPropertyColsQuery

(

)

RETURNS NVARCHAR(MAX)

AS

BEGIN

declare @Return ...

pietlinden (1/15/2014)

---

Can you just create it as a table-valued function?

CREATE FUNCTION [dbo].[GenerateCalendar]

(

@FromDate...

ashley.shookhye (1/14/2014)

---

Thing is where there is no purchase, it is showing up a record where purchase is 0 and same goes for issues if there is no issue for that...

JackG (1/14/2014)

---

I did do unpivot. I'll check...

JackG (1/14/2014)

---

WOOHOO! That did it!

I unpivoted the start & end date into one date column. (had to group them to eliminate duplicates for some records) I...

Grant Fritchey (1/14/2014)

---

Nope. And I'm starting the rewrite on the...

Grant Fritchey (1/14/2014)

---

Sean Lange (1/14/2014)

---

Here is a true story from the field that a buddy of mine shared with me yesterday.

Yesterday my supervisor sent me an email regarding a view...

True enough....