You can just declare a variable of your type and then run some inserts to populate it.

declare @myTable myTableType

insert @myTable

select...[whatever data you need to make your type]

select * from @myTable

Steve Jones - SSC Editor (3/7/2011)

---

Sean Lange (3/7/2011)

---

Another point about maintaining a system with encrypted stored procedures. If you do not keep the original script in source control you run...

Lowell (3/7/2011)

---

but he mentioned he's pulling from oracle...so joining a linked server table to your local table will threaten performance, because the command will copy the entire oracle table to...

Or join to the table.

Select ProjectID, ProjectName

from tabProject p

join tabProjectID pid on p.ProjectID = pid.ProjectID

Thanks. Admittedly not the way i would write it if it wasn't a one time thing. Appending strings and such. UGH!!! Hope this helps.

Since this is .net and you sending this data from views I will assume your are using a DataTable to hold the data? You could debug the code and look...

What about your wsdl file? That has everything in there.

Another point about maintaining a system with encrypted stored procedures. If you do not keep the original script in source control you run the risk of not knowing what the...

Are you doing an update from and the join can have multiple returns? If that is the case then you need to find a way to isolate the values you...

Same deal. If you try to drop a temp table that doesn't exist it will throw an exception. If you drop an existing temp table it will work fine.

SELECT dbo.O3.[s.no] AS [O3_Sn.NO], dbo.O5.[s.no] AS [O5_Sn.NO], dbo.O3.O3, dbo.O5.O5,

case when dbo.O3.[s.no] > dbo.O5.[s.no] then 'true' else 'false' end as ComparisonColumn

FROM ...

I think you are asking if you have to wrap the create table with an exists check? You do not have to, but it will throw an exception if the...

Jeff - here is my proof of concept. I spent a little time to clean it up so that somebody else might be able to understand.

The sql file in...

Yes, but I try my best not to limit to just Friday's.

Jeff - I will try to get it cleaned up a little bit and post it either today or tomorrow.