What defines the interval and what do you want to see summed? Or do you just want the min and max date within the defined intervals?

The OPs query has the same column name but from 2 different tables and the sorted column name is prefixed with the table alias.

That is what is being returned by the function. What version of SQL are you using?

Can you post the link to the thread where you got this function.

fnSplitMsg is a function not a table

try

select fnSplitMsg([msgfield]) from table

You are looking for a crosstab report/query. Search here for crosstab or pivot queries or lookup cross-tab report in books online. Post back if you need more help.

it usually comes down to permissions on the agent account or package owner account or if the issue is that it runs manully from a client but does not run...

Well then a DTS package would work just fine to transfer the data directly between the 2 databases. Exporting to Excel is bad because Excel has a limitation of...

is T also SQL Server or another flavor of database?

[TotalFine] AS (case when datediff(day,[DueDate],isnull([SubmitDate],getdate()))>(0)

then datediff(day,[DueDate],isnull([SubmitDate],getdate())) else (0) end*[fineperday])

I don't have access to a server to test this.

[TotalFine] AS (case when datediff(day,[DueDate],isnull([SubmitDate],[DueDate]))>(0)

then datediff(day,[DueDate],isnull([SubmitDate],[DueDate])) else (0) end*[fineperday])

From the analyst's side I hate it when they store data like that. You lose all of the functionality for doing comparisons without doing math against the column. It...

Why not

insert into table2 values (a1, b1, c1) where a1 is not null

insert into table2 values (a2, b2, c2) where a2 is not null

.........

.........

insert into table2 values (a24, b24, c24)...

no problem, glad you got what you needed.

you would need to use dynamic SQL to do that.

CREATE PROCEDURE [dbo].test

@DBName varchar(30)

AS

declare @sql varchar(8000)

set @sql = 'select * from ' + @dbname + '.dbo.emp where...

From enterprise manager click tools and then SQL Profiler from the tools menu. This opens profiler. Click file , new, trace. Select your server and then the trace properties...