Why, you'll have to take the day off now??

Have only 2 words left to say :

Moo point!

Did you read my idea about a cookie (javascript). Shouldn't be too hard to install.

As for making it happen, start a reply, wait an hour (15/20 minutes seems to...

Can you give the rest of the detais??

Sample data/ddl and output in the other tables would really help a lot .

Good luck.

Vacation is in 7 days (last 2 weeks of July).

You know you can edit your posts, right??

Ya I saw it afterwards... call it wrong timing .

Well it can be done on the server. But the way it is done is to create a new connection in the proc and execute a statement in that...

I'm not the expert, but I know that they'll want to know this :

What error message are you getting?

HTH.

Shoot.

I post this code all the time :

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as varchar(8000)

SET @Items = ''

SELECT

@Items = @Items + C.Name...

Can't be done. You can't garantee that one execution will end before the other and I don't think that 2 records set would be returned anyways.

How long does it...

Sorry about the loss of formating...

This is not the shortest way of writting the code but it works well and gives a remote procedure call on the server instead of...

Probabely won't be faster... might even be slower.

execution plan :

--use the results in text mode (make sure you can show more than 255 characters per line in tools/options/results/max char...