Thanks Jonathan! Again two new ones I like this flowery language!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Not sure if I understand this, but would a look in BOL for 'ROLLUP' help.

Anyway, if you use Access as front end, why not take advantage of the grouping functionality...

Wow, how exciting....Top secret!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sometimes it pays to be tenacious ?!?

Somehow it seems to work only with SQL Server authentication only, not with Windows. Anyway, it's working now. Thanks to you all!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Lots of good suggestions which I can unfortunately first try in the evening from home.

...but if it doesn't work I'll come back anyway

Thanks for now.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I asked our DBA what could be the cause and he said he has no problems to connect, but it might be an issue with my 'firewall profile' and that...

Help Mark!

How do I get out of telnet.

It seems to work and now I have a blank screen and no clue what to do??

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Edited by - Frank kalis on 12/08/2003...

I'm connecting via name.

Interestingly my production server seems to be the only one missing in the list of active servers in the network?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

... tricky with the NDA.

---

please talk slowly to me!

What is NDA?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

http://www.insidesql.de/scripts/sqlserverfaq.php?id=33

When looking at the execution plan of each, Jonathan's solution is efficient.

For the sake of 'completeness' you can also use this

SELECT 

table_schema, table_name 

FROM 

information_schema.columns

WHERE

column_name...

Well, I can connect to several other (test)servers on the network. That works without further configuration. I guess I have to talk to the network admin tomorrow.

Thanks anyway!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, conversion to int would be so simple...

But it depends on what degree of accuracy you need.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sorry for editing...

The wine has now begun to show its effect...

I log off now...

Yes to both questions!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I first read it in the Best of... book, reread it now, and think it is undervalued and has not had the audience yet it deserves!!!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I am not sure if I understand you.

Binary data in its most simplified form is simply a chain of 0s and 1s arranged in a certain manner. SQL Server does...