Nils Gustav Stråbø (5/20/2010)

---

Dymamic SQL is the only efficient way (in my knowledge) to solve the problem with multiple optional parameters....

Sure!

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

AndrewJacksonZA (5/19/2010)

---

That would definitely be a bonus since I often check my...

Unfortunately there's not a built-in tool to do that.

When I have to achieve the same thing I usually put the contants in a "global parameters" table.

To cut down the code...

Everybody does, but you! 😛

I'll be out the next three days. Family in town as my oldest...

The problem with first impression is that you can have only one.

No problem here, Jeff!

Your miracle is in my "cool sql stuff" folder, it won't get wasted!

Thanks for chiming in, Paul.

Your input is always welcome, especially when brings in something new!

I didn't know that syntax to specify column names for CROSS APPLY, thanks for sharing.

I love the site as it is, it's my primary resource for articles and forums.

I think I would like to see a special cathegory of articles focusing on business cases,...

As a side note, next time you ask for help, try providing a table script and sample data as I did in my reply.

You will find more people willing to...

PIVOT might do the trick for you:

DECLARE @test-2 TABLE (

SalesPart char(11),

WCDate datetime,

[Delivery Date] datetime,

Qtyint

)

INSERT INTO @test-2

SELECT '883/575/013',CONVERT(datetime,'21/03/2010',103),CONVERT(datetime,'21-MAR-10 00:00:00.000',113),4147 UNION ALL

SELECT '883/575/013',CONVERT(datetime,'21/03/2010',103),CONVERT(datetime,'22-MAR-10 00:00:00.000',113),1963 UNION ALL

SELECT '883/575/013',CONVERT(datetime,'21/03/2010',103),CONVERT(datetime,'23-MAR-10 00:00:00.000',113),2639 UNION...

Steve Jones - Editor (5/13/2010)

---

Gianluca, you ought to play with the newer Hyper-V or VMWare systems. The hypervisors are world's beyond 6 years ago. The last 2-3 years have seen...

I read in MVP Deep Dives that Hyper-V seems to be good at performance, but I don't have hands-on experience.

My latest fight with a database engine on a virtual machine...

I think Celko does nothing to be pleasant, but Peter's reply is terrific.

I often hear people saying that VMs are great for databases, but, in my experience, this is a no-go. Probably I don't know enough about VMs to configure everything properly,...