Try Thinslicer, got it for free with MS OLAP course.

Contact Richard Lees at Microsoft NZ.

Do a search on web maybe still available.

Just off the cuff, if you can ship the parameters to the middle tier (we use VB6 dlls) and then apply the business rules, calling different sp's to populate the...

Will this help

Declare @i int,

@wyd int

Select @i=999,@wyd=11

Select Right(Replicate('0',@wyd)+Cast(@i as varchar(20)),@wyd)

May help a bit.

Declare @i int

Select @i=999999

Select Case When @i>99999

Then Right('0000'+Cast(@i as Varchar(10)),9)

...

Start Enterprise Manager.

Go Management -> Jobs.

Right click on the job and select properties.

Select Steps and Edit the step.

Select the advance Tab and click 'Append output to job history on'.

Click on...

Prev pos refer to further enhancement.

To get other related fields :

Declare @From int,@To int,@c varchar(1000)

Select @From=900,@To=901

Set @C='Select ff.item_no,ii.Short_Descr from (Select top '+

Cast(@To-@From+1 as varchar(10))+

' f.* from (Select top...

You may need to look at sp_executesql

See SQL Server Books Online for 'sp_executesql'

Solution needs some more work done on it

I used a table Item with PK(Item_No).

Also need some stress/load testing

Declare @From int,@To int,@c varchar(1000)

Select @From=900,@To=901

Set @C='Select ff.*...

Agree on the VSS.

Following will script database to drive c$ on the SQL server.

Replace Exec statement with a Select statement to get generated statement.

Can be scheduled as a...

The date of '03/02/2003' is it equal to '2 Feb' or the '2 Mar'

Try WHERE when_dt > Cast('2 Feb 2003' as datetime)

Scptxfr.exe is a MS SQL supplied utility.

Look on this website in Products->Freeware for more.

How big / complex is the stored procedure? Does it change the trigger table?

Anyone using scptxfr.exe?

Chrhedga, do you imply sequential / asynch versus set based?

http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm

http://www.intelligententerprise.com/001020/celko1_2.shtml

http://support.microsoft.com/default.aspx?scid=kb;en-us;q248915