Try this,

CREATE PROCEDURE Sp_GetAvergaeSales

(

@StartDate Datetime,

@EndDate DateTime,

@NumOfWeeks int

)

AS

Declare

@i int,

@ColumnName varchar(10),

@AlterTable varchar(100),

@AddColumn varchar(100),

@tsqlalter varchar(100)

create table #weeks(XSeries varchar(12), Turnover money)

set @i = 0

while @i <= @NumOfWeeks

begin

set @ColumnName = 'Turnover' + cast(@i as varchar(2))

select...

In SQL 2000, u can use the wizard to generate Diagrams of ur database. Its really easy to use, Just Rt.Click on Database diagram folder under database

http://codebetter.com/blogs//images/codebetter_com/peter.van.ooijen/53/o_o_DiagramWizard1.jpg

sql_jr (3/31/2009)

---

Task CompensatingSql failed is what I see now. Everything is under Control Flow -no data flow components.

I'm getting the rope ready, as I cannot get this to work...

What errors do u see now for this task? There is no task called 'Task Compensating'. R we on different page.

Thanks Flo, I was looking for similar kind of query and your work does that.

have u tried using Mirroring Wizard too?

Is it possible for u to use same account for your Mirror server and Mirror Agent too(the one used by your Primary server)?

Seems like u did move to the next step after seeing the error, establising the connection. The error:

Verify that the column metadata is valid. End Error Error: 2009-03-31 18:52:03.47 Code:...

One thing in Mirroring is u have to set up your SQL server Agent and your SQL server under same account. Do it same thing with your Mirror server too.

Can u do this:

1)Save the password

2)Test the connection when connecting to another server

3)Use,security "encryptAllwithPassword" option and save ur package.

4)Execute ur package manually first i.e. if its saved as a...

you just have to filter out those bad records(The ones whose date range does not lies between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM)

and import the good ones, or fix...

There's this article I was going through this morning from MSSQL tips, it did describe few good examples of Coalesce and how it can be used to avoid cursors.

http://www.mssqltips.com/tip.asp?tip=1521

What kind of job is that? Is it just transfering data from one servers database and table to other servers table? Have u tried saving ur package as SSIS file...

R u saving ur package as SQL server or as File system.(The radio buttons that comes at the end of the wizard)?

Even Microsoft is offering 25 GB of free online storage called windows Sky Drive. You just have to go to their website, http://www.microsoft.com and open up your account.