Viewing 15 posts - 7,576 through 7,590 (of 10,144 total)
Brandie Tarvin (8/5/2010)
Chris Morris-439714 (8/5/2010)
August 5, 2010 at 8:24 am
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...
August 5, 2010 at 8:21 am
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...
August 5, 2010 at 8:00 am
Thom- (8/5/2010)
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...
August 5, 2010 at 4:17 am
CELKO (8/4/2010)
...Also, start using COALESCE() instead of ISNULL() ...
Why is that, Joe? I use COALESCE() if I want to return the first non-null value from a comma-delimited list of values....
August 5, 2010 at 2:19 am
Chris-475469 (8/4/2010)
I'm little reluctant to post some actual data on here because its pretty sensitive. But here is the definitions of the tables i'm using.
Then make some up 😛
-- set...
August 4, 2010 at 6:47 am
There are some ideas in here...I've run out of time 🙁
Oops wrong thread 😛
August 3, 2010 at 10:24 am
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)
August 3, 2010 at 8:34 am
Steve Jones - Editor (8/3/2010)
Since this is the water cooler, any comments?http://abcnews.go.com/US/ground-mosque-plan-stirs-controversy/story?id=10670631
Tasteless and insensitive. Is that an olive branch or a sharp stick I see approaching?
August 3, 2010 at 8:12 am
Tom.Thomson (8/3/2010)
Chris Morris-439714 (8/3/2010)
We've recently finished a few years experiment with socialism here in the UK. Everybody's even now, but some are more even than others 😀
AH, the good old...
August 3, 2010 at 8:01 am
Jeff Moden (8/3/2010)
August 3, 2010 at 7:41 am
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...
August 3, 2010 at 2:39 am
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
August 3, 2010 at 2:20 am
Gianluca Sartori (8/2/2010)
BTW, my hourly rate is around 11 euros (14 dollars).
That's shocking. Why so low? What's the going rate for a dba in your area?
I've just Jobserved SQL...
August 2, 2010 at 6:44 am
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]...
July 30, 2010 at 7:58 am
Viewing 15 posts - 7,576 through 7,590 (of 10,144 total)