Forum Replies Created
Viewing 15 posts - 961 through 975 (of 1,183 total)
-
RE: RS Book Recommendations
This one is for RS 2000, but the majority of it applies to 05. I like this one because it really digs into the inner workings of RS.
Hitchikers Guide to...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: yea or nay - Allowing nulls on a FK column
My personal opinion would be to use a linking table to hold the employeeID and projectID. This way if an employee doesn't have a project, then there simply wouldn't be...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Need help summarizing data
This seems to work for me. If still getting incorrect results, please post the data that's being calced wrong.
SELECT
numberOfOrders = COUNT(DISTINCT s0.soNo)
,nullShip = SUM(CASE...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Need help summarizing data
An important note. Unless you have a unique/primary key that identifies each unique order line item, any orders with all info the same will cause erronious dups. so if you...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Need help summarizing data
OK, This appears to get what you want. It may not be the most optimized solution though.
/* lets put all of the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Need help summarizing data
What if the order that was split had one on time and one late. Do you need a result set of 3 orders and 2 onTime? or do you need...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Need help summarizing data
Can you not refer to invShp instead of shpQty?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Need help summarizing data
Can you post the DDL for all tables involved and sample data for them as well?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: ON THE FLY
Read up on WITH ROLLUP in BOL....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Query analyzer issue
User permissions/object owner.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Join - optional criteria
Move the check into the join clause....
SELECT comment.comment_id, comment.comment, comment.post_id, comment.comment_date, aspnet_Users.UserId, aspnet_Users.UserName,
user_pic.user_pic, user_pic.user_pic_default
FROM comment INNER JOIN
aspnet_Users ON comment.userid = aspnet_Users.UserId LEFT OUTER JOIN
user_pic ON...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Join - optional criteria
If I understand you correctly, then just remove the "(user_pic.user_pic_default = 'y') AND" from your WHERE clause.
This will return ALL records for the postId regardless of the default value.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Connection not found to Report server
What happens when you put http:///ReportServer in a new browser window?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Call a report from classic ASP (NOT .NET) and pass user credentials?
Yeah, I'm just having issues getting around the windows authentication required to "hit" the server.
FYI, we did find a work around though. Since our site's login page is .NET, which...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Call a report from classic ASP (NOT .NET) and pass user credentials?
Ben,
Thanks, but you can't pass windows authenication via the URL, only the DB credentials can be passed that way.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg
Viewing 15 posts - 961 through 975 (of 1,183 total)