ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,046 through 6,060 (of 10,143 total)

RE: Help on SQL query

GSquared (7/12/2012)
Jeff Moden (7/10/2012)
@Gus,
Ok... I've been looking at this thread for a bit for "Sam's view definition" and I'm not finding any "SAM" that posted. Did you mean "Chris'...
^{“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

July 12, 2012 at 7:05 am

#1512033
RE: update statment help

UPDATE c SET
TotalDue = s.Freight + s.SubTotal + s.TaxAmt
FROM #Contact c
INNER JOIN #Sales s ON s.ContactID = c.ContactID
^{“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

July 12, 2012 at 6:58 am

#1512025
RE: Woohoo MCTS passed

Well done Mark 🙂
^{“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

July 12, 2012 at 6:29 am

#1512008
RE: Sql query to get recursive count

Hello and welcome to ssc. Please have a read of the best practices / forum etiquette article here[/url].
This looks straightforward - if you can post some easily-consumable data as suggested...
^{“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

July 12, 2012 at 5:35 am

#1511985
RE: Using CASE for quieries via a Linked Server (MySQL)

The constant 'UK' in the command string will need extra quotes:
CASE siteId WHEN 91 THEN '''UK''' END
There are two flavours of CASE statement, simple and searched. This is a searched...
^{“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

July 12, 2012 at 4:24 am

#1511966
RE: Running Total

jerome.morris (7/11/2012)
There is lots of selects in this so I am not 100% where to put the date part. I also want to use Variables form from C# app.
(Docket_Date...
^{“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

July 12, 2012 at 1:47 am

#1511894
RE: Running Total

jerome.morris (7/11/2012)
I found out the Row grouping was incorrect in my report so its working now. I will eventually select Docket_Date also but will try a figure out where 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

July 11, 2012 at 9:50 am

#1511658
RE: Loop within a Loop

Or like this:
;WITH Numbers AS (SELECT * FROM (VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27)) d(n))
SELECT CHAR(a.n+64) + CAST(b.n AS VARCHAR(2))
FROM Numbers a CROSS JOIN Numbers b
WHERE a.n < 27
^{“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

July 11, 2012 at 9:45 am

#1511649
RE: Running Total

jerome.morris (7/11/2012)
When I execute this in SQL the results are perfect and in the correct order, I use a stored procedure and then drag to my DataSet designer in VS2010...
^{“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

July 11, 2012 at 9:43 am

#1511648
RE: Running Total

Jay, don't be afraid to ask - so long as you're willing to put in some effort, which you certainly have done so far, then folks will chip in 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

July 11, 2012 at 8:54 am

#1511603
RE: Running Total

jerome.morris (7/11/2012)
That what I cant do I need to make a that column and add the totals together
so the last column would look like this
53
70
79
88
95
98
100
Like this?
; WITH OrderedData 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

July 11, 2012 at 8:39 am

#1511593
RE: Running Total

Jay, using the sample data you posted yesterday, your query above generates the following result:
Docket_CategoryDocketsPct_To_Total
Mechanical 440 ...
^{“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

July 11, 2012 at 7:23 am

#1511530
RE: An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.

krishnaprasad14 (7/11/2012)
Really can't modify anything.
[My self I think 23,000 row count is not big for GB Ram server....]
Thank you.
It's the client limit, not the server, as Anthony pointed...
^{“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

July 11, 2012 at 5:56 am

#1511461
RE: An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.

krishnaprasad14 (7/11/2012)
Hi Thank you for your replay. I was done this. I can execute if I change query results to text o file but geting an error when I choose...
^{“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

July 11, 2012 at 5:49 am

#1511458
RE: An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.

krishnaprasad14 (7/10/2012)
Hi,
I am geting this error when I try to run a quer through SSMS.
Table got 23000 records and SQL srever max memoy assigned 3024.
Thank you in Advance,
Krishna
Run the results...
^{“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

July 11, 2012 at 5:25 am

#1511446

Viewing 15 posts - 6,046 through 6,060 (of 10,143 total)