Thanks Jeff 🙂

I guess you could 'pad' that first number before you do your comparisons...

declare @t table (warehouse int, [From] varchar(10), [To] varchar(10))

insert @t

...

What output would you want for the example you gave?

Cross post

http://www.sqlservercentral.com/Forums/Topic498623-147-1.aspx

Perhaps you're trying to do this?

Select

CASE

WHEN Col1 = 'Y' THEN 'Col1'

WHEN Col2 = 'Y' THEN 'Col2'

WHEN Col3...

If you add an index (clustered or not) to #sparseData...

create clustered index ix_sd1 on #sparseData (dateId)

...the cross apply has the best performance for the small dataset you give (at least...

Another option:

select * from #drivingTable a cross apply

(select top 1 * from #sparseData where dateId <= a.dateid order by dateId desc) b

I love it! 😀

Perhaps you should change the title to walking down the tree 😀

If I've understood you correctly, here's one idea...

; with

a as (select *, case when charindex('.', Proj_ID) > 0 then left(Proj_ID, len(Proj_ID) - charindex('.', reverse(Proj_ID))) end as...

srienstr (5/9/2008)

---

I'm trying, but can't figure out how to apply this to cleaning user input. I have a file I get monthly with member information that has some rows...

The point was that you've referred to it in your rules, but it's not in your structure (at least not in...

Well, here's one idea of the type of thing you could do...

-- Structure and Data

CREATE TABLE [dbo].[AlDate](

[EMPL_ID] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

...

What's ts_dt?

Looks like another use for the 'tally' table...

http://www.sqlservercentral.com/articles/TSQL/62867/