Have you thought about creating a query table in excel?

Surely the fewer text functions the better? Frank...what is wrong with doing it this way (assuming you are just padding out an integer, which was the question)?

DECLARE @intX int

SET @intX...

DECLARE @intX int

SET @intX = 123

SELECT RIGHT(CONVERT(varchar,1000000 + @intX),5)

------

00123

Could it be to do with the execution plan being re-used (so when you ran it in QA it was much quicker)?

Hi,

Seems to work if you add a from clause...

if

(select count(*)

FROM

(SELECT getDate() as dtmToday where datepart(weekday,getdate()) not in (1,7)) t1 ) > 0

BEGIN

PRINT 'WEEKDAY'...

May not be practical or possible, but you could have a table in with the numeric scores for the various possible answers. Then you could join the tables on the...

I think the last reply was right. There must be some other sql running that is triggered by that update. The trigger must be using an "=" which you it...

You could use the sql.request function from the excel odbc add in - tools - add ins - "ODBC add-in". Then you can return stuff from your database from the...