ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,206 through 5,220 (of 10,143 total)

RE: Count Rows within a Query

CassieF (2/11/2013)
oohh phooey, i am on a higher version than that.. 2008R2
It works fine on 2008R2, that's what I tested the script on. Are you sure that the server 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

February 11, 2013 at 9:28 am

#1586645
RE: Count Rows within a Query

CassieF (2/11/2013)
thank you, i just tried to execute that and it gave me an incorr syntax error near keyword Over..:doze:
it also didnt pink out the first [count] so 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

February 11, 2013 at 9:21 am

#1586639
RE: Change value of column in last row when doing insert

sku370870 (2/10/2013)
DECLARE @LastOne bit = 0
CREATE TABLE #tblTasks
(
TaskID int,
...
^{“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

February 11, 2013 at 9:17 am

#1586636
RE: move record

Ed Wagner (2/11/2013)
Is this what you're looking for?
insert into different_table(computername, auditid, auditdate)
select computername, auditid, auditdate
from original_table a1
where auditdate =...
^{“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

February 11, 2013 at 9:02 am

#1586631
RE: Comparing figures based on relative date

Paul Munter (2/11/2013)
Thanks for the advice, I was hoping to store it to avoid the computations being done by an application. I like to have as much stored as possible...
^{“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

February 11, 2013 at 9:01 am

#1586630
RE: Count Rows within a Query

You can have whatever headings you want:
SELECT [Count] = 1, [Market name] = 'Borough Market'
What's important is the column content. Can you explain further? Is it something like this?
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

February 11, 2013 at 8:52 am

#1586624
RE: Comparing figures based on relative date

Paul Munter (2/11/2013)
I'd like to be able to write a cursor of similar code which does this dynamically for me based on a data set that I have. So 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

February 11, 2013 at 8:40 am

#1586615
RE: Comparing figures based on relative date

Paul Munter (2/11/2013)
Exactly like that Chris, yes.
Cool, it was a lucky guess. Now what do you want to do with 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

February 11, 2013 at 8:18 am

#1586599
RE: Comparing figures based on relative date

Something like this?
DROP TABLE #mytable
CREATE TABLE #mytable
(P_KEY INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
LAST_DAY_OF_MONTH DATETIME,...
^{“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

February 11, 2013 at 8:08 am

#1586593
RE: Comparing figures based on relative date

Hi Paul
You have rows in your table which have a datetime column. You want to pick some rows which have a "recent" date, from the table. On the same output...
^{“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

February 11, 2013 at 7:31 am

#1586555
RE: Cumulative SUM by HOUR for specific DATE range

Jason-299789 (2/11/2013)
Chris,
I've never seen the recursive CTE method before, and looks like a viable option to the quirky update to a point.
Hi Jason, it's been subjected to a significant...
^{“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

February 11, 2013 at 7:00 am

#1586533
RE: Cumulative SUM by HOUR for specific DATE range

lilywhites (2/11/2013)
ive got over 500 queues and 15 extra data columns to compute also....would those links scale up??
ive got this running in under 20 seconds....ill look into those other methods
many...
^{“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

February 11, 2013 at 6:57 am

#1586532
RE: move record

huy1002 (2/10/2013)
Master table
ComputerName. AuditId. AuditDate.
A. 111. 1/1/13
A. 222. 2/1/13
A. 000. 2/1/13
B. 111. 1/1/13
C. 000. 1/1/13
C. 111. 2/1/13
AuditId equals to zero telling no vulnerability found on that day scan.
I need...
^{“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

February 11, 2013 at 6:14 am

#1586518
RE: Cumulative SUM by HOUR for specific DATE range

Jason-299789 (2/11/2013)
You might wnat to revisit the code, I would suggest reading this article http://www.sqlservercentral.com/articles/T-SQL/61539/ and then look at a turning this into a Quirky update for the Running total,...
^{“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

February 11, 2013 at 6:12 am

#1586515
RE: All Possible Combinations Loop

akberali67 (2/9/2013)
Ok, that does makes sense.
Just one last question and I am sorry if I am bothering you. How much memory do you anticipate I would need to run...
^{“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

February 11, 2013 at 5:18 am

#1586475

Viewing 15 posts - 5,206 through 5,220 (of 10,143 total)