Farrell - maybe it's time to hit the pubs again - thirst can do this to a man!

editing - pubs - as in...

CM - I'm curious - are you by any chance from India ?! For some weird reason (unless it's coincidence) I've come across 2 posts referring to these "magic tables"...

Oops - my bad! - saw tasks, steps etc... and just assumed you're talking about the system tables....

why don't you post the ddls and...

Olivier - see if you can find this in your "sysjobsteps" system table in the "msdb" database...

DECLARE @singleRow varchar(1000)

SET @singleRow = ''

SELECT @singleRow = COALESCE(@singleRow + Name + '|', '')

FROM myTable

PRINT @singleRow

Hey - that's a novel way to increase your post count...

funny - good thing no users are reading this...

But it has been very frustrating alright for the last 2 weeks...I think only remi...

follow thread here

Dimitri - as Paul indicates, you could check one of several things depending on your requirements....

1) you could select @@rowcount to find out how many rows have been affected by...

I do - just didn't understand the question - so didn't realize the "sameness"!!

at any rate I don't want to go back to being "waitinginlineforleftoverscraps" so now that you're...

ok remi - i'll be off then...

KG - do you mean you want to use the output of one procedure as input to another nested procedure ?!

ppa - the order of columns in your "insert into" table may be different from the column order in your "select from"...at any event, it's always good practice to explicitly...

Robert - your prodweekend is an alias...use the actual column names in your function - something like this...

select [Due Date] - [+31b] as prodweekend, fn_somefunction([Due Date] - [+31b]) as calcColumn...

Suggestion - you could try configuring ODBC to "Use regional settings when outputting currency, numbers, dates and times"....and see if that fixes it!