Avraham de-Haan (10/23/2007)

---

select HexName=convert(varbinary,name), name from master.dbo.sysdatabases order by name

HexName ...

What output do you get when you run this query?

[font="Courier New"]select HexName=convert(varbinary,name), name from master.dbo.sysdatabases order by name[/font]

select

Avg_time =

avg(convert(numeric(10,8),round(datediff(ms,dateadd(dd,datediff(dd,0,a.DT),0),a.DT)/3600000.0000,8)))

from

MyTable a

where

Col_a in ('a', 'b', 'c', 'd')

Marcus Farrugia (10/18/2007)

---

Thanks everyone for your replies,

Matt your reply was the one I went with that ended up working great.

ALZBA I wasn't sure how to apply your solution, because I'm...

I think this does what you want.

select

TIME_NUMERIC,

-- Convert from number back to datetime on day 1900-01-01

BACK_TO_TIME = dateadd(ms,TIME_NUMERIC*3600000.0000,0),

DT

from

(

select

TIME_NUMERIC =

-- Extracts time only from date and converts it to numeric

convert(numeric(10,8),round(datediff(ms,dateadd(dd,datediff(dd,0,DT),0),DT)/3600000.0000,8)),

DT

from

(

-- Test...

There are many good reasons to have a date dimension table, so you might as well have one.

The following should give you a good start on creating a date dimension...

JonJon (10/10/2007)

---

Is there anywhere I can get a SP to create a dates table.

It needs to include

Day, Month, Year, Fiscal Day, Fiscal Month, Fiscal Year, Week Number and Day...

I think this would be much simpler:

[font="Courier New"]Declare@RequestID int,

@ErrorMessage varchar(250),

@SubstitutionProcedureName varchar(250),

@SQLString nvarchar(500),

@ParmDefinition nvarchar(500),

@DynErrorMessage varchar(250),

@RowCount int

execute @SubstitutionProcedureName

@RequestID = @RequestID, @ElementID = @UnDelimitedValue, @RowCount= @RowCount OUTPUT, @ErrorMessage = @ErrorMessage OUTPUT[/font]

Why do you want to use sp_executesql to execute the procedure?

If you really feel the need to build a new database everyday, it would be simpler to just drop the old database when the load is done, and rename the...

This works well for me

1. Set delivery date

2. Do some programming

3. Test

4. If test is good, go live, else go live

5. Define requirements

6. Repeat 1 through 5 until system is...

Carl Federl (10/4/2007)

---

Q: How many Oracle DBAs does it take to change a light bulb ?

A: Three - it takes three Oracle DBAs to do anything.

Q: How many SQL Server...

Does Idera's compliance manager allow you to log someone who just connected to a database or just selected data without changing anything?

Just a couple of questions:

How do I find my own posts? (Hope I can find this one later if someone answers this question)

Did the vendor forums go away?

I have been looking into this myself.

I was reading the info on Lumigent Audit DB. The marketing info claims it does job, but I was trying to find if...