Well, I'd just like to say,even before I get to put these suggestions into action, that you folks are amazing, I have used dialup bulletin boards, which gives...

Plague away 😉

it contains both date and time, there is a script that churns away every 15 minutes and updates it with data from multiple servers. The...

CREATE TABLE [citrixlog] (

 [TimeGenerated] [datetime] NULL ,

 [GeneratedYear] [varchar] (255) COLLATE Finnish_Swedish_CI_AS NULL ,

 [GeneratedDay] [varchar] (255) COLLATE Finnish_Swedish_CI_AS NULL ,

 [GeneratedMon] [varchar] (255) COLLATE Finnish_Swedish_CI_AS NULL ,

 [GeneratedHour] [varchar] (255) COLLATE Finnish_Swedish_CI_AS NULL...

no the hours minutes etc are already split out.

aaaah...separate views sounds smart.....

what I was wandering if some smart case statement might work....(we'll ignore the minutes issue for now 😉

pseudo...