How about using the Regular Expression Editor?

[0-9] seems to work OK most of the time but it's still letting some things through, not sure why. I think this is only...

Thanks, but with that I get:

"Error at Data Flow Task [Conditional Split [214]]: Attempt to parse the expression "[Column 0] like '%0-9%'" failed. The expression might contain an invalid...

Yes, the database is on a SQL Server 2000 instance.

I am getting 'RANK' is not a recognized function name.

I figured it out though:

outer sp

drop and create #temp table

open cursor

fetch cursor

loop

...

The dates are being converted to chop off the time because our visual PC guys make the effective dates effective at 3PM, 10AM, 5:37PM or whenever the user did the...

They are both the same now:

USE [Rates]

GO

/****** Object: StoredProcedure [dbo].[sp_ProfitStatEX] Script Date: 12/23/2008 08:04:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[sp_ProfitStatEX]

@date datetime,

@ProdID int,

...

I think I will nickname it the 'Apples and Oranges' report because that's what they want to see on the same report. Some rates are calculated one way and some...

It's in development. I took the queries from two different reports that the user wants to see on the same report. Details, details 😀

I was going to take care...

Not that it's really relevant, it could have been a simple select statement and it would behave the same way, but OK, here you go...

USE [Rates]

GO

/****** Object: StoredProcedure [dbo].[sp_ProfitStatEX]...

Cool, thanks!

I don't want any names (rows) like "HOLD UNTIL 10-18-05" or "BLACK-MAIER101709"

I think this is more of what I was looking for, but thanks.

ORDER BY case when datediff(day,p.Prodclosedate,getdate()) > 0 then 1 ELSE 2 end

I am not talking about scripts. (?) I was referring to the default parameters for the SQL services:

services>properties>recovery tab>First failure, Second failure, Subsequent failures and why they are all set...

I had a situation over the long weekend where the SQL Server was restarted manually and even though all the SQL Server Services were set to start "Automatically" the SQL...

I guess what I am looking for is a to-do list for re-installing SQL Server 2005 configuration/components. I am letting our Sys-Admins and various outside consultants worry about what is...