Or try SSMS add-in SQLTreeo. It enables you to organize tables, databases or stored procedures in your custom folders.

Thanks very much!

I wrote exactly same query in the meantime. Only thing I would change for metioned large datasets is adding WHERE clause to last update which filters only rows...

Hi,

just to let you know: I've finally finished mentioned SSMS custom folders add-in. It is downloadable here.

Jakub

We've already discussed that a bit Please read the full thread.

Jakub

Yes, it's working in Denali as well...

See this schematic "code":

1) Pull data from fixed tables to temporary structures (used for sharing) only once

2) Perform complex logic above temporary structures

Point 2) includes calling to many functions and...

Agree, but you must also include performance aspect. If I use solution you described it would mean that for every call of this function I would have to insert data...

To be honest, I am not sure if I understood well your problem - can you explain it in more detail? It looks that using UDDT as input parameter might...

I'd also suggest reading article in link below. This is exhausting description of all possible options which you can use for sharing data between procedures. I really spent a lot...

Practical example behind this article was following:

I needed to share data among stored procedures because I had very complex task which required to pull data from fixed tables to...

Hi,

since BusinessEntity has BusinessEntityID column which is Identity (1,1), you can get ID of newly inserted BusinessEntity by calling built-in SCOPE_IDENTITY() function.

Like that:

DECLARE @businessEntityId INT

-- insert into BusinessEntity

SELECT @businessEntityId...

Hi,

there might be some missing index, incorrect statistics, generally whatever because there are completely separated environments. I would check execution plans of both queries at first. If you can paste...

Hi,

I've read quite good article on this theme few weeks ago here - http://www.learn.geekinterview.com/resources/interview-articles/sql-interview-questions-with-answers.html.

Jakub