ChrisM@Work

Forum Replies Created

Viewing 15 posts - 4,696 through 4,710 (of 10,143 total)

RE: inherited an app, Error started the next day

chadmack (4/30/2013)
Thanks to everyone so far, Code is over 9000 lines in its entirety.
This appears to be a data issue. The data in moveitems.description is getting tuncated, this is...
^{“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 1, 2013 at 1:07 am

#1611478
RE: Random Number Generator

todd.ayers (4/30/2013)
Thx Bro I really really appreciate all your help!!!!
BRO?!!! Are you an old git too?
^{“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 30, 2013 at 9:26 am

#1611297
RE: Extract a string between two special characters

SELECT
d.Example,
[Output] = SUBSTRING(d.Example, 2,
NULLIF(CHARINDEX('/',d.Example,2),0)-2)
FROM ( -- sample data
SELECT Example = '/IT/Management' UNION ALL
SELECT '/PRODUCTION/Name' UNION ALL
SELECT 'Nothing'
) d
^{“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 30, 2013 at 9:24 am

#1611295
RE: Random Number Generator

todd.ayers (4/30/2013)
well..... Darn.. I dont have SQL on my desktop... only access 2007
Sorry, I can only guarantee that it will run in SQL Server 2008 - this is, after all,...
^{“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 30, 2013 at 8:45 am

#1611266
RE: cannot insert duplicate key row in object 'tablename' with unique index 'indexname'

logicinside22 (4/30/2013)
hope this helps
http://connect.microsoft.com/SQLServer/feedback/details/434632/#details
Not really. The connect item refers to a bug which can only be observed if a very specific set of conditions are met.
^{“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 30, 2013 at 8:41 am

#1611263
RE: Random Number Generator

Copy the lot, paste it into an SSMS window and execute it.
^{“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 30, 2013 at 8:27 am

#1611255
RE: Stored procedure Script to display and add two different currency columns using case for conversions

issa269 (4/30/2013)
Thanks alot ChrisM@Work,
My mistake unit cost was 0 on those rows.
You're welcome 😉
^{“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 30, 2013 at 8:01 am

#1611239
RE: Random Number Generator

todd.ayers (4/30/2013)
I am trying to create a random number generator that would populate a number between 8-48 to 9 different lanes with the only criteria being that each lane number...
^{“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 30, 2013 at 7:57 am

#1611238
RE: Stored procedure Script to display and add two different currency columns using case for conversions

issa269 (4/30/2013)
Thanks ChrisM@Work for the help, it removed the duplicates as i had asked but the total cost for the added column displayed value for only dollars(id for dollar is...
^{“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 30, 2013 at 7:18 am

#1611217
RE: Use of rownum function in a select

You need the ORDER BY, otherwise what TOP returns is unpredictable.
You also need the reference to table trans in the subselect because the [order] table is filtered by a different...
^{“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 30, 2013 at 7:15 am

#1611212
RE: Stored procedure Script to display and add two different currency columns using case for conversions

The subquery (inner query) you added isn't correlated to the outer (main) query. Since all of the tables in the inner query are already referenced by the outer query, do...
^{“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 30, 2013 at 6:36 am

#1611197
RE: T-SQL Greatest function workarounds - timing tests

mister.magoo (4/30/2013)
Evil Kraig F (4/29/2013)
Because of Mr. Magoo's confusion as to my use case, I want to present an idea of the use case. It's not the one 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

April 30, 2013 at 6:17 am

#1611192
RE: Use of rownum function in a select

@DJ (4/30/2013)
ChrisM@Work: I have never used cross apply before. Will have to study that one.
I see you placed an group by...
Is this needed or optional.
I am trying your version now,...
^{“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 30, 2013 at 6:08 am

#1611188
RE: Generating a counter table in SQL

SteveEClarke (4/30/2013)
Hi All,
I am currently looking at a project that requires acounter table - I have done this very easilly in Excel with a VBScript - but want to do...
^{“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 30, 2013 at 6:02 am

#1611184
RE: inherited an app, Error started the next day

I'd check for NULL decsription in the source table:
DECLARE MOVEITEMS_CUR CURSOR FOR
SELECT MOVEITEMSID, MOVEDATE, ITEMID, [DESCRIPTION], USERID
FROM MYOB_IMPORT..MOVEITEMS
WHERE [DESCRIPTION] IS NOT NULL
The code is horrible! I gave...
^{“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 30, 2013 at 5:54 am

#1611180

Viewing 15 posts - 4,696 through 4,710 (of 10,143 total)