Take a look at the articles linked to in my signature under Cross-Tabs and Pivots, Part 1 and Part 2.

madler-797963 (10/7/2010)

---

Ah, that's not a bad idea, just installing a different instance and moving the db's.....Can that be done from RDP (e.g. the SQL cluster installation part)? The windows...

You cannot perform an in-place upgrade from 32-bit to 64-bit.

If you already have a 64-bit OS with the 32-bit SQL, then you can install 64-bit sql on the same cluster....

Use the CONVERT function, with style 101, to convert the datetime to mm/dd/yyyy format. Grab just the first 5 characters, and then do your comparison.

Craig,

I'm having problems loading this much data into a sample table. Can I get you to export the data into a new table in a new database? Detach the database,...

...In your attachment are several rows with "NULL" instead of any data.

DECLARE @test-2 TABLE (

RowID INT IDENTITY PRIMARY KEY CLUSTERED,

Name varchar(10),

Gender char(1),

Age tinyint,

[Group] char(1));

INSERT INTO @test-2

SELECT 'Jim', 'M',...

Please be sure to come back and let us know how it worked out for you.

Alvin,

Why use a Script Task to build another variable when you can do it from the expression property of the variable?

Soulfly73 (10/7/2010)

---

hello Wayne,

Thank you for your reply.

I indeed can get the supplierId from the filename, but I cant figure it out to use it as a variable and insert it...

sbrochu (10/7/2010)

---

SELECT

T0.[Name] AS 'ComputerName',

--count( T0.[Name]) as 'Execution Count',

T1.[Domain] AS 'Domain',

T1.[Last Logon User] AS 'Last Logon User',

T2.[Start Date] AS 'Start Date',

T2.[File Name] AS 'File Name',

T2.[File...

sbrochu (10/7/2010)

---

2. Please see this script below. When I run the script, I want to be able to count the first col and show the count in the second...

Are you saying that the filename contains information to be able to determine the SupplierID? If so, you can have this go to a (package level) variable, and use it...

Assuming that the parameters are going to be the variables that you declared and initialized, then this looks good. Just ensure that you remove the declaring/setting of the variables!

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...