I don't have an example for passing variables through the application, but here is how you do it in...

Scott,

When you say 3 reports are they 3 different pages on the same report because they selected different inputs?

unnati.patel513 (4/10/2014)

---

Hi, Thank you very much for the code

But I need to check that if the Date is valid or not

Lets say if we pass this SourceFile1_99999999999999.txt then...

You...

😛

You have all the answer in your code...

SELECT ComputerName AS [Computer Name]

, [Name] AS [Printer Name]

, SUM(BlackWhiteTotalCount) AS [Total B&W Pages]

, SUM(FullColorTotalCount) AS [Total Color Pages]

, SUM(BlackWhiteTotalCount) + SUM(FullColorTotalCount) AS...

@GilaMonster,

Thanks for that. I am actually trying to write articles here @ sqlservercentral as well. Only question is, can I also write the same article at my own website?

Is this article done, or can I...

Steve, here is a step by step article I wrote on how to remove duplicates from a table in SQL Server. Still waiting for approval for the previous submitted articles,...

Hey Steve, here is a detailed article I wrote on partitioning. How to submit this was a question, I am...

Interesting Stuff.. I will try to post the articles I prepare for my website too here @ sqlservercentral . quick question, is there an approval process or so, or just...

Can you not make this into two steps using two execute sql tasks directly and in the second task choose to create a sql statement using expression builder and execute...

I think OP meant...

Try this method may be.. http://sqlsaga.com/sql-server/how-to-remove-duplicates-from-a-table-in-sql-server/[/url]

There are ranking functions that you can use instead of aggregations too.. but depends on the purpose again..

Read about ranking functions here @ http://sqlsaga.com/sql-server/what-is-the-difference-between-rank-dense_rank-row_number-and-ntile-in-sql-server/[/url]

Unnati, see this.. You will be needing to use a Select statement like this and capture the result.

DECLARE @String VARCHAR(MAX) = 'SourceFile1_20140803073209.txt'

DECLARE @String1 VARCHAR(MAX) ='SourceFile1_2014073209.txt'

SELECT @String AS [String] , CASE...

I am not sure if this is the one you are asking for, but from what I understood you might need to unpivot first on those date fields and then...