Shouldn't you be setting FldNumeric23764 to different values here:

UPDATE C14 SET

[FldNumeric23764]= case

when tID = 1 and Q.n <= 100 then 2

when tID = 2 and Q.n <=...

http://www.sqlservercentral.com/Forums/FindPost1620228.aspx

BWFC (9/26/2014)

---

create table #Test

(

CreatedOn datetime

,ID int identity(1,1)

)

insert into #test

select '2014-09-26 14:25:51.310' union all

select '2014-09-26 12:46:42.647' union all

select '2014-09-24 14:49:35.190' union all

select '2014-09-24 12:39:21.150' union all

select '2014-09-19 15:22:36.233' union all

select...

Looks ok to me:

-- Non-SARGable

;WITH MyTable...

;WITH Sampledata AS (

SELECT Incident = 162002982, ID = 9 UNION ALL

SELECT 162002982, 11 UNION ALL

SELECT 162002982, 11 UNION ALL

SELECT 162002982, 11 UNION ALL

SELECT 162002982, 11 UNION ALL

SELECT 162002982, 11...

hoolash (9/26/2014)

---

Hi Eirukur,

I'm afraid it's still not working for me. I'm sure I'm doing something wrong with the syntax! Grateful if you could have a look and point out...

Gosh, you made me blush :blush:

I'm guessing something like this:

SELECT t.*, x.*

FROM @TRANS t

CROSS APPLY (

SELECT TOP 1 c.D_Costing, c.M_Totl_Cost

FROM @COST c

WHERE c.I_Matl = t.I_Matl

AND c.I_Plant = t.I_Plant

AND c.D_Costing <...

What output would you like to see, Shannon?

Thanks. There are some excellent hints to make sample data generation quick and easy in this article[/url].

Thanks, but...you're looking for someone to turn this into a CREATE TABLE... plus INSERTs so they can code...

shannon.proctor (9/24/2014)

---

I have two tables where the key of one doesn't not perfectly match the primary table. I have three fields Material, Plant and Date in a Costing table....

I'm sure this has already been suggested - anyway, here it is again:

SELECT *

FROM @WorkStation

CROSS APPLY (

SELECT Thingy = CAST(

(SELECT [text()] = RIGHT('000'+Item,3)

FROM [dbo].[DelimitedSplit8K] (IPAddress,'.')

ORDER BY ItemNumber

FOR XML...

Begininator

Two main issues with the original: the date filter isn't SARGable whereas CAST(datetimecolumn AS DATE) is, and you're referencing the tally table twice. Try this. You may have to make...