You can create a static table for time slot as follow

This works in SQL 2008

create table #StaticTable(TimeSlot time)

insert into #StaticTable

select '00:00:00'

Union ALL

select '00:30:00'

Union ALL

select '01:00:00'

Union ALL

select '01:30:00'

Union ALL

select '02:00:00'

Union ALL

select...

Create a static table with all time slots and do LEFT JOIN

I would use any system table that has more than 100 rows

With Top100 (SrNo)

AS

(select top 100 ROW_NUMBER() over(order by Name) SrNo from sys.all_columns)

Select SrNo from Top100

Daxesh

SSC Rookie

This worked for me

Thanks

small correction to SSC Eights's script. Adding "use ?"

exec sp_msforeachdb 'use ? select ''?'', create_date FROM sys.objects where name = ''sysrowsets'''

This should give you create date for each database.

You can start with installation of "SQL Server 2005 Performance Dashboard Reports" download from following link.

http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

You can go through all the reports and ofcourse to understand the problem...

Hi,

A possible reason for your problem is, transferring text from unicode to non-unicode columns or vice-versa.

Just check the data types in source/destination columns.