You need to use dynamic SQL In order to use variables. It would be like this:

[font="Courier New"]DECLARE @test-2 AS INT,

           @sql VARCHAR(MAX)

SET @test-2 = CONVERT(CHAR(8), GETDATE(), 112)

SET @sql =...

As SQLNoob has said there are many other factors in place as well. IN reality the maintenance plan which uses SSIS, is really just running the BACKUP DATABASE command...

Yeah, that would make sense as SortKey is mtlseq converted to varchar. You would just want to convert SortKey back to a numeric.

Odds are your clustered index is on order_id so no sorting actually has to be done. When you add order_date then the server actually has to apply a sort...

Include numeric sort fields in the CTE, you don't have to output them to the report. LIke this:

[font="Courier New"]DECLARE @TOPPART VARCHAR(32)

SET @TOPPART = '11001-01';

WITH BOM(partnum,revisionnum,mtlseq,mtlpartnum,qtyper,bomlevel,sortkey, sortkeynum1, sortkeynum2)

AS

(

        SELECT partnum,revisionnum,mtlseq,mtlpartnum,qtyper,1 AS...

None that I am aware of although there may be something in the DMV's.

I keep thinking I have a solution, but As I test it to make sure it will work in each Company/delivery day situation I find cases where the solution does...

I don't think you can modify\open SSRS 2005 reports in VS 2003. SQL Server 2005 installs BIDS which is a limited version of VS 2005 if VS 2005 is...

Okay, I misunderstood your problem as well, I think. The solution I offered assumed that the DeliveryDates were dates the company would deliver on, so if I order on...

I'm not suer what you really gain by adding SQL Server 2005 instances as Gail has said you really can't let them all dynamically manage memory which means you have...

Here is a solution that includes a Numbers[/url] table. The caveat is that my solution needs the numbers table to include 0. You can obviously adapt the solution...

Use the conditional statement in the derived column transfer.

value=="y" ? "true" : "false"

Remember that comparison in SSIS IS case-sensitive.

It would depend on what you are doing in the cursor as to wether or not you could convert it to a CTE and/or how you would write the CTE,...

blandry (8/1/2008)

---

A few months after the reunion I heard from three class members asking that I pull their pages. Two were in the financial industry and one in healthcare...

The code you posted is incomplete. You are missing at least 1 END and you are not explaining what you want the code to do. If you look...