ChrisM@Work

Forum Replies Created

Viewing 15 posts - 3,301 through 3,315 (of 10,143 total)

RE: Are the posted questions getting worse?

wolfkillj (5/30/2014)
SQLRNNR (5/30/2014)
wolfkillj (5/30/2014)
jcrawf02 (5/30/2014)
jasona.work (5/30/2014)
The impression I've gotten is that they already have a contract with NASA to ferry crew, it's just been waiting for the man-rated capsule to...
^{“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 2, 2014 at 1:56 am

#1718121
RE: t-sql 2008 exlain select

Do they really need to understand how it works in order to use it? I think it’s sufficient to know what it’s used for – “Pivot one or more columns...
^{“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 30, 2014 at 8:59 am

#1717815
RE: t-sql 2008 exlain select

sgmunson (5/30/2014)
ChrisM,
If the original poster needed an explanation of a fairly simple query, somehow, it just doesn't seem likely that they're going to consider FOR XML PATH as something easier...
^{“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 30, 2014 at 7:01 am

#1717749
RE: t-sql 2008 exlain select

wendy elizabeth (5/29/2014)
...Can you explain to me the sql listed above?
If you want to make your code significantly faster, more compact, and more readable, try this:
SELECT
t.*,
x.[tMask_out]
FROM [test].[dbo].[test1] t
CROSS APPLY...
^{“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 30, 2014 at 6:05 am

#1717730
RE: t-sql 2008 exlain select

wendy elizabeth (5/29/2014)
...Can you explain to me the sql listed above?
A different coding method may help Steve's description:
SELECT tmask,
b1 = CASE WHEN rem2 >= 1 THEN 1 ELSE 0...
^{“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 30, 2014 at 5:27 am

#1717720
RE: Please help this slow and cumbersome query

eyric101 (5/29/2014)
It takes more then 30 seconds to run
DECLARE @intTmpTblCnt INT,
@strTmpSql VARCHAR(max),
...
^{“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 30, 2014 at 2:32 am

#1717683
RE: using select Max with insert

ronan.healy (5/29/2014)
where would i put it in the first slect
SET @MAXVALUE =
(
SELECT MAX(sectionnumber)+1,
FROM dbo.BNYWorkingSecTable
)
How about a little bargaining here - you spend a little time and effort describing your...
^{“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 29, 2014 at 9:43 am

#1717412
RE: LTRIM and RTRIM not working

GBeezy (5/29/2014)
I am not getting an error...
Before the function call I using the ASCII(RIGHT(t.OffensiveColumn,1)) to see what the ASCII character is, then calling the function, and returning the results to...
^{“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 29, 2014 at 9:38 am

#1717409
RE: LTRIM and RTRIM not working

GBeezy (5/29/2014)
And it doesnt work, unless I am calling/using it wrong, I am passing my code in as the following:
SELECT dbo.RemoveNonASCII(t.OffensiveColumn) AS RemovedASCII
FROM table t
Do you get an error or...
^{“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 29, 2014 at 8:48 am

#1717378
RE: using select Max with insert

ronan.healy (5/29/2014)
ya well once the new number is created its then stored in a file and re read into table so its always there.
it works well for the one account...
^{“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 29, 2014 at 5:50 am

#1717298
RE: Problem with Varbinary

SQL Server has no explicit conversion from VARBINARY to FLOAT, but you can roll your own. Refer to this thread.
This inline table-valued function is based on the UDF described 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

May 29, 2014 at 4:17 am

#1717277
RE: COALESCE to replace multiple CASE statements

Alvin Ramard (5/28/2014)
Luis Cazares (5/27/2014)
Alvin,
The code makes clear that there's a concatenation based on multiple values on a single column.
CASE WHEN A.[COL_1] LIKE '%cricket%' THEN 'ck' + ',' ELSE...
^{“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 28, 2014 at 7:27 am

#1717008
RE: Joining two tables and dealing with null values

Check BOL (the SQL Server help system) for the ISNULL() function, and have a look at the related functions COALESCE() and NULLIF() too.
Note that your output columns can only be...
^{“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 28, 2014 at 7:03 am

#1716998
RE: reg sql query

shiva N (5/28/2014)
SELECT DISTINCT a.itemcode
,b.itemname
,SUM(qty) AS Total_Qty
,SUM(Price) AS Total_Price
FROM oppharsales2 AS a
LEFT JOIN masteritem AS b ON a.itemcode = b.itemcode
INNER JOIN oppharsales1 c ON a.billno = c.billno
GROUP BY a.itemcode
,b.itemname
Can you...
^{“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 28, 2014 at 6:08 am

#1716981
RE: Deadlock without victim

Bhuvnesh (5/28/2014)
Can there be a case that deadlock happens and Sql doesn't choose any victim and No transaction got rollback/killed.
and DBA has to KILL any one of transaction ?...
^{“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 28, 2014 at 5:15 am

#1716963

Viewing 15 posts - 3,301 through 3,315 (of 10,143 total)