I think you are wrong. because if in the data there is :

20% OFF

Then it will select that and I don't want that.

This line below would not work for us because we want only amounts 1,000 or greater.

OR [MESSAGE] LIKE '%[0-9].[0-9][0-9]%'

This line would be too broad, it would return things like...

It is a 400,000 record file. I can't do it that way, but thanks.

1 hour 43 mins for this to run:

Declare @StoreNum int

Declare @StoreCnt int

Declare @Recid int

Declare @RecCount int

Set @Recid = (Select MAX(RECNO) as recno from dbo.as_AllStores )

-- Get the...

1 hour 43 mins running time.

I did not have an index. I forgot to add it when i created that table. This is the index This is my index the execution plan said...

I'm using SQL 2008.

i have a 100 + million rec table I wanted to check the data types (specifically numeric) to make sure the data precision is not greater than what it is...

This is the Query I started out with. It ran overnight and then I ran out of space.

-- as_offer_dates has a column with all the days of the year...

In my subquery (join) table, I have millions of records. When I run the query without the loop it multiplies my records and it gets too big, doesn't even...

I will test this out... I have a 100+ million record table I will test this out on.

thanks

No error msg this time... Hmmm can't figure it out...I might have left something in it the first time and taken in out with comments when i reran it.

I want to create a temp table that I can use for my subquery in my loop, so that I don't have to run it 3 times for my links....

Ok, so I left out 1 or 2 GO. I removed them and now it runs...i have other things i need to add now before running it.

I took the go out at this line:

Set @Recid = Select MAX(RECNO) as recno from dbo.as_AllStores

Drop Table dbo.as_Redemption_Offers_DayGap

GO

Select 'Redemption' As Redemption, ar3.*, 'Offers->' As Offers, ao.*

......

Still same results...

Msg...