Glad we could help!

Note, this particular approach only works if your @sql variable starts with 'SELECT '.

Just add these three lines onto the end of your script:

DECLARE @AdjSQL NVARCHAR(MAX) = 'SELECT @ret = ' + SUBSTRING(@SQL, 7, LEN(@SQL));

EXEC sys.sp_executeSql @AdjSQL, N'@ret AS INTEGER OUTPUT', @Results OUTPUT;

Select...

RBarryYoung (9/18/2009)

---

I'm a lot more curious as to how you do this...?

Great trick though. ...

RBarryYoung (9/18/2009)

---

Well, if daft comments put me off...

Note my use of Format 112, which is the unambiguous ISO Date-only standard format. If you want to play date-only string games (as opposed to all explicit conversions, like...

This is probably caused by conflicts between you SQL Server's SET LANGUAGE defaults, the Servers, region/national settings and your use of format 110 which is very non-standard.

Notice that in your...

stricknyn (9/17/2009)

---

I have a project in which I need to do two things:

The first is send a variable into a VB or C# executable program that was written by someone...

wwei (9/17/2009)

---

I think we can do this by:

Create a variable in BIRD.

Put an Execute Processing Task, in its Editor, Set the Executable as the executable written by c#/vb. Expend the...

Paul White (9/18/2009)

---

RBarryYoung (9/18/2009)

---

Well, if daft comments put me off then I never would have become a consultant (I'm pretty sure that any consultant will back me up on that...

Actually, it was an excellent apology, once of the best ever. 🙂

No, no, no, NOT true! Let me explain ...

In your "football", everyone...

RBarryYoung (9/18/2009)

---

Well, if daft comments put me off...

Well, if daft comments put me off then...

I'm a lot more curious as to how you do this...?

Great trick though. 🙂