Don't take unnecessary shortcuts when writing queries. Keep them clear and simple.

You seem to be trying to create a query that would allow to search on every column, instead of...

I pointed to that article because if you share the details mentioned in there, it would give us an idea of what's happening. Without details, we're just guessing.

On the index...

Can you share your solution?

I didn't use a cross join, I used a cross apply which is different.

Index seeks are not always the best option, especially when they're accompanied by a key lookup. Sometimes, an index scan is better when a wide range of rows is selected.

Please...

Maybe this could help.

CREATE TABLE Customers( id int, Point Geography);

INSERT INTO Customers

SELECT 1, geography::STGeomFromText('POINT(-122.34900 47.65100)', 4326);

CREATE TABLE Stores( id int, Point Geography);

INSERT INTO Stores

SELECT 1, geography::STGeomFromText('POINT(-125.34900 47.65100)', 4326) UNION ALL

SELECT...

Lynn Pettis (9/1/2016)

---

ScottPletcher (9/1/2016)

---

Luis Cazares (9/1/2016)

---

Second, cursors can be local or global and...

Lynn Pettis (9/1/2016)

---

djj (9/1/2016)

---

Sean Lange (9/1/2016)

---

Odd...I can't...

Here's an option, you need to complete the last column.

UPDATE A

SET ACTION1= CASE WHEN A.ACTION1 IS NULL THEN B.ACTION ELSE A.ACTION1 END,

ACTION2= CASE WHEN A.ACTION1 IS...

This smells like RBAR. That would certainly be slow.

If you post DDL for your table and indexes, along with the UPDATE process we could give better advice on what to...

Maybe this can give you an idea.

CREATE TABLE Test( id int);

DECLARE @SQL NVARCHAR(1000) = 'DROP TABLE Test;';

EXEC( 'SET NOEXEC ON; ' + @SQL);

SELECT * FROM Test;

DROP TABLE Test;

EDIT: Changed PARSEONLY...

Why do you want to create a column with unique values to create a unique index on it? What do you expect to achieve?

Second, cursors can be local or global and the default is defined by...

Iwas Bornready (9/1/2016)

---

Derek Slinn (9/1/2016)

---

I think the answer is wrong,

Both are stored in tempdb database.

technically table variables can just be in memory if there is only a small amount of...

You should pay attention to what Drew is saying. Right now, the business rules might say that you'll only have 3 actions on each item, but later, you'll be able...

You don't, you use 24 hours.

So, these are AM:

'2016-08-30 08:00:00.000'

'2016-08-30 11:59:59.997'

And these are PM:

'2016-08-30 20:00:00.000'

'2016-08-30 23:59:59.997'

Also, you need to take in account that seconds will always be zero(:00) for smalldatetime...