Re: someone help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Mon, 13 Jun 2005 07:50:05 -0700, Sujay wrote:

>For ORG_ID: I have the query below.. can anyone help me with it.. this is the
>first time I am creating SPs.. thanks in advance
(snip)

Hi Sujay,

I've read your post three times now, but I still have no idea what
you're trying to do. The way you describe your problem is merely
confusing me. You describe your query as if you were writing a Cobol
program, using consecutive steps to get to the result for one row, and
repetaing this for all rows. That's not how SQL works.

Since the description didn't help, I then tried to figure out what
you're doing in the query you posted. Without any luck, as you
repeatedly use illegal SQL constructions such as "a = b IN (...)"; not
only is that invalid SQL, it also doesn't make any sense to me as
pseudo-code.

The best way to get help on SQL related problems is to include the
following in your post:

1. The structure of all tables that are relevant to your problem, posted
as CREATE TABLE statements. Do include all constraints, properties and
indexes. Irrelevant columns may be omitted.

2. A few well-chosen rows of sample data, posted as INSERT statements.
Try to make the sample data as unambiguous as possible, in as few rows
as possible. Ten to twenty rows per table is typically a good size,
though more or less may be needed for more or less complex problems.

3. The required output, based on the sample data you provided.

4. An explanation of the business problem you;re trying to solve, in
layman's terms.

Check out this page as well: www.aspfaq.com/5006.

If you repost your problem, following the guidelines above, then I'm
sure that someone will be able to help you.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.

Relevant Pages

  • Re: someone help
    ... "Hugo Kornelis" wrote: ... >>first time I am creating SPs.. ... That's not how SQL works. ... A few well-chosen rows of sample data, ...
    (microsoft.public.sqlserver.clients)
  • Re: How to query a field for Absolute Value in Access 2007
    ... I tried this by creating a Make Table Query and used the Expression ... visual basic or SQL language expert by any means. ... It helps to see a few rows of sample data, ... Please reply to the newsgroup. ...
    (microsoft.public.access.queries)
  • Re: Run Query from Form
    ... Here is what my sql reads as requested. ... working even the first time that i push the button) but my code of the ... > Try switching to the SQL view and post your SQL statement of your query. ... > Jeff wrote: ...
    (microsoft.public.access.queries)
  • Re: Transform Access SQL to SQL server 2005 or SQLExpress
    ... i have already resolve the problem creating a new view in sql with the worst score and the number of records taht point to each record of the original query. ... In older versions of SQL Server, using that would help you get around the restriction against using ORDER BY in subqueries. ... Perhaps if you showed a few rows of sample data followed by the result you wish to achieve with this query, I could be of more help. ... This email account is my spam trap so I ...
    (microsoft.public.access.queries)
  • Re: How to make the SQL to run longer?
    ... To reproduce one of our cusotmer's probem, I need to make the SQL to ... If you just need a query, any query, that will run for more than a minute so that your app can hang, then you can easily create one. ... Then add the query to your reporting app. ... By the way...this is the first time I've ever heard of someone asking to make things take longer! ...
    (comp.databases.oracle.server)