Hi,

if I got you right, in EM right-click on the db you want to restore -> All tasks -> Restore Database. From the following dialog choose the db you want...

Running from QA 2k on a SQL 7 db.

Never had problems with this.

Everything else is working. Changing db, changing table name. I do the workaround, for i haven't got...

quote:

---

I generally don't deal with other groups with that specific type of need. I am an island to myself altough I do...

Seems to be weired. When I use another table name it is working

Of course I can work around this, but I don't like to. There must...

Hi,

thanks for posting in advance

Maybe I haven't expressed myself precise. What I wanted to know, is if you have to deal with that kind of...

Sorry,

your last answer and my question overlapped.

Cheers,

Frank

Hi Antares686,

but what, if you were to apply this on a case where there are gaps.

Meaning calculating performance of a stock, mutual fund or so...If you have the complete history...

Some years ago I has done a similar using a char(500) to managed permissions within an application. It is definitely nothing I want to do again. But at that time...

Hi,

with a small correction in the typo

convert(decimal(10,2), sum(d.length)/1000)) as length

that should work

to display the range try a WHERE field BETWEEN <low> AND <high>

or WHERE field > <low> AND field...

oops, sorry if it has led to confusion

Cheers,

Frank

Second correction,

finally after some 15 minutes I have an result. Next time I will use a WHERE clause to SELECT only some tablenames of interest.

Cheers,

Frank

Sorry Correction,

No timeout, nut after 5 Minutes I cancelled the query...

Cheers,

Frank

Hi Greg,

I have adapted your example. It works well on that 6 records. In my table there are about 21,000 records and 177 tablenames. Running your query results in a...

Hi,

what about

SELECT TOP 1 <field_name>, COUNT(<some_field> AS tmp FROM <table_name>

GROUP BY <field_name> ORDER BY tmp DESC.

That'll only return the value which occurs most often. Leave out the TOP 1, you'll...

Could it be the same qusetion on two threads?

Cheers,

Frank