ChrisM@Work

Forum Replies Created

Viewing 15 posts - 10,081 through 10,095 (of 10,143 total)

RE: loading of .csv files into sql server

Hi Surya
<<all the values are in single cell of excel csv file>>
Not entirely sure what you mean by this...would it be possible for you to open the csv file in...
^{“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, 2007 at 1:22 am

#718515
RE: Incorrect data brought back

Heh heh good catch, Steve!
Also, Peter's treatment of dates is spot on, there's another current thread where this is "gently tested"
^{“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 10, 2007 at 2:36 pm

#718422
RE: Need help on reseed Identity column - urgent..

Hi
Maybe I'm missing the obvious here...but why don't you use bigint?
From BOL: "The bigint data type is supported where integer values are supported. However, bigint is intended for...
^{“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 10, 2007 at 9:26 am

#718329
RE: Counting specific records from 2 different Tables

Shamshad, both Sorin and Jeff were absolutely correct. You need left joins. Your query didn't work because the aggregates in your query were incorrectly specified.
This will help you: test data...
^{“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 10, 2007 at 7:07 am

#718284
RE: Incorrect data brought back

Hi Imke
You will still need to be careful with this: if the time component of an AlertDate which is the same date as the getdate() date, is before the time...
^{“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 6, 2007 at 6:52 am

#717658
RE: Incorrect data brought back

Hi Imke
It brings back nothing because you're matching on the time component of the datetime, as well as the date component.
Try
DATEDIFF(day, AlertDate, getdate()) > @day
instead of AlertDate > (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

July 6, 2007 at 6:07 am

#717650
RE: Select DISTINCT on multiple columns is not returning distinct rows for very large table??

Hi Dan

Try running the following:
SELECT Latitude, Longitude, count(*) as nRows
FROM RGCcache
Group by Latitude, Longitude
HAVING count(*) > 1

Check that...
^{“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 6, 2007 at 5:59 am

#717649
RE: MSDE Performance

Hi vy
"* Maximum user connections: 5 before the work load governor will limit the performance."
this is from http://www.vialect.net/page25/page37/page37.html
Cheers
ChrisM
^{“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 5, 2007 at 6:38 am

#717355
RE: Independence Day

Well put, David.
While we're here (I hate doing this almost as much as I hate seeing rubbish posted in this forum):
<<from exposure to DU weapons radioactivity>> No Johan, it isn't...
^{“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 4, 2007 at 9:42 am

#717196
RE: Independence Day

Johan, I had a look at the site http://www.st911.org. Not for long, there was an argument about the temperatures which may or may not have been reached within 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

July 4, 2007 at 8:38 am

#717186
RE: Independence Day

Happy Independence Day to us Brits from you Yankees! Heh heh!
Never been sure what we Brits were fighting for in North America all those years ago but I like 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

July 4, 2007 at 7:59 am

#717171
RE: Duplicate entries with unmatching related data
Going with <<I need to get unique address that correspond with the most data>>, this will preferentially pick an ID/address line which joins to non-null MLSNO and agent...
```
DROP TABLE #TableOne
CREATE 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
July 4, 2007 at 7:05 am

#717149
RE: Problem in uploading excel data to SQL Server using SSIS

Hi Mr S
For each column in Excel which has mixed data types, you must import to char or varchar. Force the cell contents to be a text type by preceeding...
^{“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 4, 2007 at 5:10 am

#717123
RE: Select And Count Consecutive Numbers

Yeah me too!
I saw a use for ...
UPDATE #MyHead
SET
@Grp = Grp = 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

July 4, 2007 at 3:30 am

#717099
RE: Linked Server Query with Collate Clause Problem

Someone far more clever than me will explain why you're having problems using a collation directive (?) in a remote query, in the meantime here's a workaround - change 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

July 3, 2007 at 7:24 am

#716868

Viewing 15 posts - 10,081 through 10,095 (of 10,143 total)