If it's a one-off, and you have the correct permissions, you can create linked tables in Access that point to the SQL Server destination tables and then run a series...

use the ExecuteSQL task to run a stored procedure that accepts a string where you pass what part of the package/packagename and write it to a "log" table in your...

Look at Jeff Moden's DelimitedSplit8K function. It basically converts a delimited string to a table that you could use in a join.

There's a solution to the gaps and islands problem in Itzik Ben-Gan's book on windowing functions, too. I know I've seen at least one article on the web. Make...

If you base the report on a stored procedure (with the parameters already declared), SSRS creates the corresponding report-level parameters for you.

Otherwise, you would have to create your own parameter...

Welcome to SSC.

Thanks for the sample data. In the future, if you could post it like this, you'll get a lot more responses, and more quickly because people don't...

Wendell,

I'm okay at VBA. I am pretty sure Allen Browne has some code to clone records inside a transaction. The only hard part is retrieving the value of the...

Looks like COALESCE is what you're looking for.

Would be easier to test with a little bit of sample data, though.

Sorry, I meant to add that part - you can't use COALESCE in SSRS directly. It's a T-SQL keyword and not available in SSRS, so you would have to...

be brave. Test it. On a DEV machine.

set statistics io on;

set statistics time on;

-- execute your query here

select *

from dbo.V_OnlineSalesOrder

WHERE IncomeGroup = 'Moderate';

set statistics io off;

set statistics time...

Sounds to me like you should do the whole thing in a stored procedure. If vacation hours is completely dependent on hours worked (so, a timesheet entry), then why...

"giving me errors" is just means it doesn't work. How about providing the error message?

It worked when I based the report on this T-SQL statement:

SELECT field1,

field2,

field3,

field4,

field5,

COALESCE(Field1 + CHAR(10) + CHAR(13),'') + COALESCE(Field2 + CHAR(10) + CHAR(13),'') + COALESCE(Field3 + CHAR(10) + CHAR(13),'') +...

Is there any way to convert this rows to columns.

Yep. PIVOT or use a report with a matrix

Not enough information. Please post your table definition(s).