Does this help?

DECLARE @TestTable TABLE (

TestTableID int IDENTITY(1,1),

TestValue varchar(30)

);

INSERT INTO @TestTable(TestValue)

VALUES ('fresh chives'),('MIRACLE WHIP');

SELECT * FROM @TestTable;

SELECT * FROM @TestTable WHERE TestValue...

I can do everything your code is doing without using DATEFROMPRARTS:

declare @Date_received date = '2013-02-23';

select

@Date_received,

dateadd(dd, -1, dateadd(wk, datediff(wk, cast('1900-01-01' as date), @Date_received),...

Champagne Charly (2/23/2013)

---

Hello,

Has any idea why this is classed as non deterministic.

DATEFROMPARTS(DatePart(yyyy,DATEADD(dd, (DATEPART(dw, Date_received) - 1) * - 1, Date_received)),DatePart(mm,DATEADD(dd, (DATEPART(dw, Date_received) - 1) * - 1, Date_received)),DatePart(dd,DATEADD(dd, (DATEPART(dw,...

Paul White (2/23/2013)

---

That's fine, I'm not posting to...

Unless you have configured your named instances to use specific ports, the port numbers assigned will (can, may) change each time the named instance is restarted. The SQL Browser...

I don't know about any of you but this is just down right scary.

Now please, no piling on here.

Paul White (2/23/2013)

---

Lynn Pettis (2/22/2013)

---

As to ordering by a uniqueidentifier, it sorts in ascending or descending order as if it is converted to a CHAR(36) value, or at least that...

I'm not even sure what you are trying to accomplish. Plus, what is the other function doing? There really isn't enough information to really provide much help.

You may...

Cool. Learned something...

I haven't tried, but are you sure you can convert a uniqueidentifier to a bigint?

As to ordering by a uniqueidentifier, it sorts in ascending or descending order as if it...

I let SSMS generate the script to run a stored proc, and I get this:

DECLARE @rc int

DECLARE @DDVersion varchar(20)

-- TODO: Set parameter values here.

EXECUTE @rc = [cidne2110].[dbo].[spDDAddFixAll]

...

Please post the DDL for the table(s) including index definitions. Also, please post the actual execution plan for both of the queries. These can be saved as .sqlplan...

Would not be surprised if this was a port from...

These are invalid dates for US English settings.

Can you show us some of the data that is failing?