Yes I can change the NULLs to 0s on the database side.

Thanks

The source is SQL Server

Thank You Gail. The post was very helpful.

This is exactly the solution I was looking for..works like a charm. Thanks for all your help.

Gianluca Sartori (1/30/2012)

---

First of all you have to define what "duplicate" means to you. Duplicate records for the same Id? Duplicate records for the same id+status?

If the former, this should...

MostInterestingMan (12/5/2011)

---

Hi,

I have a package that pulls a csv file from a client's ftp server daily and load into a sql table. I want to be able to check if...

Ninja's_RGR'us (8/10/2011)

---

use that to split.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Then use this technique to pivot (or just the native pivot in tsql).

Select columns, MAX(CASE WHEN RowId = 1 THEN Value ELSE NULL END) AS Email1,...

Ninja's_RGR'us thanks for your help and patience but it's...

Ninja's_RGR'us (8/2/2011)

---

You mean SSRS?

Never seen that.

You could always use

SET DATEFORMAT YMD as the first line of code in SSRS. That might fix it. Don't know what else to...

Yes the SSIS parameter is DateTime which results in the calendar control on the UI. The reporting is working just that it is returning less records than expected because it...

Ninja's_RGR'us (8/2/2011)

---

That shouldn't happen (only ever saw that from profiler to ssms).

Are you sure that the parameters are declared as datetime in the proc, the parameters and the...

Ninja's_RGR'us (8/2/2011)

---

Bingo, you've found one of the hidden "features" of ssrs. Wreaks havoc with dates too (if your ssms settings are different than Bids when you copy queries from...

I got this working by reading a great blog by David Leibowitz [/url]

David leverages a Table Function to parse the comma seperated list that SSRS multi value parameter passes and...

That was my problem. I deleted and re-added the table to the form and it worked. Thanks

Ninja's_RGR'us (5/6/2011)

---

You can use this to generate the data.

http://www.red-gate.com/products/sql-development/sql-data-generator/

Or you can do it manually using this exemple :

http://www.sqlservercentral.com/articles/T-SQL/68467/

Go to the section called "Populate the Test Table with Randomized Data".

Option...