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

Lynn Pettis (5/13/2016)

---

Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? Don't need a lot, just a few short...

What do you mean by this?

😎

Date is obviously better than int or char but the OP was exactly on those conversions to...

karthik M (5/13/2016)

---

All,

I have a thought on converting integer value (whereas date is stored in INT format) to Date. The same column is declared as char(8), so the convert...

zahid.techk (5/14/2016)

---

Hi All

I have facing problem to display information like Lag function, but Lag is not working on sql server 2012,

I want wo display data like tha...

Month_NameTotal_Test ...