You might want to check this thread.

Seemes like someone finally found a way to do it. I haven't tested it myself though...

Thank you, Paul! :blush:

It's starting to pay off hanging around here for a while.... 😉

The following should at least help you to get you started (please note how I set up sample data in a ready to use format...)

DECLARE @t TABLE (ID INT ,Key_...

I cannot confirm what you describe:

Table definition:

CREATE TABLE [dbo].[Table_1](

[z] [int] IDENTITY(1,1) NOT NULL,

[a] [int] NULL,

[int] NULL,

[c] [int] NULL,

[d] [datetime] NULL CONSTRAINT [DF_Table_1_d] DEFAULT (getdate())

) ON [PRIMARY]

Excel file (grid...

It's still an insoluble puzzle...

Just for the sake of it (since the business reason is still a secret to me):

DECLARE @TheColumn INT

SET @TheColumn = 1

SELECT left((2009 + @TheColumn / CASE WHEN @TheColumn <10...

Completely understood. But...

Tara-1044200 (1/12/2010)

---

great, Lynn's query

worked for me.

For the same real data type how would i update...

I agree with you and my comment didn't question your solution at all...

Since we're...

That's really strange...

Your query only removes the last character, but not the first one:

declare @x varchar(50)

SET @x='{FFFFFFFF-0000-0000-0000-000000000463}'

SELECT substring(@x,1,len(@x)-1) --{FFFFFFFF-0000-0000-0000-000000000463

SELECT substring(@x,2,len(@x)-2) --FFFFFFFF-0000-0000-0000-000000000463

But...

Here's what I came up with to cover the options I think we're faced with...

If the base column is of data tpe INT I actually doubt that it would be...

Excellent you found...

Based on BOL, extended by some more parameter (untested, but should work):

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'AdventureWorks Administrator',

@recipients = 'danw@Adventure-Works.com',

@query...

Leipzig, (South-) East Germany, Central Europe. 🙂

It depends on where you want to start...

Assuming, you need to start from the very beginning, I'd recommend the following article:

http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/

Once you succesfully send the testmail you should check...