Re: query help



 (a@xxxxx) writes:
> now we enter the realm of "horse-shit". i provided a description of the
> tables, just not a create table script. not only that, but i also provided
> sample data *and* sample output from the query *i* provided -

Yeah, you did. But you still did not manage did to explain the problem.

Believe it or not, when we suggest that you should post CREATE TABLE
and all that, it is to help you. And, to some extent a little test:
how much effort are you prepare to lay down yourself.

>| You see, it's not that I'm paid to do this or anything.
>
> cry me a river. i'm a "non-paid" contributer to 3 other newsgroups in
> which, my technical prowess is appreciated and respected...

Maybe you are. That does however not mean that people here have any
particular reason to spend their free time to guess what you are up to.

And, of course, the attitude you have shown in no way encourages people
to help you.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

.



Relevant Pages

  • Re: Scripting Databases
    ... Basically, if I want to script a number of tables, I can right hand ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: DDL Trigger To Track Schema Changes
    ... see whats wrong with the following script. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Linked Server in SQL Server 2000 Evaluation Version
    ... As it complaint about MSDAORA, I installed the latest MDAC 2.8. ... This is the script which I run to create linked server and id: ... I have another SQL Server and it is working fine with the above ... "Erland Sommarskog" wrote: ...
    (microsoft.public.data.oledb)
  • Re: SQL2k vs sql2005 performance
    ... Yeah, as I said "if". ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.server)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)