Here's what it looks like with a little formatting, which goes a surprisingly long way to pointing out areas for improvement:

SELECT

pm.pm_no,

pm.pm_key,

trunc(pm.last_completion_dt),

pm.location_name,

loc.unid,

loc.location_desc,

loc.tva_eq_owner_key

FROM eam_od_pm_tb pm,

eam_od_location_tb loc

WHERE pm.site_id in...

LIYA (10/6/2010)

---

insert into DateFormat

select '2010-06-18 07:33:17' union all

select '2010-06-18 07:40:18' union all

select '2010-06-18 18:40:10' union all

select '2010-06-18 14:45:17' union all

i need the result as follows

Wdate

18/06/2010 07:33:17 AM

18/06/2010 07:40:18...

No, not at all. You're telling it like it is.

Brandie Tarvin (10/6/2010)

---

Chris Morris-439714 (10/6/2010)

---

More??? The next...

More??? The next question is kinda obvious...

With this number of rows to update, batching becomes attractive. Here's one way to do it, there are many.

-- Assumes trans_headerID is pk for table

UPDATE t SET CARD_NO = left(card_no,6)+'******'+right(card_no,4)...

St Peter's brewery! Nice!

Why don't you put your dates into your table source instead? Like this:

'FROM

(SELECT HeadCount,

StartDate FROM SAR_HeadCount where CampaignID = ' + @CampaignID +

' AND StartDate IN (' + @date1...

Naresh, I'm sorry - can...

A guess would be a null value for CMD_File_Date_Loaded in the third table, but to paraphrase JBM "a developer should know"

Alvin Ramard (10/5/2010)

---

Is it time to implement some sort of entrance exam for SSC? After reading the question I actually spent a few minutes staring at the screen thinking...

How do you detect whether or not a row from staging has been "processed"?

What is table [dbo].[Files] for? You haven't mentioned it in your dialogue.

naresh0407 93367 (10/5/2010)

---

Hi,

In the above stored procedure if i dont have HeadCount for particular date i am getting value as null but...

StartDate FROM SAR_HeadCount where CampaignID=' + CAST(@CampaignID AS VARCHAR) + ')

@CampaignID is out of scope otherwise.

Giant carnivorous mice