Viewing 15 posts - 7,126 through 7,140 (of 8,731 total)
raulggonzalez (1/22/2014)
Jeff Moden (1/21/2014)See the example code that Luis posted above for one possibility.
I did and I read the article you published, and I really enjoyed reading it, thank...
January 22, 2014 at 9:49 pm
I can't remember if it's true, or maybe my mind is playing tricks on me, but an update will only update rows once even if a correspondant select would show...
January 22, 2014 at 4:00 pm
ashok.theagarajan (1/22/2014)
January 22, 2014 at 9:49 am
You need to add the year to your weekrange column (or add it in a different column). Even if you don't display it, you need the information so SQL Server...
January 22, 2014 at 8:28 am
It still depends on the time needed to display the results, possible table locks, disk speed, etc
January 21, 2014 at 5:48 pm
It depends.
What about possible network issues? Wil the query use functions? indexes?
Many things can cause poor performance or great performance.
January 21, 2014 at 5:29 pm
sharonsql2013 (1/21/2014)
Select *from SomeTable
where table_id LIKE '%' + @ID+ '%' OR table_id LIKE '%'
Well, it always give all values irrespective of parameter.
That's because "OR table_id LIKE '%'" makes your WHERE...
January 21, 2014 at 3:44 pm
hisakimatama (1/21/2014)
January 21, 2014 at 3:22 pm
hisakimatama (1/21/2014)
I'd be careful of using this sort of query, though; without the proper proofing, it's open to SQL injection, and all of its assorted security risks.
Can you explain how...
January 21, 2014 at 3:01 pm
steven.ensslen (1/21/2014)
However the point of a date dimension is not that is stores all of the days of a year. That's trivial. ...
January 21, 2014 at 2:55 pm
You could certainly use the new capabilities to avoid the temp table.
I can't help you on that right now because I don't have an instance of 2012 to test...
January 21, 2014 at 1:32 pm
Do you need something like this? I think I'm missing something.
SELECT Id,
dim0,
dim1,
dim2,
value1,
value2,
description,
UDF1
FROM PTMaster
UNION ALL
SELECT M.Id,
M.dim0,
M.dim1,
M.dim2,
D.value AS value1,
0 AS value2,
D.description,
M.UDF1
FROM PTMaster M
JOIN PTDetail D ON M.Id = D.FactId
January 21, 2014 at 1:15 pm
It might not be my day, because I might have overcomplicated myself with this. I haven't noticed that you needed a running total (balance). Here's an option using a fast...
January 21, 2014 at 1:09 pm
Jeff Moden (1/21/2014)
aaaaaaaahhhhhhh.... I do wish you lived in the Detroit area.
I wouldn't mind to change my address. Especially to a city that hosts an NFL team.:-D
January 21, 2014 at 12:07 pm
With no DDL or sample data, there's not much we can help.
The usual method, would be to do a left join with your periods table.
January 21, 2014 at 11:58 am
Viewing 15 posts - 7,126 through 7,140 (of 8,731 total)