You can use a table-valued function (TVF) in a SELECT, so if the logic can be moved from the procedure to a TVF that might work. You can't call...

Perfect Lutz!

Clickable version of that link:

Deprecated Database Engine Features in SQL Server 2008

GOTO is part of the T-SQL language and probably always will be. It can be quite useful, and...

You're most welcome...

Very good. I'm reminded of another characteristic of an 'expert'...

...and not possible with a T-SQL table-valued function either, since dynamic...

Ok Barry here we go. I've tried to cover everything so it's readable for the wider audience - so apologies for the amount of detail:

1. SQL Server expects...

Yes it seems you would need some fairly hairy dynamic SQL to produce a CREATE VIEW statement. You would need to decide on some scheme to rename columns whose...

How odd. :hehe:

RBarryYoung (1/12/2010)

---

Any chance you could explain your Helper class a little? (you know, a Helper Helper? :-D)

For obviously selfish reasons I am very interested in implementing it in VB.net, and...

I usually use client_net_address as Lowell says.

Doesn't work so well for clients connecting over Named Pipes of course :laugh:

I was rather assuming that the data is all string representations of a GUID. If so, I would be amazed if a double convert wasn't the absolute fastest way:

DECLARE...

Can't think of a way, no.

I'll come back to this is the morning, but my initial reaction is that it can't be done.

If the column is one of the string types, all you need is CONVERT(UNIQUEIDENTIFIER, column_name).

That will remove the braces. CONVERT once more back to CHAR or whatever if you...

So you did :laugh:

I read that post more than once and missed that part every time! ...