but don't quote me - i had a beer at lunchtime, so look up datediff in books on line for hte exact syntax

hic

create procedure sp_tetsproc

as

select datediff(d,dateofinterest,'01/01/1970 03:00')*24*60*60*1000 from mytable

go

this would give you the number of milliseconds between 1/1/1970 03:00 and the field you requested

if the servers are on the same service pack version then there will be no difference between them.

even if they're on different versions then i don't think there will...

could i ask why you're moving the model? it's only the template for new databases.

it might be easier to just to a DTS transfer of all the "additional" objects you...

apologies - marshall is correct about click events - as i said i was away from my workstation so couldn't check

you might be better shifting to reporting services which will...

try the following

In SQL Server Enterprise Manager, right-click the server name, and then click Properties.

2. On the General tab, click Startup Parameters.

3. Add a new parameter as...

I think you're going to struggle as most tests of this nature are multiple choice (like the MCDBA ones)

the tests themselves show that you can write syntatically correct SQL such...

I'm guessing from what you're saying here you're talking about "drill down" reporting which might be a better term to search for.

if you're using msaccess to provide reports against an...

I'm guessing from what you're saying here you're talking about "drill down" reporting which might be a better term to search for.

if you're using msaccess to provide reports against an...

using the outer join with a y.id is not null will do more work than the 2nd query as you will have to do an index seek or table scan...

Nash,

I don't think that performance is really the maint point of ahaving outer and inner joins.

they both return different sets of data. An outer join will almost always...

I've been using crystal back from version 7 and while the product is now so much better it's also far too expensive

SQL server 2005 reporting services is actually pretty good...

if i could suggest something-

can you run the command DBCC SQLPERF(LOGSPACE) and paste the results back

if you need to claim space back it might be wise to claim it...

What is the diference between unallocated space and unused space

not sure if this is entirely accurate but here goes - unused is allocated space that has not been used...

i think you might have few problems doing it this way

1) the value you return from the child procedure is retuned as an output variable so you need to...