When other solutions are loopy, you can always count on numbers

(sorry )

And here's the kind of logic you can use in your trigger/sp/whatever...

--data

declare @t table (Name varchar(10), DateFrom datetime, DateTo...

Did I hear my name?

It looks to me (though I could be wrong) like that link isn't quite what you're looking for because...

Hi Neetu,

You can use 'with rollup'...

--data

declare @t table (Yr int, Branch int, TRec int)

insert @t

          select 2004, 1, 1000

union...

For the pedants, you could use

MyDateCol >= '2006-03-26' and MyDateCol < '2006-03-27'  (note <, not <=)

You calling me a pedant?

It is possible - just not a good idea.

Hoa,

How's this...?

--data

declare @t table (Col1 int, Col2 varchar(100))

insert @t

          select 917, '2294,2294,2294,2294'

union all select 918, '2294,2294,2294'

union all select 920,...

Yuri?

There's what we needed! Col2 can have different values in its list, and you've shown what you'd want to do with them. Now, on with the solution...

Is there some reason why you can't just use cast? See example below...

--data

declare @t table ([Account number] char(10))

insert @t

          select '00004'

union all select '0010'

union all select...

I know this isn't what you're asking for, but here's a solution which works for your example. Now, can you give us an example which breaks this solution? That will make...

No worries Daryl. Always fun to play with intellectual questions

I was particularly proud of the confusing nature of one of the statements in...

Steve - wouldn't you want to sort out that non-normalised data structure before you spent ages writing a stored procedure based on it?  (As I mentioned above...

Hear, hear!

That doesn't answer the question he was asking, Amit.