Excellent point. I may have to add a line to set that on all of my stored procedures just for safety. We are a small shop and I am the...

Thanks soo much for your time and effort!

The solution you came up with is interesting and appears to be very fast. I've come up with a solution that appears to...

I'm very sorry about that. I was looking at the wrong month on the calendar and have since updated the expected results.

As for shops that cross over days we have...

Thanks for the comments,

Normalizing the table or making changes to the structure isn't possible at this time as we would need to change 60+ stored procedures some of which are...

Sorry about that. Here's the code block;

create table Location_Table(

Location varchar(20),

Sat_Open int,

Sat_Close int,

Sun_Open int,

Sun_Close int,

Mon_Open int,

Mon_Close int,

Tue_Open int,

Tue_Close int,

Wed_Open int,

Wed_Close int,

Thur_Open int,

Thur_Close int,

Fri_Open int,

Fri_Close int)

create table Data_table(

Location varchar(20),

Date datetime,

[Hour] int,

Data int)

insert...

Just an update to this thread which I started as a general request for opinions on how best to pull info into Crystal.

I've since had to create several complex reports...

Does the account that Server Agent is running under have appropriate privileges on the file?

Here is the view:

select

a.Serial,

A.Date,

CASE WHEN ((Ag.Tot_TrafficA + Ag.Tot_TrafficB) > 0 ) THEN '1' ELSE '0' END 'Business_Day',

CASE WHEN (Ag.Est > 0 ) THEN '1' ELSE '0' END 'Estimated',

Ag.Tot_TrafficA,

Ag.Tot_TrafficB,

Ag.Tot_Trans,...

Excellent. Thanks very much.

I've never used a pivot before but after running your example it seems to be just what I need.

Thanks again!

Sorry,

A little background may help. The actual source data is stored in an encrypted file. The stored procedure I am writing calls an executable that pulls the data for...