Piling on

😎

IF OBJECT_ID(N'dbo.TBL_SAMPLE_ACTIVITY_DATA') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_ACTIVITY_DATA;

CREATE TABLE dbo.TBL_SAMPLE_ACTIVITY_DATA

(

Workid INT IDENTITY(1,1) NOT NULL

...

jasona.work (5/19/2016)

---

yb751 (5/19/2016)

---

jasona.work (5/19/2016)

---

Brandie Tarvin (5/19/2016)

---

Greg Edwards-268690 (5/19/2016)

---

Brandie Tarvin (5/19/2016)

---

GilaMonster (5/19/2016)

---

Oooh. Am very tempted to grab both the R and the Data...

Brandie Tarvin (5/19/2016)

---

GilaMonster (5/19/2016)

---

Oooh. Am very tempted to grab both the R and the Data bundles.

The free book yesterday (Machine Learning with...

Thanks again Gail for the correction :Whistling:

😎

Avalin (5/18/2016)

---

I have a select-query using the WITH(NOLOCK) hint to ignore locks. The problem is that when the query is executed it get timed out because it's waiting for a...

Piling on

😎

-- this works

USE TEEST;

go

select object_id as GO

from sys.objects so

-- this doesn't

USE TEEST;

go

select object_id as

GO

from sys.objects so

The latter returns

Msg 102, Level 15, State 1, Line 10

Incorrect syntax near 'as'.

Msg...

dallas13 (5/17/2016)

---

We never use GO at the end of SP in sql 2005 and we never had any issues from application.

Now we migrated to sql 2014 and we are getting...

SELECT

*

,(A)SUM(J.JourneyDistanceMiles)

,(B)SUM(J.JourneyTotalFuelUsed)*0.219969157

,(A)SUM(J.JourneyDistanceMiles) / NULLIF(((B)SUM(J.JourneyTotalFuelUsed)*0.219969157),0) as [MPG]

FROM tablename;

😎

If the divisor is zero then obviously the division is invalid, next thing for you is to check your data

😎

Then force NULL output if the divisor is 0

😎

SELECT

*

,(A)SUM(J.JourneyDistanceMiles)

,(B)SUM(J.JourneyTotalFuelUsed)*0.219969157

,(A)SUM(J.JourneyDistanceMiles) / NULLIF(((B)SUM(J.JourneyTotalFuelUsed)*0.219969157),0) as [(NEW COLUMN) A/B AS...

How about this?

😎

SELECT

*

,(A)SUM(J.JourneyDistanceMiles)

,(B)SUM(J.JourneyTotalFuelUsed)*0.219969157

,(A)SUM(J.JourneyDistanceMiles) / ((B)SUM(J.JourneyTotalFuelUsed)*0.219969157) as [(NEW COLUMN) A/B AS MPG]

FROM tablename

Lowell (5/16/2016)

---

Complete non-sequitur here guys, but I'm rather pleased with myself.

I just got my MCSA after taking 70-463 Implementing a Data Warehouse in SQL Server 2012/2014.

I had set a mental...

GilaMonster (5/16/2016)

---

jasona.work (5/16/2016)

---

Somedays, I envy you folks living in places that don't have "weather" like what we've had these past couple weeks...

Last weekend, we had the windows of the house...

Solomon Rutzky (5/15/2016)

---

You should check the default Collation for the Database that was current when you ran that test. I suspect that it is using a Windows Collation (i.e. non-SQL_),...

Piling on on the CHAR(0), here are some of my favorites:

😎

SET NOCOUNT ON;

DECLARE @STR_WITH_ZERO_CHAR VARCHAR(20) = '123456789' + CHAR(0) + '1234567890';

-- CHARINDEX will not return the position of the CHAR(0)

SELECT...