ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,726 through 7,740 (of 10,143 total)

RE: Selecting a certain number of a records from certain types of records

You're getting there, but you need to take another look at your tables, there should be many more than the two listed. I'd guess about 15.
For instance:
Table StationVehicles
StationVehTypeID VehicleTypeStation...
^{“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

June 29, 2010 at 8:51 am

#1186439
RE: Are the posted questions getting worse?

Paul White NZ (6/29/2010)
Too many of the players seem to be to be over-paid, under-talented, whining, cheating prima donnas.
Well said Paul, couldn't agree more.
^{“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

June 29, 2010 at 7:40 am

#1186377
RE: datetime difference and display in years

scottichrosaviakosmos (6/29/2010)
i want to get date difference like a start date and end date and find difference in years but i want like if for example one date is 2007...
^{“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

June 29, 2010 at 7:31 am

#1186360
RE: order by twice

Kingston Dhasian (6/29/2010)
No idea why the OP is getting an error.
Me neither Kingston but it's always nice to have an alternative.
^{“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

June 29, 2010 at 4:29 am

#1186273
RE: order by twice

eng.khiat (6/29/2010)
SELECT * FROM
(
SELECT top 10 * FROM tableX ORDER BY ID DESC
) AS A
ORDER BY A.ID ASC
It gives error and when i 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

June 29, 2010 at 4:08 am

#1186269
RE: Select Distinct

Potso, none of your sample data posts match up with each other, the column names and contents are all over the place, and your query would generate an error if...
^{“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

June 29, 2010 at 3:32 am

#1186258
RE: Duplicate recods using SSIS

Import the contents of the flat file into a staging table in your db. Assume the data is dirty.
Perform any necessary validation against the staging table - including dupe-flagging.
Transfer...
^{“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

June 29, 2010 at 2:51 am

#1186242
RE: i need a query tip

canuzun (6/28/2010)
Thanks for the tip.
Only curious, is it possible to create the second table, from the first one with single query?
Of course. SELECT...INTO...FROM...
Best practice is to check for existence of...
^{“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

June 29, 2010 at 2:28 am

#1186228
RE: Today's Random Word!

Coffindodger
^{“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

June 29, 2010 at 2:23 am

#1186224
RE: check for NULL in a column

priya__ (6/28/2010)
Thanks all for your reply,
I cannot use SUM as I am counting a Key column here and if I use sum it will sum up the columne instead...
I have...
^{“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

June 28, 2010 at 10:04 am

#1185889
RE: check for NULL in a column

Or this way:
;WITH FastAggregate AS (
SELECT , col1, COUNT(*) AS RowCounts
FROM table1
GROUP BY , col1
)
SELECT ,
SUM(CASE WHEN col1 IS NULL THEN RowCounts END) AS 'nullcnt',
SUM(CASE WHEN col1...
^{“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

June 28, 2010 at 8:33 am

#1185794
RE: check for NULL in a column

Gianluca Sartori (6/28/2010)
Sorry for echoing, Gail...
Et tu, Gianluca.
^{“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

June 28, 2010 at 8:08 am

#1185764
RE: check for NULL in a column

The simple CASE uses equivalence: CASE i WHEN NULL is the same as CASE WHEN i = NULL...
To check for NULLS you must use the searched CASE: CASE WHEN...
^{“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

June 28, 2010 at 8:05 am

#1185757
RE: Are the posted questions getting worse?

rjohal-500813 (6/28/2010)
Who'd have thought that the loss of a point would cause such collective bed-wetting
The question reads "What will be the output of the following?" and none of the answers...
^{“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

June 28, 2010 at 7:32 am

#1185730
RE: Check duplicates records while bulk inserting in to Table

mohanaraj (6/28/2010)
...I want to insert the record in to a table using bulk insert method fro that I use the below...
It's good practice to use a staging table...
^{“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

June 28, 2010 at 7:21 am

#1185715

Viewing 15 posts - 7,726 through 7,740 (of 10,143 total)