FYI

just an update:

I did use the statement, minus the ID filter, in my data warehouse and it failed during the creation of a named query.

What's interesting is that it...

that's a very good point and I am glad that you brought that up.

you see, I have a

> data warehouse

> there is another table joining this table / dataset

therefore,...

how about the statement in below.. I did get some assistance on this paragraph. .Now, I have to find out how to use this in a table-value function.

thx for the...

I have looked at that too, but, I have so many fields in this record structure and also there are couple of memo / text fields. So, I am not...

wow.. it looks like I have lots of work to do.. if you will excuse me..

:))

excellent tip and I am on my way back to the classroom..

thx

thank you for the reply.

yes, this absolutely works great.

I was just wondering about the COMPUTE method and if there was a way not to show the PART ONE of the...

I have

select

200-len(tmessage) wastedspace

from mytable

compute sum(200-len(tmessage))

I hope this is clear..

thx

Trye DBDesc at http://www.dbdesc.com/purchase.html?dbdesc

I have my own scripts for MSSQL however there are couple of other flavors of DBs such as FireBird that I did not want...

By the way here is an URL to FireBird site that I was playing around with:

I have already downloaded the driver(s) for the 1.5 version and still get error connecting...

good morning and welcome to sql server central.. you are going to have lots of fun here.

..

and thank you for the reply..

I did find out why this is not going to work.

The EXEC is qualified as an outside scope and therefore the temp table is not visible any longer.

Therefore, I have...

so there is no way of executing a stored procedure on a linked server, is that what I am reading?

any suggestions?

here is some form of a question that I have posted on the Advantage.xyz newsgroups and of course I have not received any information 🙁

-------------------------

what is the TSQL command to...

I am not sure if the link in below is 100 percent relevant to your situation, but, I just found it and I was about to read it.

http://support.microsoft.com/kb/929376

Even if it...

Very interesting and must to know piece of information.

Today, Saturday, has been well spent so far..

nice

😀