Remove the < 6 from the where clause,

Then use the case statement to create the new derived columns you need.

Try it and get as far as you can, then post...

Something like

SELECT

temp.cStudentId,

temp.iSchoolCode,

temp.cGradeCode,

COUNT(1) AS iMemb,

SUM(CASE WHEN temp.cAbsenceCode IN ('E','U') THEN 1 ELSE 0 END) AS Absences

FROM (

SELECT

ROW_NUMBER() OVER(PARTITION BY x.cStudentId ORDER BY dtEnrollmentDate Desc ) AS DaySeq,

x.*

FROM #x1 x)...

When the Variable is an int16 and I try

Dts.Variables["Variable"].Value = 1;

I get the same error.

When in the SSIS Script task Editor hover your cursor over the "1" and it...

Can you please elaborate on your table schema.

Present some sample data and what you want the results to look like.

Read this to help us help you[/url]

Doesn't sound like your creating a report. Sounds more like a data viewer for 650 different tables.

They have a tool for that, its called Sql Server Management Studio. :-P.

ha, all...

A good read

concatenating-row-values-in-transact-sql[/url]

+1

GIGO:w00t:

Using the View, and not dynamic SQL.

I'm pretty sure you can do this in a procedure too, you just have to alias the columns in the select so they are...

sql1411 (10/1/2012)

---

Hi Ray,

No. The customerID is different for each customer. Below is the revised INSERT statement

GO

INSERT INTO dbo.CustomerPurchase ( PurchaseDate, CustomerID, CustomerName, PurchaseDetails)

SELECT '2012-06-01 00:00:00.000',1001,'Wilson Menthis','Purchased Item 6AB2'

...

Your request doesnt quite make sense, your looking at CMC_BLCO_COMM_ITEM.BLEI_CK to see if its NULL, but your create table statement declares "NOT NULL" So it cannot be null, why check...

Is customer ID Supposed to be the same across all customers?

CREATE TABLE #CustomerPurchase(

[PurchaseDate] [datetime] NOT NULL,

[CustomerID] [int] NOT NULL,

[CustomerName] [varchar](25) NULL,

[PurchaseDetails][varchar](500)NULL

) ON [PRIMARY]

GO

--Insert some sample data into the sample table

GO

INSERT...

Cross join the table or join it to itself.

Please post DDL statements, and the query you tried.

Drop the unique key/index.

Add the new column.

Create a new Unique Index on the now 5 columns.

Discusses Issues with money.

There are rounding issues with money and is probably not the best datatype to use in your scenario.

What your requesting is kind of unusual, and I can't think of an easy way to display 15 rows.

Would it be acceptable if you set the option on your group...