puzzlezzz

[FALCONSEYE]

I have the following tbl:

FRI MON SAT SUN
9am-9pm 9am-9pm 9am-9pm 10am-6pm
THU TUE WED
9am-9pm 9am-9pm 9am-9pm

I am trying to group the similar hours together so that the output will look like :
Mon-Sat 9am-9pm
Sun 10am-6pm

kind of stuck. any help?

http://www.fuzzysiberians.com

 

[pabowen]

FalconsEye,

What is the structure of the table, it is very hard to tell from how the data is show on the screen.

Please let us know.

Thanks,
Patrick

 

[FALCONSEYE]

just two fields: dayName and hours, both of which are varchars.

http://www.fuzzysiberians.com

 

[FALCONSEYE]

sorry :

CREATE TABLE [dbo].[bTesty](
[mon] [varchar](50) NULL,
[tue] [varchar](50) NULL,
[wed] [varchar](50) NULL,
[thu] [varchar](50) NULL,
[fri] [varchar](50) NULL,
[sat] [varchar](50) NULL,
[sun] [varchar](50) NULL
) ON [PRIMARY]

GO

http://www.fuzzysiberians.com

 

[FALCONSEYE]

actually ended up doing this with some server side programming instead of sql.

http://www.fuzzysiberians.com