sqlnewbie17 (5/2/2016)

---

How to get only version number from

select @@version

Result should be 2000/2005/2008/2012... only

and not the entire string as here:

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64)

Aug 19 2014...

You might find this post helpful[/url]

😎

Can you post the execution plans for both queries? When updating the statistics did you use full scan, sample or resample? Are the maxdops the same on both?

😎

Luis Cazares (4/29/2016)

---

Something like this?

SELECT DISTINCT

CASE WHEN MAX(Criteria) OVER( PARTITION BY ServiceName) <> MIN(Criteria) OVER( PARTITION BY ServiceName)

...

errare humanum est.

😎

Homo...

Out of curiosity, how many jobs do you have?

😎

The error message states that the table/view "TimCIS.dbo.Legis_Districts.Zip4" cannot be found, check the actual database and object names and make certain you can run queries like

SELECT COUNT(*)

FROM TimCIS.dbo.Legis_Districts.Zip4;

😎

Quick question, do you have a database called TimCIS?

😎

Lowell's code in a slightly different flavour

😎

DECLARE @DROP_JOP_TEMPLATE NVARCHAR(MAX) = '

-- {{@JOB_NAME}}

IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N''{{@JOB_NAME}}'')

EXEC msdb.dbo.sp_delete_job @job_name=N''{{@JOB_NAME}}'', @delete_unused_schedule=1;

';

SELECT

REPLACE(@DROP_JOP_TEMPLATE ,N'{{@JOB_NAME}}',MSSJV.name)...

Quick thought, you can pass null as job_id and the job name, sp_delete_job uses sp_verify_job_identifiers to find the job_id if it isn't passed to the proc. Behind the scene it...

BLOB_EATER (4/29/2016)

---

GilaMonster (4/29/2016)

---

GilaMonster (4/27/2016)

---

BLOB_EATER (4/27/2016)

---

GilaMonster (4/26/2016)

---

BLOB_EATER (4/26/2016)

---

GilaMonster (4/26/2016)

---

SQLRNNR (4/26/2016)

---

The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according...

GilaMonster (4/26/2016)

---

Fixed that for you. 🙂

I loved it. A lot of other...

SQLRNNR (4/26/2016)

---

jeff.mason (4/26/2016)

---

I was thinking Rey, Finn and Kylo. They obviously need a villain figure, but the idea of an emo Dark Lord who has no control of his...

Didn't mean to post that in the first place, hit post...

ganapathy.arvindan (4/26/2016)

---

Please let me know way to work this one or any alternative way to achieve it..Thanks in advance

SELECT

CASE

WHEN (SELECT ShiftType=2 FROM dbo.ShiftScheduler) IS NOT...