It's as the error message indicates.

SELECT failed because the following SET options have incorrect settings: 'ANSI_WARNINGS'.

Verify that SET options are correct for use with indexed views and/or indexes...

Well, if...

The deadlock would be reproducible if you had all the queries run by the sessions involved in the deadlock.

The trick is that the execution stack and input buffer portions of...

The question itself even says from 2003, so... 🙂

Most likely the RangeS-U locks are on different ranges, with one coming from a previous statement in the transaction.

The fact that the non-Serializable transaction is trying to take a RangeI-N...

Missing your closing parenthesis for the COALESCE.

Cheers!

I'd use COALESCE.

CREATE TABLE #temp (date1 date, date2 date, date3 date);

INSERT INTO #temp VALUES

('20150101', NULL,'20150203'),

(NULL,'20160401','20120303'),

(NULL,NULL,'20110101');

SELECT COALESCE(date1,date2,date3) FROM #temp;

First, is it possible for all 3 columns to have NULL values?...

Nice job providing sample DDL and data!

Having said that, it doesn't look like the sample data matches your expected results. In your expected results there is an 'Equipment 6' that...

In addition to Gail's fine points, the key difference between the two is that for one you materialize the result of the UNION query, which means that query only gets...

If you don't want to use temporary objects and/or change how the values in the criteria are passed, then you'll need to split the string with the splitter of your...

sks_989 (4/5/2016)

---

I am getting error while i run query. Client id is numeric 18,0 when i run with parameter with ALL it is working, It is in statement

DECLARE @clientid varchar(20)...

I think this is what you're looking for, but I had to make some assumptions:

SELECT loadORdelivery='D', --Not sure what the point of returning a constant 'D' here is?

...

Resources labeled MD are for metadata. I've seen blocking around those before, but not with that INVALID (INVALID) description.

Exactly what code were you running that returned that description for the...

This seems to do what you want:

DECLARE @dt datetime;

SET @dt='20160331 14:38:25';

SELECT date_from=DATEADD(mi,(((DATEDIFF(mi,0,@dt)/30)-2)*30),0),

date_to= DATEADD(ss,-1,DATEADD(mi,(((DATEDIFF(mi,0,@dt)/30)-1)*30),0));

SET @dt='20160401 12:02:25';

SELECT date_from=DATEADD(mi,(((DATEDIFF(mi,0,@dt)/30)-2)*30),0),

...

In that case you could just use nested REPLACEs.

Alternatively, you could use CROSS APPLY to do the successive replace operations.

I like that way because it's a bit easier for me...