Do you need the data passed out as columns or rows?

I would do something like this:

[font="Courier New"]SELECT

    projectname,

    COUNT(*) AS open_issues_for_180,

    SUM(CASE

            WHEN datesubmitted >= DATEADD(DAY, -90, GETDATE()) THEN 1

            ELSE 0

        END) AS open_issues_for_90,

    SUM(CASE

            WHEN datesubmitted...

Why to you want to use SQL Server's mail system to send the file then? There are ways in .NET and I'm sure Java as well to send email...

IN the script you can change the location of the file to a valid location on the server. To stop a trace you use sp_trace_setstatus @trace_id = n, @status...

I think you can do that with an IIF like this:

=Sum(IIF(FilterField=FilterValue, SumField, 0))

The issue could be with the empty values. You may want to check for empty string in the Derived Column conversion and set that to Null.

You can also use Profiler to get a Deadlock Graph.

In order to schedule a trace you would need to setup a server-side trace and put it in a SQL Server Agent job. You can setup the trace in...

Sounds like you may be headed the right direction. Glad I could offer a little help.

It sounds like there is a replacement string in the xml like > (>) that is not terminated correctly. You can put a data viewer on the stream from...

Do you have a date column in the table?

What is the structure of the table?

What have you tried so far?

You want the Count() function in the select and in the...

Your biggest problem is that you are using Functions against columns in the where of the subquery which will cause a table scan. You should first look at how...

aye_taur (7/25/2008)

---

I am trying to use your code to get the error rows. I am not too familiar with XML but when I pasted the code inside the script editor...

As much as I hate it you can use the Client Access (iSeriesAccess) ODBC or OLEDB provider within SSIS for your connection. At my current position I no longer...

You cannot do a Select From storedprocedure. You can convert the stored procedure to a table valued function and then you can join on the table valued function. ...

IN 2005 you use sp_send_dbmail as xp_sendmail is how SQL Mail worked which, as the error says, is not supported on 64-bit. Check out sp_send_dbmail in BOL.