A semi-dynamic query is straight forward

😎

USE tempdb;

GO

--CREATE TEST DATA

IF OBJECT_ID('tempdb..#PivotTestTable') IS NOT NULL DROP TABLE #PivotTestTable

CREATE TABLE #PivotTestTable

(

[SURVEY_REF] [nvarchar](100) NOT NULL

,[QUESTION] [nvarchar](MAX) NULL

,[ANSWER] [nvarchar](100) NULL

,[DATE_REC] [nvarchar](10) NULL

,[TIME_REC] [nvarchar](10) NULL

)

INSERT...

It is a connection manager error, by the looks of it, it cannot locate...

autoexcrement (5/27/2014)

---

I am using a database with a CI collation, but where some of the columns in some tables are set to a CS collation.

Is there any way to...

mickyT (5/27/2014)

---

Hi

I've had a look at a few options and for the data the I'm testing on, this appears to be the best solution (for SQL 2012 +). It...

Johnny H (5/27/2014)

---

Here is what I have tried. Setting GEOMETRY to GEOGRAPHY, then a inner join, I have also tried with a union with the same error results.

DECLARE @sign...

Roust_m (5/27/2014)

---

The problem is, if you hardcode the clock move dates, you may get it wrong, as Australian government sometimes changes those dates.

The server timezone is (UTC-06:00) Central Time (US...

Something like this?

😎

USE tempdb;

GO

DECLARE @test-2 TABLE

(

Test INT NOT NULL

,FristPull ...

Roust_m (5/27/2014)

---

Can you please elaborate on this?...

Thanks, I'll give it a go.

😎

Bear with me here, but why not do this in TSQL as a set based operation?

This is true (the CLR are...

Roust_m (5/26/2014)

---

Hi,

I have a query, which eats massive amounts of CPU because of a CLR function, which deals with local time (our server system time (US) is different from local...

This should get you started

😎

/* convert geometry to geography */

DECLARE @GEO1 GEOMETRY = geometry::STGeomFromText('POINT (-122.358 47.652)',0);

DECLARE @GEOG GEOGRAPHY = geography::Point(@GEO1.STY, @GEO1.STX, 4326)

/* Geography shape/poligon */

DECLARE @g geography = geography::STMPolyFromText('MULTIPOLYGON(((-122.358...

Jeff Moden (5/25/2014)

---

Eirikur Eiriksson (5/24/2014)

---

Must say that I'm slightly puzzled. I have read my post over and over but I cannot find neither any implicit nor explicit suggestions of ignoring...

Must say that I'm slightly puzzled. I have read my post over and over but I cannot find neither any implicit nor explicit suggestions of ignoring good coding or working...

There is a wealth of technology options to help you out on this, the pitfall is to choose one before the requirements are carved in stone! A handful of million...