Here are links to 2 articles that explain how to do what you want:

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

http://www.sqlservercentral.com/articles/Crosstab/65048/

The second one builds on the first so make sure you read them in order.

The forum does not allow xml unless you use the code="xml" IFCode as you can see in the IFCode shortcut on the left. Please edit your post or put...

AS Luke has said if you provide us with some more specifics perhaps we can offer an alternate solution. It may be set-based solution or another way to work...

I did a quick test in the Default Trace and I didn't see anything for job creation.

Can you post some sample data? Particularly a row that causes the error?

Yes, I understand that you are developing the report using the 2008 tools, but that does not mean that the Report Server itself has been upgraded to 2008.

To...

Sorry, you posted in a SQL Server 2005 forum so I supplied a 2005 answer.

Are there any firewalls running where you need to enable a port?

Have you verified through other...

Okay, thanks for the link, but now I have to ask, why use SSIS if the databases are on the same server? Why not straight T-SQL in a job...

Ah, some of the stuff you can set as attributes in the connection string, otherwise you need add the SET statements to your applications before you run the other commands....

I've decided to dominate The Thread today. Can anyone help this guy out, Cannot start SQL Server Port is already in use? I've never seen it and the...

I'm not sure I understand what you mean. Could you provide some kind of example (Variable names and how you want to use them)?

Here's another good one, What? (using Gail's response as the link name).:-D

Roy Ernest (8/13/2009)

---

No one has done anything with my articles either... But I know why...:-) I havent written anything that is worth plagiarizing 😛

Maybe the next article if I write...

TO answer your question. I don't think you can do what you are trying. You could create a linked server on DB1 to DB2, but then you don't...

SQL Server does not ensure ordering in storage so the third row could be any of the rows unless you provide an order by. In SQL Server 2005 and...