Lynn Pettis (6/7/2012)

---

Other than all those double quotes (which I removed), I really don't see anything wrong with the code below:

UPDATE P SET

Stock = T.Stock

FROM

...

As I have learned in my brief time posting to this forum, there's always a better way!

Not sure if this is but I'll take a shot.

CREATE TYPE MyTable AS TABLE

...

Or, if I'm not mistaken, this should also work:

DECLARE @Date TABLE (Id int, start_time datetime, End_time datetime)--, time_diff

INSERT @Date

SELECT 16496, '2012-05-19 06:01:36.767', '2012-05-19 06:01:36.783' UNION ALL

SELECT 18496, '2012-05-19 06:01:36.767',...

Perhaps a little more concisely:

DECLARE @qtr INT, @year VARCHAR(4)

SELECT @qtr=2, @year='2012'

;WITH Tally AS (SELECT TOP 366 n=ROW_NUMBER() OVER (ORDER BY (SELECT NULL))-1 FROM sys.columns)

SELECT Fridays=AllDays

FROM Tally

CROSS APPLY (SELECT DATEADD(day, n,...

Jeff Moden (6/7/2012)

---

And, just to be sure... RAND does NOT return the closed interval of {0,1}. It's a closed-open where 0 materializes but 1 never does. As Dwain...

saghbash (6/7/2012)

---

Dear All thanks for the help and guidance. Just to advise you of what I ended up doing. As some of the proposed solution were too complicated. For me...

Well, I can try. I saw this technique in the "Replace CASE expression and UNPIVOT operator" section of this article: http://beyondrelational.com/modules/2/blogs/70/posts/10905/interesting-enhancements-to-the-values-clause-in-sql-server-2008.aspx

The COUNT(Products) construct is counting non-null values across the...

paul.knibbs (6/7/2012)

---

dwain, Jeff said this was the expected behaviour in the article:

The following code generates a million rows of random integers (the SomeRandomInteger column) with possible values from 400 to...

Hey Jeff!

Using your test harness yesterday, I ran into some unexpected (for me) results. Let me explain:

--===== Declare some obviously named variables

DECLARE @NumberOfRows INT,

...

David McKinney (6/6/2012)

---

dwain.c (6/5/2012)

---

Just to show that I'm keeping current on SQL 2008 stuff, and probably for no other reason, I thought I'd post a less verbose alternative.

SELECT Employee, NEW_LOB,...

I know that this is probably a little out of line of me, trying to bring the thread back on topic and all, but this problem was bugging me all...

Just to show that I'm keeping current on SQL 2008 stuff, and probably for no other reason, I thought I'd post a less verbose alternative.

SELECT Employee, NEW_LOB, NEW_DEPARTMENT, NEW_COST_CENTRE, NEW_MANAGER,...

Ooops! You are correct....

Now here's an interesting result. I took a slightly refactored version of Vinu's EXCEPT query and compared across a large test harness to mine.

Create Table #Ex

(Column1 int, Column2...

I believe this will also do it for you, likely with only a single pass on the source table (other solutions probably do 2 passes):

Create Table #Ex

(Column1 int, Column2...