ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,151 through 9,165 (of 10,143 total)

RE: insert currency name and symbol

lemonsqueezy101 (12/12/2008)
I'm sure it's me that's missing something not you!
From what I can gather, you're saying I can use the value I have that was entered via the DDL, check...
^{“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

December 12, 2008 at 3:39 am

#911527
RE: insert currency name and symbol

lemonsqueezy101 (12/12/2008)
Hi Chris,
I already have the currency name and currency symbol list in a table with the Currency Name populating the drop down list the user will select from.
This DDL...
^{“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

December 12, 2008 at 3:31 am

#911523
RE: insert currency name and symbol

lemonsqueezy101 (12/12/2008)
Hi Guys,
I have a requirement to store the currency name and the currency symbol for a record inserted by a user. I only want to have the user 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

December 12, 2008 at 3:10 am

#911517
RE: Urgent: Need help with Query on Group By Part

Here's what the code looks like when it's given a bit of a cleanup:
[font="Courier New"]SELECT T1.PROJ_ID + SPACE(1) + T2.PROJ_NAME AS Project, -- fn CONCAT is an XQUERY function
T4.org_name...
^{“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

December 12, 2008 at 1:55 am

#911506
RE: Need to get all rows in a table based on hour difference > 2 condition

sunil.si (12/12/2008)
Can anyone help to find the syntax error in this query?
@query = 'select empID from EducationDepartment where DateDiff(hh, checkInTime, getdate()) > 2 and userPriority = 1 and status !=...
^{“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

December 12, 2008 at 12:42 am

#911492
RE: Linked Server openquery error

sujiakm (12/11/2008)
Hi.. appreciate your immediate reply...
.. in this query I am trying to run an INSERT cmd , which inserts the data collected at the LinkedServer into a local...
^{“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

December 12, 2008 at 12:29 am

#911486
RE: Aggregate returns zero value

pushalydan (12/11/2008)
Can you please help me resolve this issue:
I have a temp table called temp_phone_interval, when I run this query:
select max(currdate) as rpt_date, sum(ivr2q) as total_calls, sum(q2assagt+q2agt)as ans_calls, sum(q2assagt+q2agt+qabn)/sum(ivr2q)...
^{“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

December 11, 2008 at 2:14 pm

#911339
RE: Concatenate issue with datetime

jeffrey_bryant (12/11/2008)
It works!!!
I went with the original solution. It got what I needed but am going to try out Jeff's cursor'less version just to see how it works.
Thanks for the...
^{“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

December 11, 2008 at 9:52 am

#911198
RE: Are the posted questions getting worse?

Lynn Pettis (12/11/2008)
Chris Morris (12/11/2008)
Lynn, have you considered moving to Ohio[/url]?
Why would I do that? I am a born and raised Coloradoian. I love it here, it's Gods...
^{“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

December 11, 2008 at 9:05 am

#911174
RE: Select query to return one row per company with the highest date

Josh Turley (12/11/2008)
SELECT 'Company A', 'Web', '01/01/2006' UNION ALL
SELECT 'Company B', 'Tradeshow', '10/03/05' UNION ALL
SELECT 'Company B', 'Magazine', '12/05/04' UNION ALL
SELECT 'Company C', 'Company A', '09/05/06' UNION ALL
SELECT 'Company C',...
^{“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

December 11, 2008 at 9:03 am

#911170
RE: SQL Help

Ian (12/10/2008)
Actually, the current DB design allows for multiple sub cats, so you could have Category/sub/subsub/subsubsub and so on, but the data I am using only goes to a...
^{“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

December 11, 2008 at 8:58 am

#911165
RE: Select query to return one row per company with the highest date

Like this?
SET DATEFORMAT MDY
CREATE TABLE #referrals (company VARCHAR(10), referral VARCHAR(20), referral_date DATETIME)
INSERT INTO #referrals (company, referral, referral_date)
SELECT 'Company A', 'Web', '01/01/2006' UNION ALL
SELECT 'Company B', 'Tradeshow', '10/03/05' UNION ALL
SELECT 'Company...
^{“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

December 11, 2008 at 8:51 am

#911156
RE: Are the posted questions getting worse?

Lynn, have you considered moving to Ohio[/url]?
^{“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

December 11, 2008 at 8:38 am

#911140
RE: sql script to read values from the excel sheet

Nomvula (12/10/2008)
hi
i'm not sure whether it's possible, i have data in my excel sheet of which i need to create a script from my sql database and join the fields...
^{“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

December 11, 2008 at 7:59 am

#911101
RE: Are the posted questions getting worse?

Lynn Pettis (12/11/2008)
Okay, I can take the heat, however consider this; 3 automobile accidents over 15 years of commuting from the south side of Colorado Springs to Denver and driving...
^{“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

December 11, 2008 at 7:27 am

#911062

Viewing 15 posts - 9,151 through 9,165 (of 10,143 total)