Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 10 of 10
Search took 0.01 seconds.
Search: Posts Made By: cummicon
Forum: SQL Language May 18th, 2004, 08:56 AM
Replies: 2
Views: 852
Posted By cummicon
select * from TABLE where name not in ...

select * from TABLE
where name not in
(select name,count(*)
from TABLE
group by name
having count(*) = 1)
order by name
Forum: SQL Language April 29th, 2004, 06:25 AM
Replies: 5
Views: 2,197
Posted By cummicon
Try this it should work SELECT Code, ...

Try this it should work

SELECT Code,
Date(M.D),
SUM(Weight),
CASE WHEN Date(M.D) BETWEEN '2004-06-01' AND '2004-06-31'
THEN SUM(Weight)
ELSE 0
END
FROM TableName
Forum: SQL Language April 29th, 2004, 05:14 AM
Replies: 3
Views: 5,489
Posted By cummicon
Use a temporary table to hold the results of the...

Use a temporary table to hold the results of the initial query, something like

SELECT TheForiegnKey, COUNT(*) AS Expr1
INTO #temptable
FROM (SELECT DISTINCT ForiegnKey, [_Group_]
FROM ...
Forum: SQL Language April 28th, 2004, 05:29 AM
Replies: 3
Views: 5,489
Posted By cummicon
This will give the foreign key and the number of...

This will give the foreign key and the number of distinct groups for that key where there is more than 2 distincy groups for that key

SELECT TheForiegnKey, COUNT(*) AS Expr1
FROM ...
Forum: SQL Language April 28th, 2004, 05:10 AM
Replies: 3
Views: 967
Posted By cummicon
SELECT Identifier, Date, Description1 FROM ...

SELECT Identifier, Date, Description1
FROM (SELECT Identifier, Date, VariousDescription AS Description1
FROM Table2
UNION
SELECT Identifier, Date, ActualDescription AS...
Forum: SQL Language April 23rd, 2004, 10:54 AM
Replies: 1
Views: 1,027
Posted By cummicon
I've looked at this for a few minutes but I can't...

I've looked at this for a few minutes but I can't answer it because I can't figure out what determines when to create a new Purchase order.
Forum: SQL Language April 23rd, 2004, 05:20 AM
Replies: 2
Views: 2,641
Posted By cummicon
Select a.Name , b.Name , c.Name From table a,...

Select a.Name , b.Name , c.Name
From table a, table b , table c
Where a.ida = b.fk_ida
AND b.ida = c.fk_ida
Forum: SQL Language April 22nd, 2004, 12:01 PM
Replies: 3
Views: 967
Posted By cummicon
Need more detail, you've got 2 excel tables but...

Need more detail, you've got 2 excel tables but where are you trying to link them and how.

With-in excel ?
Using SQL throught some odbc driver ?
Using recordsets in VB ?
Are both table in the...
Forum: SQL Language April 22nd, 2004, 11:49 AM
Replies: 2
Views: 1,022
Posted By cummicon
insert into NEWTABLE select distinct...

insert into NEWTABLE
select distinct '','','',NUMBER
from ORIGINALTABLE

Update NEWTABLE
SET N.A = O.A
FROM NEWTABLE N,ORIGINALTABLE O
WHERE O.NUMBER = N.NUMBER
AND O.A <> '' AND...
Forum: Crystal Reports April 22nd, 2004, 11:39 AM
Replies: 0
Views: 609
Posted By cummicon
Drilll Through Reports

Is there any way to jump from report to report using hyperlinks and pass parameters. I know I can do an on-demand sub-report as a hyperlink and pass parameters but I want to add another sub-report to...
Showing results 1 to 10 of 10

 


All times are GMT -4. The time now is 07:21 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.