SQL Mailing List RSS Feed

strange where clause

Wed, 09 May 2012 11:28:00 GMT

PL-SQL.....Oracle....outer join ;-)

On Wed, 2012-05-09 at 10:20 -0400, Michael Dinowitz wrote:

> I'm looking at someones query and it has a where clause that looks like this:
>
> Where Person.per_id (+)= EMail_Recipient.per_id
>
> what is that
[more]

strange where clause

Wed, 09 May 2012 10:46:00 GMT

Looks a bit like the old SQL join syntax:

Select *
From table1,table2
Where field1(+) = field2

The + indicates an outer join.

Here's a link describing the two:

http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:
[more]

strange where clause

Wed, 09 May 2012 10:20:00 GMT

I'm looking at someones query and it has a where clause that looks like this:

Where Person.per_id (+)= EMail_Recipient.per_id

what is that (+)=? The MSSQL management studio dies on it.

Thanks
[more]

The Flex Authority Volume 1, Issue 2 is out now

Fri, 25 May 2012 03:19:50 GMT

If you want your Flex skills to be up-to-date then you need the Flex Authority. The current issue is all about Components: The Building Blocks of Your Applications. Order now

TS6079: ColdFusion Developers - Great Opportunity - long term Contract

Thu, 05 Apr 2012 11:59:00 GMT

TS6079: ColdFusion Developers - Great Opportunity - long term Contract

Please contact lina@tansoncorp.com for more info.

Job Title: Coldfusion Developers
Job Location: Rochester, MN
Job Duration: long term (Contract)
Pay Range: Open

Job
[more]

Combining Queries

Wed, 08 Feb 2012 04:02:00 GMT

yes, except only return one value sum(quantity), since your already returning the partnum in the main query. It's probably not the fastest way, but it might be the easiest way.
> To: sql@houseoffusion.com
> Subject: Re: Combining Queries
> Date: Wed,
[more]

Combining Queries

Wed, 08 Feb 2012 03:01:00 GMT

> Can you make it a subquery? select p.partnum, (select partnum,
> sum(quantity) as recqty......), cast(p.part........ G

I don't know any different to say yes or no. If I do this, do I simply include the additional select statement in parenthesis
[more]

Combining Queries

Wed, 08 Feb 2012 02:44:00 GMT

Can you make it a subquery? select p.partnum, (select partnum, sum(quantity) as recqty......), cast(p.part........ G
> To: sql@houseoffusion.com
> Subject: Combining Queries
> Date: Wed, 8 Feb 2012 14:00:23 -0500
> From: adgparke@iupui.edu
[more]

Combining Queries

Wed, 08 Feb 2012 02:00:00 GMT

I have a page where I need to combine four queries into one query in order to use the query to build a spreadsheet.

I have successfully combined the first three queries and obtain the desired results; however, when trying to incorporate the fourth and
[more]

MS SQL Standard vs Web Editions

Thu, 12 Jan 2012 08:29:00 GMT

Justin:

If your databases are less than 10 gig in size and will remain that way for
a while, and you don't need replication and some other enterprise features
take a look at SQL Server Express. The price is really good, free.

Ray Thompson
Tau
[more]

MS SQL Standard vs Web Editions

Wed, 11 Jan 2012 06:55:00 GMT

> Anyone have any real world experience with Web Edition compared
> to Standard to be able to comment on performance between the two?

The core engine is the same between editions, as far as I understand
it, just limited in the number of CPU cores and
[more]

MS SQL Standard vs Web Editions

Wed, 11 Jan 2012 04:37:00 GMT

I read through MS site and comparison charts. We currently have a server running MS SQL Server 2000 Standard and were going to be upgrading. Looking at the differences in pricing for 2008 Standard and Web editions the Web edition is an attractive way to
[more]

sql exists

Thu, 29 Dec 2011 03:46:00 GMT

> I'd like to use the sql exists() function but I'm not sure of it's
> performance.

The T-SQL EXISTS() function just returns true or false depending on
whether the subquery it is passed returns any rows or not, so its
performance is entirely
[more]

sql exists

Thu, 29 Dec 2011 03:29:00 GMT

I'd like to use the sql exists() function but I'm not sure of it's
performance. Every example I've seen does a select * inside the
exists(). Does it really select everything just to return 'true' or
does it just look for a row that exists with the data
[more]

NullIf and Divide By Zero

Thu, 29 Dec 2011 12:48:00 GMT

Thank you for the guidance. You suggestion and another tweak helped me get this functioning:

avg (isNull(((docunitprice * orderqty)-((c.avglaborcost + c.avgburdencost + c.avgmaterialcost + c.avgsubcontcost + c.avgmtlburcost)*d.orderqty))/ nullIf(
[more]

NullIf and Divide By Zero

Wed, 28 Dec 2011 10:24:00 GMT

> �nullIf(docunitprice * orderqty)

This where the error appears to be. The SQL NULLIF() function takes
two parameters and returns NULL if the values of the two parameters
match. In this case, I assume you want to return NULL if
(docunitprice *
[more]

NullIf and Divide By Zero

Wed, 28 Dec 2011 09:52:00 GMT

In my query, when calculating the average, I encounter a divide by zero error. I am attempting to resolve this by using Nullif, but I don't think my syntax is correct as Coldfusion throws an error stating incorrect syntax near ')'.

My query is:

<
[more]

Query Based on Query Result

Wed, 23 Nov 2011 06:21:00 GMT

Yes, it's different. It's Users.First and Users.Last, but NOT based on "WHERE Sessions.UserID IN ('UserID_1','UserID_2','UserID_3')"

It comes from the same Users table, but it's the user based on the StaffID that comes from the query results.

Rich
[more]

Query Based on Query Result

Wed, 23 Nov 2011 04:26:00 GMT

Thanks, Kristen! So I just needed that "as username" part! I was so close!

For whatever reason, the "+" symbol was not working, at least with the version of MySQL I'm using:

> (SELECT Users.First + ' ' + Users.Last FROM Users WHERE Users.ID=
[more]

Query Based on Query Result

Wed, 23 Nov 2011 08:28:00 GMT

SELECT

Users.First,
Clients.StaffID,

  (SELECT Users.First + ' ' + Users.Last
   FROM Users
   WHERE Users.ID=Clients.StaffID) as username

FROM

..and so on...

Kristen A. Winsor, PMP
Project Manager, Information
[more]

Query Based on Query Result

Wed, 23 Nov 2011 06:53:00 GMT

Hey Rich, I'm not sure I understand what you are trying to get. Is the info that you are trying to get any different than the Users.First and Users.Last as the first two fields in the SELECT clause?

Jon
________________________________________
From
[more]

The Fusion Authority Quarterly Update Volume 3, Issue 1 is out now

Fri, 25 May 2012 03:19:50 GMT

If you want your ColdFusion skills to be up-to-date then you need the Fusion Authority Quarterly Update. The current issue is all about Data and how to make it work for you. Just what we all need. Order now