replace the select statement with this SELECT colour, shape

FROM #stPatrick

WHERE shape IS NOT NULL

AND shape.STIsValid() = 1

ORDER BY CASE colour

WHEN 'd1' THEN 1

WHEN 'gold' THEN 2

WHEN 'd2' THEN 3

WHEN 'd3'...

you can run this to check colours

USE tempdb;

GO

DROP TABLE IF EXISTS #test;

CREATE TABLE #test (shape geometry, colour varchar(20));

INSERT INTO #test VALUES

(geometry::Point(0, 0, 0).STBuffer(0.5).MakeValid(), 'slot1'),

(geometry::Point(2, 0, 0).STBuffer(0.5).MakeValid(), 'slot2'),

(geometry::Point(4, 0, 0).STBuffer(0.5).MakeValid(), 'slot3'),

(geometry::Point(6,...

You  are right however, Restricting database login rights reduces the impact surface of a successful SQL injection attack but does not prevent injection itself. Prevention requires parameterized queries and safe...

You’re right, putting proper user identification and security in the database is a strong solution. Using table and row level security properly can lock things down very tightly and, in...

nice

Hi it should do

Are you sure the database is in the elastic pool, I had a issue like this and for some reason the database was not added to the elastic pool and...

fixed it I just had too many columns in the CURSOR  I removed them like so and it works now. 

CURSOR FOR
...

at the moment I get 4 emails two are correct and two are blank I thought with the delete I would only get one email per email address. 
I would...

cheers i tried to code below it still did not work however, I turned the columns into decimal and it seems fine now. Cheers again

if you can still login as yourself with sa priv then I would say just change the password and secure it in a safe location

Hi Brad,

My company is too tight to give us a blackberry so we need to rely on a call out by some one else if there is an issue. Normally...

Hi I was wondering if you have a trusted domain I have seen an issue like this where a user made a change with a trusted domain login and when...

try dropping the msdtc resource and disk and recreate it. This should solve your issue.

Courses, I don't think there are many free courses and as Steve said i would not recommended them at this stage, I would as your DBA at work if you...