Make a time frame in T-SQL

Hello

I'm trying to achieve the following in a more clean and dynamically way using a loop or something like that:

print'00:00 00:30 01:00 01:30'

print' |..............................|..............................|..............................|'

The idea is to make a time bar from 00:00 to 23:59.

I'm not sure it can be done with T-SQL...

Has anyone done something like this before?

Thanks!

Worf

The better question is Why try to do this with T-SQL when there are so many BETTER tools for printing.

That really is something you should do in a client application -one that is designed for work with printing.

SQL Server is not designed for printing

|||

I was afraid for an answer like that and I totally agree with you

I'm trying to make a script that gives me an overview of overlapping jobs in SQL Server.
I thought of making it in Reporting Services but what I need is a quick script.

There are two ways:

1. Make something visual and decide for yourself which jobs are overlapping

2. Make the script descide which jobs are overlapping but that might be more complex to visualize it

But thanks anyway

Worf

|||Output your Job Schedule data into Excel or VISIO, or any product that can create something that looks like a PERT chart.