Yeap, I agree with both of you.

I did a lookup (one time) in the beginning and added 4 extra columns for max slot amount for each slot and then...

Thanks Kevin.

I was definitely not expecting the complete solution (with the info provided), just needed a direction if it was possible. Processing happens in a batch process from flat...

Trying to avoid ELTL implementation where we load to a table first and then transform. But if it is faster than looping in SSIS, might consider it.

Sorry about that. Just wanted to get replies from both SSIS and T-SQL schools of thought.

Thanks for the reply Phil.

1. The points are calculated in a batch from a flat file generated by the POS on a regular basis. They are shown later to...

Hi SolidSnake10_7

No one replied as you can see and to b honest I cant even remember what I was doing in Jan 2009. But It seems that I was trying...

What is the version of SQL Server 2005? Is it SP1 or RTM? Under what accounts are SQL Server and SQL Agent running?

My apologies to PeterHe, your query actually works. I accidently queried another Server, which has no data. Thanks a Lot Peter!

I originally thought that only WHERE something = NULL is...

I ran the above 2 queries - no change = 0 rows.

The issue is not about NULL values here. LEFT OUTER JOIN returns NULL because it does not find a...

Hi Sreejith

Same - 0 rows returned

In SQL Enterprise Manager, switch to Task Pad view for the database.

Stacey

1. Microsoft recommends having 1 Maintenance Plan per database. If the first step fails in the Maint Plan the remaining also fail - e.g. The first database backup fails, all...

-What is the data in Mainframe for that character? Is that datatype compatible with SQL Server CHAR or VARCHAR datatypes?

-What is the length of the value inside the field which...

What does this value - mean? Why do u even have it in there?

What is the data type of the column that stores the value?

This might help:

http://support.microsoft.com/kb/227662