ansaryarshad | SQLServerCentral

ansaryarshad

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

RE: Nearest Date value

ChrisM@Work - Tuesday, October 31, 2017 2:50 AM
This is a bogstandard SQL version of the APPLY query I posted above. One of...

October 31, 2017 at 5:25 am

#1965933
RE: Nearest Date value

drew.allen - Monday, October 30, 2017 2:26 PM
pietlinden - Monday, October 30, 2017 11:07 AM

October 31, 2017 at 2:29 am

#1965911
RE: Nearest Date value

pietlinden - Monday, October 30, 2017 11:07 AM
here's one solution using LAG. Requires SQL Server 2012 and later.
use tempdb;
go
create table...

October 31, 2017 at 2:25 am

#1965910
RE: Hierarchy without cursor/loop

Hi Thom,
Sorry for the reply.
I am coming from an SAP HANA background where CTEs are still evolving . We dont have the option of doing recursive CTE...

March 22, 2017 at 3:52 am

#1934265
RE: Hierarchy without cursor/loop

Hi Thom,
Thanks for the post . But the condtion

E.MgrID = H.EmpID
will not work for Node C as its Parent Node is B...

March 20, 2017 at 12:01 pm

#1934061
RE: Dynamic Aggregate functions in SELECT

Thanks for the answers ..
BR
Arshad

March 20, 2017 at 10:07 am

#1934030

Viewing 6 posts - 1 through 6 (of 6 total)