You can do it without a UDF!

However, reading this nice little code code by SQL Server Adam Machanic http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true the question is rather, why?

Now, one thing is very strange here.

You say, you get a Severity: 10 while sysmessages report a severity level of 15. Anyway, the first level is informational, while the...

Anyone remembering the good old BBS times? With a 9,600 baud modem?

It's simply "Honour to whom honour is due"

Thanks, one thing I've forgotten to consider.

Can there be gaps in your date sequence?

Jan, you know that such a table structure violates 1 Normalform? If you have the chance to get rid of this structure, go for it and normalize the structure.

Sure, generate the script and post it here.

And never, ever do such things with EM. It is inefficient and in most cases drops...

One way would be:

SET NOCOUNT ON

IF OBJECT_ID('lfdsum_t') IS NOT NULL

     DROP TABLE lfdsum_t

GO

CREATE TABLE lfdsum_t

(

 thedate DATETIME

 , [value] int)

INSERT INTO lfdsum_t values ('20050101', 10);

INSERT INTO lfdsum_t values ('20050102', 15);

INSERT INTO...

SET NOCOUNT ON

CREATE TABLE #notnice

(

 id INT IDENTITY PRIMARY KEY

 , ORDER1 INT

 , ORDER2 INT

 , ORDER3 INT

)

CREATE TABLE #better

(

 id INT

 , [ORDER] INT

)

INSERT INTO #notnice VALUES(34,44,55)

INSERT INTO #notnice VALUES(340,440,550)

INSERT INTO #better (id,...

Farrell, here's another method:

LEFT(DATENAME(month, '20050101'), 3) + REPLACE(STR(day('20050101'),2),' ','0')

But I think Jeff's method is much more elegant and efficient.

So, the program does not require *any* user interaction and terminates after it has printed its' stuff? What about a DTS package with Execute Win32 task (I think it is...

If you can verify that "the" is only used within "thewebaddress" and you want to avoid some keystrokes, this should also work

UPDATE....REPLACE('all.user@thewebaddress.org', 'the', '')

But you might be on the...

Anything interesting you left out in the dots?

Hm, I've never come across this error before and the Google groups doesn't seem to be a big help, too. Is this the...

Sorry, I don't understand. Do you mean, EM kicks you out when you try to change the table? I would bcp or DTS the data out, let EM create a...

Error 2768

Can you post a sample error message?