I don't understand this at all. . . is the month stored as an INT? Or is it actually a DATETIME that you get the month from?

The reason I ask...

Jan Van der Eecken (6/8/2010)

---

Why make it that complicated?

DECLARE @Fathers TABLE (FatherId VARCHAR(10), age INT)

INSERT INTO @Fathers

SELECT 'Father1', 12

UNION...

lol, just answered an identical question that wanted the largest instead of the smallest from the data set.

--First things first, since you have provided this in your question,

--I build some...

This should work for you.

--First things first, since you have provided this in your question,

--I build some dummy data.

DECLARE @Table1 TABLE(

[Father] ...

Hmmm, I've read about this problem before. I think the code you want is: -

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'

ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY

CLOSE...

C# in 2008.

Or compile whatever code you want and call it (not tried myself, but heard it can be done)

ColdCoffee (6/7/2010)

---

skcadavre (6/7/2010)

---

ColdCoffee (6/7/2010)

---

If your request is what Sckadavre is saying, then this might help you! This code doesn use a self-referencing CTE, but assuming your string contains only one...

This code is not mine, not sure where it came from but I used it to do the same thing.

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetAllTableSizes]')...

ColdCoffee (6/7/2010)

---

If your request is what Sckadavre is saying, then this might help you! This code doesn use a self-referencing CTE, but assuming your string contains only one Key1: "

DECLARE...

Something like this?

I've returned both the start bit and the end bit, basically getting rid of the "Key" part, because I wasn't entirely sure what you're after

(code has been...

It depends. . .

SELECT ...

FROM ...

WHERE EXISTS ...

??

Without knowing how your mailserver stores anything, I'll give you that to get started.

No, you can't.

What about using the "on failure action" in the agent job?

I think you've misunderstood how your code works. . .

This is your code, with some comments: -

-- Declare Variables

DECLARE @AcctNbr AS VARCHAR(9)

SET @AcctNbr = '026983970'

DECLARE @ErrCode AS BIT

DECLARE @AcctNum AS...

Before I spend time answering you, let me see if I actually understand your question.

DECLARE @Table1 TABLE(

[AppId] ...

This article is quite informative[/url] for what you want to do.