Brandie Tarvin (8/5/2010)

---

Chris Morris-439714 (8/5/2010)

---

What creeps me out is when I left-join a child table to a parent, then inner join child to a grandchild, with no reference to...

Brandie Tarvin (8/5/2010)

---

Chris Morris-439714 (8/5/2010)

---

Jack Corbett (8/5/2010)

---

...

Where you place the criteria for OUTER JOIN's DOES make a difference. Whenever you place criteria in the WHERE clause that references a...

Jack Corbett (8/5/2010)

---

...

Where you place the criteria for OUTER JOIN's DOES make a difference. Whenever you place criteria in the WHERE clause that references a column in your OUTER...

Thom- (8/5/2010)

---

Well, I just have a simple query in my query window ->

insert into testtable

select a,b,c,d from openquery(server2,'select a,b,c,d from testtable2)

Now I'm getting the error -> how would I...

Why is that, Joe? I use COALESCE() if I want to return the first non-null value from a comma-delimited list of values....

Then make some up 😛

-- set...

There are some ideas in here...I've run out of time 🙁

Oops wrong thread 😛

Stefan Krzywicki (8/3/2010)

---

Gianluca Sartori (8/3/2010)

---

Brandie Tarvin (8/3/2010)

---

Stefan Krzywicki (8/3/2010)

---

Brandie Tarvin (8/3/2010)

---

You could get burned and find yourself without options (and jobs) if a employer decides they don't have the budget...

Tasteless and insensitive. Is that an olive branch or a sharp stick I see approaching?

Tom.Thomson (8/3/2010)

---

AH, the good old...

Jeff Moden (8/3/2010)

---

I'm reminded of something that Margaret Thatcher supposedly said and I'll paraphrase it because I didn't memorize it... the problem with socialism is that you eventually run out...

Hi Chris

Since a report type can depend on the values of up to six other columns, and not necessarily the same six between report types, I reckon pivot would make...

Have a look through Paul White's excellent server-side paging articles. They describe your problem and how to get around it.

http://www.sqlservercentral.com/articles/paging/69892/%5B/url%5D

That's shocking. Why so low? What's the going rate for a dba in your area?

I've just Jobserved SQL...

A little formatting goes a long way:

SELECT TOP (100) PERCENT

(SELECT DISTINCT dbo.tbl_ProductCategories.Description

FROM dbo.tbl_Product

INNER JOIN dbo.tbl_ProductCategories ON dbo.tbl_Product.FK_CategoryId = dbo.tbl_ProductCategories.CategoryId

WHERE (dbo.tbl_Product.ProductId = @ProductId)) AS Category,

Medium,

Brand,

SUM(CASE d .[Month]...