OK< thanks, what I am trying to do is use pivot to create cross-tab between items and stores. Basically I need to figure out what each item costs in each...

the import is manually triggered by user from an external site. After the import the data is manipulated. I think that instead of using truncation, I will eventually move the...

The CTE solution will work great. This forum is such a terrific resource for folks like me that are somewhat new to SQL.

thanks for everything,

P0etr

This will work great. thank you very much for your help,

Petr

This is definitely a better way of doing it. However, I am not sure about the TRUNCATE TABLE ps_micros_e7_time_clock_details statement. I don't want/need to truncate the table altogether as there...

Evil Craig,

absolutely love your sense of humor and your comments.

On the first issue: 1. There is a very distinct reason for this piece of code and I have no control...

Forgot to answer the indexes questions:

2 indexes set up - both Non-unique, Non-clustered

CREATE NONCLUSTERED INDEX [idx_e7_time_clock_details_startbusdate] ON [dbo].[ps_micros_e7_time_clock_details]

([ClockInTimeUtc] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB =...

Hello luis,

thank you very much for your quick reply. I kind of raised the same questions. I have just started in this job a week ago and this is one...