Viewing 15 posts - 2,506 through 2,520 (of 8,731 total)
Y.B. (7/14/2016)
What you originally proposed isn't that complicated...
I suggest that you follow the link I posted. There's a similar version of your code which runs about 4 times slower than...
July 14, 2016 at 1:25 pm
HappyGeek (7/14/2016)
djj (7/14/2016)
Manic Star (7/14/2016)
Reader
LIbrary
Data
Capture
Pokemon
July 14, 2016 at 1:12 pm
Check the following post: http://www.sqlservercentral.com/Forums/FindPost1275453.aspx
You could follow the whole discussion as well.
July 14, 2016 at 11:34 am
Why do you think that you need to use the APPLY operator? You should probably change the joins to the SQL-92 format, but that won't improve performance.
The query seems to...
July 14, 2016 at 11:20 am
crookj (7/14/2016)
Ray K (7/14/2016)
djj (7/14/2016)
Ed Wagner (7/14/2016)
ChrisM@Work (7/14/2016)
Revenant (7/14/2016)
djj (7/14/2016)
Ed Wagner (7/14/2016)
Luis Cazares (7/14/2016)
crookj (7/14/2016)
Ed Wagner (7/14/2016)
Grumpy DBA (7/14/2016)
Ed Wagner (7/14/2016)
ThomasRushton (7/14/2016)
Ray K (7/13/2016)
LucyLastic
Elastic
Plastic
Melt
patty
burger
Beef
Pork
Porcupine
Concubine
Python
Monty
Full
Metal
Alchemist
July 14, 2016 at 10:11 am
j-1064772 (7/14/2016)
A minor pet peeve on writing style: being accustomed to reading from left to right and top to bottom
FROM Mission AS m
LEFT JOIN [Primary] AS p ON...
July 14, 2016 at 9:32 am
No need to remove the dash (-).
DECLARE @cDate nvarchar(50) = 'May - 2016' ;
SELECT CONVERT( date, '01 - ' + @cDate );
July 14, 2016 at 8:38 am
Sean Lange (7/14/2016)
July 14, 2016 at 8:30 am
crookj (7/14/2016)
Ed Wagner (7/14/2016)
Grumpy DBA (7/14/2016)
Ed Wagner (7/14/2016)
ThomasRushton (7/14/2016)
Ray K (7/13/2016)
LucyLastic
Elastic
Plastic
Melt
patty
burger
July 14, 2016 at 7:41 am
Have you at least checked the Microsoft page? https://www.microsoft.com/en-us/learning/exam-70-461.aspx#books
July 14, 2016 at 7:39 am
This can get you a copy-paste-exec code. Be careful with it.
DECLARE @command varchar(1000) ;
SELECT @command = 'SELECT ''USE [?]'';
select ''DROP USER '' + QUOTENAME( u.name)
from master..syslogins l
right...
July 14, 2016 at 6:49 am
jasona.work (7/14/2016)
ChrisM@Work (7/14/2016)
SQLRNNR (7/13/2016)
ChrisM@Work (6/29/2016)
tindog (6/29/2016)
ChrisM@Work (6/29/2016)
tindog (6/29/2016)
ChrisM@Work (6/29/2016)
tindog (6/29/2016)
July 14, 2016 at 6:38 am
Try this:
SELECT cmoOrganizationID
,cmoName
,omlPartGroupID
,sum(CASE WHEN Year_ = 2013 THEN omlExtendedPriceBase ELSE 0 END) AS [2013]
,sum(CASE...
July 13, 2016 at 2:21 pm
You need to be sure that the information is correct. In SQL queries, it's very easy to get information that seems correct but it isn't. I gave you what seemed...
July 13, 2016 at 1:14 pm
peter 67432 (7/13/2016)
Exacty! thanks!
Do you understand how the code works? Please, post questions you might have or you might not be able to support it.
July 13, 2016 at 9:14 am
Viewing 15 posts - 2,506 through 2,520 (of 8,731 total)