ChrisM@Work

Forum Replies Created

Viewing 15 posts - 631 through 645 (of 10,143 total)

RE: Are the posted questions getting worse?

Forum outage for around 20 minutes here.
^{“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 19, 2017 at 9:39 am

#1951672
RE: Creating Stored Procedure problem with a union in it.

EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE
If you were to save the string beginning 'CREATE PROCEDURE...' to a variable...
^{“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 19, 2017 at 8:55 am

#1951662
RE: Adding an Artcle to an exiting publication need Snapshot agent to run?

SQL-DBA-01 - Wednesday, July 19, 2017 8:37 AM
I can see that the "Allow Anonymous Subscription" and Allow Immediate Updating Subscriptions are False...
^{“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 19, 2017 at 8:46 am

#1951658
RE: update column based on max date for each employee

Thom A - Wednesday, July 19, 2017 8:02 AM
ChrisM@Work - Wednesday, July 19, 2017 7:51 AM
^{“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 19, 2017 at 8:12 am

#1951643
RE: How to get top and bottom rows from where condition

Sangeeth878787 - Wednesday, July 19, 2017 7:45 AM
ChrisM@Work - Wednesday, July 19, 2017 7:27 AM
^{“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 19, 2017 at 7:53 am

#1951633
RE: update column based on max date for each employee

Eirikur Eiriksson - Wednesday, July 19, 2017 6:05 AM
Thom A - Wednesday, July 19, 2017 5:56 AM
^{“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 19, 2017 at 7:51 am

#1951631
RE: How to get top and bottom rows from where condition

Sangeeth878787 - Wednesday, July 19, 2017 7:13 AM
ChrisM@Work - Wednesday, July 19, 2017 6:54 AM
^{“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 19, 2017 at 7:27 am

#1951619
RE: How to get top and bottom rows from where condition

Luis Cazares - Wednesday, July 19, 2017 6:35 AM
Will you have gaps in your Id column?
If yes, then something like this:
[code...
^{“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 19, 2017 at 6:54 am

#1951604
RE: Hourly Sum of Data

Making a start on your question. Run the query, and confirm whether or not the result set fits the "hour buckets" you describe in your spec:
^{“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 19, 2017 at 3:55 am

#1951554

RE: Covnert float and update date

juelz3682 - Tuesday, July 18, 2017 9:53 AM

Hello Everyone,

I'm having trouble with converting a column to a date format. This column datatype...

^{“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 18, 2017 at 10:00 am

#1951446

RE: Probability in SQL

Jacob Wilkins - Monday, July 17, 2017 7:15 AM

Also, just as a note, please do not post the same topic multiple times.

You've...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

July 17, 2017 at 9:33 am

#1951196

RE: Max Min With Sum Between

Jacob Wilkins - Monday, July 17, 2017 7:15 AM

Also, just as a note, please do not post the same topic multiple times.

You've...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

July 17, 2017 at 9:32 am

#1951195

RE: Partition by or Row num or Subquery - Assistance

Jacob Wilkins - Monday, July 17, 2017 7:15 AM

Also, just as a note, please do not post the same topic multiple times.

You've...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

July 17, 2017 at 9:32 am

#1951194

RE: Sum when between

Jacob Wilkins - Monday, July 17, 2017 7:15 AM

Also, just as a note, please do not post the same topic multiple times.

You've...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

July 17, 2017 at 9:31 am

#1951193

RE: Partition by or Row num or Subquery - Assistance

Jacob Wilkins - Monday, July 17, 2017 7:15 AM

Also, just as a note, please do not post the same topic multiple times.

You've...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

July 17, 2017 at 9:30 am

#1951190

Viewing 15 posts - 631 through 645 (of 10,143 total)