Thanks for good question.

There was a connect item to change this behavior of join hints

https://connect.microsoft.com/SQLServer/feedback/details/753790/allow-join-hints-without-force-order

This is really not so hard, but a single query i can imagine excludes using indices on date columns. Nevertheless it should be faster then cursor. And 1+ million of...

prameela.vankineni (1/12/2016)

---

I am using min and max day_id's in another query as below, where I would like to show "Year" and "Month" values in select condition.

select

@year as [YEAR],

@MONTH...

Try this

declare @currentdate datetime = '20150308' -- getdate() --

select tc.*

from (

select y = datepart(YYYY,dateadd(m,-1,@currentdate))

, m = datepart(m,dateadd(m,-1,@currentdate))

) params

join temp_calendar tc

on [month_id] between y*100+1 and y*100+m

;

d is missing. Just in this case both tables need to be taken into account.

And i should say first...

Generally, MS SQL has recursive CTE for trees processing. This particular tree has exactly 2 levels which allows for simple solution.

declare @test-2 table (ParentId varchar(10), ChildId varchar(10));

declare

I'm not sure about what output is desired. Anyway 2014 has LED/LAG. So most probably you needn't ROW_NUMBERing CTEs here at all.

Check this link

http://williams.best.vwh.net/avform.htm#Intermediate

This is really not an SQL problem. You need some geodesic mathematics for it which SQL Spatial doesn't provide out of the box. Generally it depends on what model of...

According to OP statement

martyn.dowsett (12/15/2015)

---

the complexity is that while a manager can have 1 or many personal assistants, a personal assistant can work for multiple managers and may have...

Let input be as follows

INSERT#MgtStructure (ManagerID, EmployeeID) VALUES

--('A', 'B'),

('A', 'C'),

('A', 'D'),

('B', 'C'),

('D', 'E'),

('F', 'G'),

('F', 'K'),

('H', 'I'),

('H', 'J')

--,('H', 'A')

Which is correct group for C ?

As OP stated, it's not a...

To add a bit more fun, what if

DECLARE @url VARCHAR(8000) = 'http://www.mydomain.info/Customer.aspx?xxh_hmid=45678&h_hmid=2907831&dcc=EUR&mobiredirect=no&cpn=3790';

You need a criteria to choose which row must show closing balance. Isn't DATE column missing?

In fact this boils down to something like

WHERE...

CashDate = dateadd(d, case when <entity> then -DelayDays else "N days" end, currdate)

Check signs, not tested.

Depending on indexes available you...

Generally, create a set of keys (year +month i suppose) to collect data about and left join data collection query to this set.