KoldCoffee (11/22/2014)

---

Serg, I am fine with the lowered accuracy given I am not querying for locations at either north or south pole but I can't get that sample query to...

Try

----Sample data

-- timeclock machines log

declare @TIME_LOG table (SNO int, nUserID int, readerid nvarchar(20), dtdatetime Datetime);

insert @TIME_LOG

select 113645, 320417,'in_a', '2014-11-2 8:21:00'

union select 113648, 320417,'out_b', '2014-11-2 9:21:00'

union select 113649, 320417,'in_a',...

ChrisM@Work (11/21/2014)

---

This doesn’t run:

...

FROM

Table1 AS a

LEFT JOIN Table1 AS b

ON b.ID = a.ID

CROSS APPLY a.data.nodes('.../Node1') AS T1(F) -- part 1

CROSS APPLY a.data.nodes('.../Node2') AS T2(F) -- part 2

And fails with...

btio_3000 (11/20/2014)

---

so what I am trying to make sure of is that in this code is the logical order always as if it was written like you pointed in one...

tamer.h (11/20/2014)

---

first, thank you very much for your reply.:-)

sorry i didn't understand what do you mean by:

"Not certain on 'L' ,'0' logic.

For a given month"

and would you please explain what...

Sean Lange (11/20/2014)

---

You posted code that contained a function ufn_Tally2 but you didn't post it. Do you really have a function that creates a tally table on the fly?...

KoldCoffee (11/20/2014)

---

eirikur, the query you provided is good. Not sure it performs faster in myenvironment tho. Once query execution plan is cached it's about same, but it is still better...

🙂

Being precise really cann't be bad thing.

Not certain on 'L' ,'0' logic.

For a given month

declare @TIME_LOG table (SNO int, nUserID int, dtdatetime Datetime)

insert @TIME_LOG

select 113645, 320417, '2014-11-2 8:21:00'

union select 113648, 320417, '2014-11-2 9:21:00'

union select...

Looks like JOIN .. ON introduces parenthesis

SELECT

CASE WHEN F1.value('...') IS NOT NULL THEN F1.value('...')

ELSE F2.value('...') END

FROM

...

You may wish to add

and geo.latitude between lll.lead_lat + 250*1610/110.0 and lll.lead_lat - 250*1610/110.0

see

http://en.wikipedia.org/wiki/Latitude#Length_of_a_degree_of_latitude

and create index on geo.latitude.

+1

And...

Thanks, good question.

I was not sure but rather had an impression that sending parameter of the UDT declared in the current DB to the proc in the other DB must...

To calculate total cost of conponents for the item (not including cost of the item itself) try

- test data

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[ItemCost](

[ItemNo] [varchar](15)...

OK. Can that two rows contain 3 distinct codes and dates, i.e.

1 CID 01/03/2015 AH 01/25/2015

1 CIE 01/01/2015 NULL NULL

?