I agree with john but here is a very generic script all the same that would do the job.

Declare @stmt nvarchar(500)

set @stmt='create table ##Locations ('

select @stmt = @stmt + LastName...

Not having anything at all to do with SQL server aside here is a technet article on the subject.

http://technet.microsoft.com/en-us/magazine/ee851678.aspx

I am curious what the logic is in this select. Since you are pulling two ID fields only I am not sure what benefit you get from using the...

I think the value of a seperate table is dependant on the case table. If this is a historical table then I think a seperate table is ver reasonable....

I would not say I am a developer as much as I am a tincker'er (I just made that word up :-D)

I would say however that I have had to...

Ok I am starting to think I need to reinstall my bids.

I just tried it on another machine and it works fine but it still does not work on my...

Steve,

I see what you are saying but I think that argument can be made about alot of things. I know plenty of people with high level certification on one product...

as long as the sql statement returns a single value alone then you can do

@variablename= select 1

or

@variablename= exec(@sql)

again select statement can return one and only 1 value.

James are you suggessting if Microsoft offered you MVP status in a few years you would not give a rats a** as you put it. I do not activly...

I quess I am a little confused by you rlast post. The script I provided should do what you have stated unless there are data elements I am not...

I would think having a parm table would take care of your issue. you could handle the conditional situations with your code. If this is not a new...

hmm maybe that is it. I do have 2005 and I opened up one of my packages and tried the command and it does not like it at all....

sorry I am dense today! I see what you are saying now. you would like it to output the row then update the date and output again.

Phil, do you have any additional references added. I tried that back when I was working on my script and that command was not recognized. I suspect I...

In your cases table can a judge be asigned to more than one case? are there any keys that prevent that? If not I would not base your...