ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,926 through 8,940 (of 10,143 total)

RE: How to retrieve 2nd value of a user defined column in database

There are several ways of doing this. Can you explain a little more about the problem? For instance, how often do you want to do this? How large are the...
^{“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

January 9, 2009 at 4:01 am

#924030
RE: Insert scripts takes so much time ? Any alternative.

Performance will improve using UNION ALL, as you mention in your first post. Of course, always test first.
^{“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

January 9, 2009 at 3:50 am

#924024
RE: Select Statement

SELECT your column-delimited list of columns here
FROM yourtable
There isn't an easy way to do this, Lee. It can be done by gathering the column list for your table from syscolumns...
^{“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

January 9, 2009 at 3:47 am

#924022
RE: How to populate 1 row multi field from 3 rows single field

Hi Eddy, thanks for your kind words.
As for there was nothing faster than index seeks - in this case it's difficult to compare the original query with the new...
^{“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

January 9, 2009 at 2:38 am

#923990
RE: Grouping rows together

This should fix the problem - but without any data to test against, it's hard to tell..
[font="Courier New"]SELECT DISTINCT b.BranchName + ', ' + CONVERT(VARCHAR, na.WeekEndingDate, 101) AS [Member Firm],...
^{“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

January 9, 2009 at 2:29 am

#923984
RE: Datediff not calculating corectly

RBarryYoung (1/8/2009)
OK, I checked and yes, "YYYY-MM-DD" is the ISO 8601 standard for "unambiguous numerical text date format". (see here: http://www.uic.edu/depts/accc/software/isodates/index.html).
Also, as to the representation of date constants, here 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

January 8, 2009 at 3:13 pm

#923761
RE: Datediff not calculating corectly

stricknyn (1/8/2009)
Hello everyone,
Ok this is weird. When I run the statement below it is returning 1. Can someone explain to me why this is returning 1?
select datediff(year, '2008-01-09...
^{“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

January 8, 2009 at 2:20 pm

#923710
RE: writing function fordate

rosyshrestha7 (1/8/2009)
Timclosestatus is column name come from table
Come from table how? Please post the entire stored procedure.
^{“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

January 8, 2009 at 12:49 pm

#923644
RE: Missing data rows?

RBarryYoung (1/8/2009)
Chris Morris (1/8/2009)
The last statement is a SELECT * from the table it builds.
Does this statement have the locking hint NOLOCK?
Heh, that was going to be my next question...
^{“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

January 8, 2009 at 10:15 am

#923503
RE: Missing data rows?

The last statement is a SELECT * from the table it builds.
Does this statement have the locking hint NOLOCK?
^{“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

January 8, 2009 at 10:07 am

#923492
RE: Update Date Field

rsteeves (1/8/2009)
I need to update a date field for all records in a table to change the year from 2008 to 2009. I have tried thsi SQL with no success...
^{“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

January 8, 2009 at 9:56 am

#923478
RE: Adding running number on groups of records in a table

Garadin (1/8/2009)
Chris Morris (1/8/2009)
Garadin (1/8/2009)
Think I just found a fitting avatar for myself for that matter.
Isn't that Muffin?
My turn to Google! Never heard of Muffin the Mule before... but...
^{“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

January 8, 2009 at 9:24 am

#923448
RE: Adding running number on groups of records in a table

Garadin (1/8/2009)
The joke doesn't make nearly as much sense if you haven't seen the movie. The butler in the movie is "very sneaky", and keeps appearing randomly whenever he's...
^{“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

January 8, 2009 at 9:19 am

#923442
RE: Adding running number on groups of records in a table

Lynn Pettis (1/8/2009)
hmmm, avatar I too have found
Gits unite old, yes!
^{“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

January 8, 2009 at 9:15 am

#923435
RE: Adding running number on groups of records in a table

Garadin (1/8/2009)
Think I just found a fitting avatar for myself for that matter.
Isn't that Muffin?
^{“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

January 8, 2009 at 9:10 am

#923423

Viewing 15 posts - 8,926 through 8,940 (of 10,143 total)