Forum Replies Created
Viewing 15 posts - 1,021 through 1,035 (of 1,183 total)
-
RE: Join on dates, but exclude others ... ?
Well, fortunately I do have 2k5 so I'll take the time to create my proc using your solution and post the results. Besides, even if it doesn't work better it's...
______________________________________________________________________
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 on dates, but exclude others ... ?
Jeff,
FIRST, thank you for the reply!
SECOND, it's funny. Right when you posted this solution I came upon my own. I'm anxious to see which performs better. not that this is...
______________________________________________________________________
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 on dates, but exclude others ... ?
LOL, it's homework alright, but from work!
I'll just post my section of the procedure. I think that should be enough to show...
______________________________________________________________________
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: Sort breaks
Peter,
I'm curious to your thoughts on my solution. My personal opinion is that it's easier to read/understand.
Jason
______________________________________________________________________
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: Sort breaks
What about ...
SELECT
'$0-$10' = Sum(CASE WHEN orderAmount BETWEEN 0 AND 9.99 THEN 1 ELSE 0 END)
,'$10-$15' = Sum(CASE WHEN orderAmount BETWEEN 10 AND 14.99 THEN...
______________________________________________________________________
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: T-SQL and The Excel Solver
A yardstick is better. It doesn't completely incapacitate the user but still gives a nice sting.
______________________________________________________________________
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: T-SQL and The Excel Solver
I've found that carrying a yard stick and smacking them upside the head when they forget to be the best training tool around.
______________________________________________________________________
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: Printing problem from Report Viewer
The GDIPlus.dll should be on all windows machines by default. It's not something you install or would have installed in the past.
I would suggest trying the solution I posted in...
______________________________________________________________________
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: UNPIVOT Function Help
The code above worked for me. ?
______________________________________________________________________
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: Subscription problem
Set your parameter default to...
=DateTime.Today.AddMonths(-1)
and that should do it.
______________________________________________________________________
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: UNPIVOT Function Help
Michael,
GOOD QUESTION!!! It would be nice if you could perform an UNPIVOT on multiple columns at the same time. I don't think you can, but the code below seems 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: Data Driven Subscriptions Updated
Just use this script and add the primary key through Enterprie manager...
CREATE TABLE [dbo].[Subscription_History](
[nDex] [int] IDENTITY(1,1) NOT NULL,
[SubscriptionID] [uniqueidentifier] NULL,
[ScheduleName] [nvarchar](260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[parameterSettings] [varchar](8000)...
______________________________________________________________________
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: Getting started with Visual Basic 2005 Express and SQL 2005 Express
If your talking about SQL 2005 then it's in SQL Management Studio.
______________________________________________________________________
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: Where do i type in for SQL from Visual basic 2005 express edition
I'm not completely clear on the question, but I think you need to be in Query Analyzer
______________________________________________________________________
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: sql query efficient or NOT?
A few questions…
1. What field(s) constitutes a “duplicate”? You may also want to look up examples of IF EXISTS.
a. If it’s a single field,...
______________________________________________________________________
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 - 1,021 through 1,035 (of 1,183 total)