ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,221 through 8,235 (of 10,143 total)

RE: Caution with EXCEPT

Tobar (1/18/2010)
The programmer "intended" it to work the way the programmer thought they were programming it to work. 😀 [this said in the universal sense]
LOL you used to work there...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 18, 2010 at 7:14 am

#1104921
RE: The data types varchar and nvarchar are incompatible in the modulo operator

Bhuvnesh (1/18/2010)
while running the below query , i m getting the error :
"The data types varchar and nvarchar are incompatible in the modulo operator."
Please post the result of the PRINT...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 18, 2010 at 7:07 am

#1104914
RE: Caution with EXCEPT

Stephen Hirsch (1/18/2010)
Here's a better way:
SELECT 'IN A NOT B' location, a, b, c, d, ...
FROM tablea
EXCEPT
SELECT 'IN A NOT B' location, a, b, c, d, ...
FROM tableb
UNION ALL
SELECT 'IN...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 18, 2010 at 6:12 am

#1104892
RE: Detect duplicates with custom rule and update a row according to date

Biz (1/17/2010)
The sample data as per your request is:
INSERT INTO [SF].[dbo].[PackageData] ([Package Grp No] ,[Account] ,[SrID],[Update Accept_Offer__c] ,[Offer_Letter_Name__c],[New Stage] ,[Package Item No] ,[Opportunity Name],[Opportunity Stage],[Course Start Date],[Opportunity ID],[Group: ID],[PackageID])...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 18, 2010 at 3:02 am

#1104832
RE: 3 Table Join in Stored Proc

Larry Bargers (1/15/2010)
I got it working by adding an Info class and populating that.
Thanks again for the help.
You're welcome, Larry, good result.
Can I recommend that for future reference, you read...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 15, 2010 at 10:04 am

#1104327
RE: How do you limit records using Distinct and Count - TOP and Rowcount dont work ?

Yeah but...kinda.
This time round, you know exactly why you would put it there, and why you will (almost) always get more results in your final output than you specified...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 15, 2010 at 9:35 am

#1104295
RE: How do you limit records using Distinct and Count - TOP and Rowcount dont work ?

This bit...
SELECT Email1,Email2,Email3, Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM outputresume3
WHERE ((contains (originalresume, '"j2ee" and "java"'))
AND (currentdateout BETWEEN '2000-01-01' AND '2010-01-06'))
change it to
SELECT...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 15, 2010 at 8:55 am

#1104264
RE: 3 Table Join in Stored Proc

SELECT u.Email, 'Submitted by' AS UserRole
FROM Bold_FeatureRequest FR
INNER JOIN Users U on FR.UserId = U.UserId
WHERE FR.FeatureId = @featureId
UNION ALL
SELECT u.Email, 'Commented on by' AS UserRole
FROM Bold_FeatureRequestComment FRC...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 15, 2010 at 8:14 am

#1104234
RE: Alpha before numeric

SELECT MyString, ASCII(MyString)
FROM (
SELECT '000' AS MyString UNION ALL
SELECT '101' UNION ALL
SELECT '200' UNION ALL
SELECT '201' UNION ALL
SELECT '300' UNION ALL
SELECT '901' UNION ALL
SELECT ' aAA' UNION ALL
SELECT 'AAB'...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 15, 2010 at 6:37 am

#1104157
RE: Question about query error received

Hello
The UPDATE and the SET apply to the same table.
Ideally the first table listed after FROM is also the target of the update.
In your case, you've aliased the target...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 15, 2010 at 4:52 am

#1104121
RE: Detect duplicates with custom rule and update a row according to date

Please set up your data as a series of INSERT statements, this will help users to begin work on your problem.
Cheers
ChrisM
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 15, 2010 at 3:51 am

#1104110
RE: How do you limit records using Distinct and Count - TOP and Rowcount dont work ?

ifila (1/14/2010)
After 25 years of dealing with IT people, I guess sometimes one can get cantankerous.
Thanks to all the constructive contributors!
Guilty of cantankerism as charged - but hey,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 15, 2010 at 2:15 am

#1104095
RE: Message sequencing error

Have you contacted the vendor?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 14, 2010 at 6:27 am

#1103551
RE: Are the posted questions getting worse?

Grant Fritchey (1/14/2010)
Chris Morris-439714 (1/14/2010)
Greg Edwards-268690 (1/13/2010)
Grant Fritchey (1/13/2010)
Steve Jones - Editor (1/13/2010)
Grant,
I didn't think it was that bad, but when it doubt, doesn't hurt to apologize.
Yep. I agree. As...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 14, 2010 at 6:07 am

#1103542
RE: Compare data to the same time last year?

craighenderson (1/14/2010)
Doh!
No I wanted a date 1 year and 8 days ago...
learning all the time, just not quick enough eh 🙂
You're doing just fine, Craig.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 14, 2010 at 5:50 am

#1103538

Viewing 15 posts - 8,221 through 8,235 (of 10,143 total)