Pokemon

Check the following post: http://www.sqlservercentral.com/Forums/FindPost1275453.aspx

You could follow the whole discussion as well.

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...

Alchemist

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...

No need to remove the dash (-).

DECLARE @cDate nvarchar(50) = 'May - 2016' ;

SELECT CONVERT( date, '01 - ' + @cDate );

Sean Lange (7/14/2016)

---

Great question. Oddly after answering I decided to see if it really would correctly. I ran the create table and view scripts. Then ran the insert statement. It...

burger

Have you at least checked the Microsoft page? https://www.microsoft.com/en-us/learning/exam-70-461.aspx#books

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...

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)

---

Now Wales are after independence from England to 'safeguard' their future...despite the fact that they also voted in favour of Brexit...

Try this:

SELECT cmoOrganizationID

,cmoName

,omlPartGroupID

,sum(CASE WHEN Year_ = 2013 THEN omlExtendedPriceBase ELSE 0 END) AS [2013]

,sum(CASE...

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...

Do you understand how the code works? Please, post questions you might have or you might not be able to support it.

Try this, you might need to check if you need to use the start or the end of the connection or both. I don't know, so I just left that...