same windows and sql server hot fixes?

I guess this could be affected by something like fragmentation or location of files or buffer space available/what is already cached.

Think I'm saying I...

Does it need a format fie?

try -t|

to specify the field terminator.

Obvious.

The setup has invoked something and that has returned an error.

Don't think it needs flowers but you could try yellow ones next to the server :).

I take it nothing useful...

have a look at cross apply.

You can call a function for each row of a resultset and return a resultset.

Not sure that's what you want to do but sounds something...

There are a number of ways but I would go with bcp if possible.

If needed it will take a querry as input and if necessary you can format the row...

In management studion right click on the server (need to add the analysis services server if not already there) properties, security.

The main issue is finding last fridays data - you could use datepart(dw - but that will depend on the settings.

Safer is to count back

Also do you mean the previous...

just add the two dates to the resultset - means adding two dates to every row though. Could also include a new datasource which just has those dates - that's...

Exclude it fom the dataset?

The clustered index columns will be added as included rather than indexed.

If it's needed then I would include it explicitely.

If it's not needed and just there by default then I...

If you need to log the status for each row then you are stuck with a single row insert so there's not much you can do about it.

If you could...

If you held the start and end dates for reservations the query would become

SELECT h.*

FROM tbl_house H

WHERE

NOT EXISTS (SELECT r.house_id FROM tbl_reservation r where r.house_id = h.house_id

AND

r.julianStartDay <= dbo.udf_dateToJulian('2010-11-04')

and

r.julianEndDay...

It will have to create a work table which it will use to get the distinct rows.

Do you need all columns to be distinct or can you get the primary...

Some time ago a similar question turned up a number of times about a hospital bed allocation system. Turned out to be a course project.

Looked at the OPs posting history...

I spent a couple of years in at a company working ridiculous hours - for the last 3 months I was IT manager (+ two other jobs that I couldn't...