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 | Calendar | 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 7 of 7
Search took 0.01 seconds.
Search: Posts Made By: jcarswelljr
Forum: BOOK: Expert SQL Server 2005 Integration Services ISBN: 978-0-470-13411-5 March 20th, 2009, 03:05 PM
Replies: 0
Views: 1,976
Posted By jcarswelljr
retrieving all records

i want to retrieve all records regardless if they were associated with an office or had person_id in the other 7 tables what do i need to add to this query to achieve this? presently the query...
Forum: SQL Server 2005 March 20th, 2009, 09:10 AM
Replies: 2
Views: 957
Posted By jcarswelljr
thank you

This is PERFECT!!!
thank you [:)][:D]
Forum: SQL Server 2005 March 19th, 2009, 04:26 PM
Replies: 2
Views: 957
Posted By jcarswelljr
query pulling null records

Good afternoon,
i tried using having and this query still pulls records that have all nulls and not just records that have person_id in EPPSGlobalProd.dbo.person and in one of the 7 tables in the...
Forum: SQL Server 2005 February 25th, 2009, 03:06 PM
Replies: 0
Views: 791
Posted By jcarswelljr
query tables in 2 different databases

I have this query that has gotten quite messy. i know what i want to say, but havent been able to tie it together.
i would like to query a few tables in the EPPSGlobalProd and LogItProd databases...
Forum: SQL Language February 16th, 2009, 09:57 AM
Replies: 8
Views: 1,043
Posted By jcarswelljr
thank you

thank you guys this really helped me! i was able to redo the query and gain the results i wanted.
use antibribery
SELECT distinct (antibriberyallusers.Universal_Id), antibriberyallusers.Email,...
Forum: SQL Language February 13th, 2009, 06:26 PM
Replies: 8
Views: 1,043
Posted By jcarswelljr
Smile how to use OR operator or CASE??

I have a query that seems to be a bit long and i know there is a more scalable and actually correct way to write it...i need for the query to pull records that meet any one of the conditions (below...
Forum: BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 December 11th, 2008, 02:11 PM
Replies: 0
Views: 3,177
Posted By jcarswelljr
quartile and rank query in SQL Report

Hello,
I need help with this report that utilizes rank and quartiles. I tried to explain it below the best way possible.



Company
Date
Gravity
pH
BP
Showing results 1 to 7 of 7

 


All times are GMT -4. The time now is 11:59 AM.


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