2018-06-05 (first published: 2018-01-11)
2,138 reads
View
RE: help with a query
Hmm.. I don't know, Remi... it seems they have their own business logic, with months absolutely independent on real calendar maybe setting things right would create confusion.If we suppose that you don't want to (or can't) change anything, try this:SELECT Q.city_code, Q.outlet_code, SUM(Q.sold0104), SUM(Q.sold0508),SUM(Q.sold0913),SUM(Q.sold1417),SUM(Q.sold1821) FROM (select [city_code], [outlet_code], CASE WHEN issue BETWEEN 1 AND 4 […]
2005-04-28
RE: Curious Locking
Thanks for that..had a look.The execution plans were identical.I tried varying the indexes on this table. One index in particular was dropped and it cured the problem....the query now runs in about 5 minutes instead of an hour. Funny thing is the same indexes exists on a similar test system and that runs ok??Thanks again..Graeme
2005-03-11
Validating Stored Procedure results
Does anyone know a way to validate the results of a stored procedure? I have a routine that checks for updates to procedures and validates the format of the data returned but the only way I can do that is to dump the results to a temp table. I can't insert into a temp table […]
2004-11-12
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers