ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,856 through 6,870 (of 10,143 total)

RE: Query Help

sqlnaive (6/30/2011)
Thanks Nakul. Thats not what I'm looking for. Lolz.
Actually looking for "If input string is like AAAA, pqrstuv, xxxx-lmn, ZZZsswD then output string should be 'AAAA', PQRSTUV', 'XXX-LMN', 'ZZZSSWD'".
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

June 30, 2011 at 2:04 am

#1346357
RE: How to fill spaces depending on the character size

Jnrstevej (6/29/2011)
... I didn't think a CASE Statement could achieve what i was looking for so i quickly dismissed it for the IF Statement....
CASE works within a statement, IF chooses...
^{“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

June 29, 2011 at 7:44 am

#1345927
RE: How to fill spaces depending on the character size

Jnrstevej (6/29/2011)
...So the vendor can only contain a maximum of 7 numeric values i want a statement which counts the number of numeric values of the vendor lets say there's...
^{“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

June 29, 2011 at 7:31 am

#1345919
RE: How to fill spaces depending on the character size

Steve, working effectively with TSQL, as with any programming language, requires experimentation...
SELECT 'PL01' + '_' + CASE
WHEN vendor IS NULL THEN SPACE(4)
WHEN LEN(vendor) < 4 THEN CAST(Vendor AS CHAR(4))
WHEN LEN(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

June 29, 2011 at 7:10 am

#1345902
RE: Today's Random Word!

SQLRNNR (6/27/2011)
exam
Good luck!
^{“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

June 27, 2011 at 8:51 am

#1344553
RE: Query is running slowly in morning times and it is running normally in evening times.

Can you post the query?
^{“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

June 8, 2011 at 7:00 am

#1335618
RE: Is NTILE OVER (PARTITION BY .. running total..) possible?

Jeff Moden (5/15/2011)
ChrisM@home (5/2/2011)
This is probably the simplest set-based solution.
Oh... be careful, Chris. Apologies for quibbling but a Recursive CTE isn't set-based. It's a form of hidden RBAR...
^{“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

May 15, 2011 at 11:37 pm

#1324858
RE: Can't work out how to retrieve data

You're welcome - and you have the benefit of a fully-documented method 🙂
^{“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

April 7, 2011 at 8:06 am

#1308549
RE: query using results of another query.

lance.kentwell (4/6/2011)
Thanks I dont care so much if its elegant, just as long a it works 🙂 I'll give it a try. Since im still a newbie I...
^{“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

April 7, 2011 at 7:08 am

#1308490
RE: Can't work out how to retrieve data

Hello
Read this article [/url]by Jeff Moden to understand how the following code works.
-- make some sample data
SET DATEFORMAT DMY
DROP TABLE #tblMeeting
CREATE TABLE #tblMeeting(
...
^{“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

April 7, 2011 at 7:04 am

#1308486
RE: query using results of another query.

This should work just fine although it's far from elegant.
SELECT DISTINCT i.ipaddress, u.user_name
FROM dbo.scr_dim_site_request sr
INNER JOIN dbo.scr_dim_site s
ON sr.site_id = s.site_id
INNER JOIN dbo.scr_fct_exact_access ea
ON sr.site_request_id...
^{“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

April 6, 2011 at 5:43 am

#1307937
RE: query using results of another query.

lance.kentwell (4/5/2011)
I need to use the result of a query, call it query 1, as a WHERE criteria in query 2. I tried to do it as a subquery...
^{“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

April 6, 2011 at 2:47 am

#1307860
RE: Today's Random Word!

Golive.
^{“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

April 6, 2011 at 1:28 am

#1307834
RE: Are the posted questions getting worse?

Roy Ernest (4/4/2011)
I think then I have to remove quite a bit of target stickers. I think the target sticker is on me... 😀
First they tried to hit me from...
^{“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

April 5, 2011 at 2:07 am

#1307335
RE: Are the posted questions getting worse?

Congratulations to Paul White, who's joined the elite through hard work and outstanding contributions to the community. Well done Paul, very well deserved.
^{“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

April 1, 2011 at 9:20 am

#1306568

Viewing 15 posts - 6,856 through 6,870 (of 10,143 total)