Yes. For testing purpose, I use one server for everything.

I'm using a doman account which is part of the admin group for SQL Agent. My SSIS package is also created under this account. My source connection is actually using windows...

This probably is a long shot. You can use DBCC INPUTBUFFER to print out your command at the end of each resultset.

I think you always want to list the explicit columns in your insert statement. This will make your life easier in the future. Say you add a column to your...

Change CAST(@todyDate AS VARCHAR(10) to CONVERT(Varchar, @todyDate, 101) should work.

How about something like this.

SELECT Product, SUM([Count of orders]), CONVERT(FLOAT, SUM([Count of Orders])) / (SELECT CONVERT(FLOAT, SUM([Count of Orders])) FROM [Product Group]) FROM [Product Group] GROUP BY Proudct UNION SELECT...

I think the reason that table name is added in front of column name in Access is you can't have duplicate column names in the resultset by rule. So in...

Why you don't want to use identity column to generate your invoice number? It seems to be more efficient to let the system handle the number generation. You can always...

If you want to keep your parameter the way it is, you have to use dynamic sql (not recommended) in your sp. So the statement in your sp would be...

In Kokyan's example, don't you need to define @tblname as varchar(128) since table name in SQL 7 and above is defined as varchar(128) ?

I don’t think you can use table as parameter of a stored procedure. Here is what I think that might work.

Create Procedure [WH1].[Usp_ArchiveChild]

@sParent VarChar(20) = NULL,

@sKey VarChar(20) = NULL,

@sPId VarChar(5)...