ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,196 through 9,210 (of 10,143 total)

RE: Problem on OPENROWSET

Can you see the database ODS in the output generated by this:
SELECT a.* FROM OPENROWSET(
'SQLOLEDB',
'Trusted_Connection=yes;Integrated Security=SSPI;DataSource=''10.0.172.53'';' ,
'SELECT [name] FROM master.dbo.sysdatabases') AS a
^{“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

December 10, 2008 at 4:23 am

#910206
RE: Select columns by ordinal position?

Rootman (12/10/2008)
Thanks for the reply.
But I want to return a specific column, say column 2 from a table.
In other words I want to use the table as a sort 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

December 10, 2008 at 4:12 am

#910201
RE: Select columns by ordinal position?

Rootman (12/10/2008)
Is it possible to select columns by their ordinal position? If so , could anyone please help me with the syntax?
Many thanks
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

December 10, 2008 at 3:54 am

#910194
RE: display Full date values which falls under 2 input date values

sabarichandru (12/10/2008)
Dear all,
i need to display dates as a O/P which falls between two date inputs .
Eg:
input 1 ...
^{“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

December 10, 2008 at 3:50 am

#910193
RE: Improve SQL Query Performance

debjani.bedajana (12/9/2008)
Hi Gail,
Sorry to bother you. Wondering if you could find some solution. Thanks for your help.
Debjani
Hi Debjani
Can you please let us know what the remaining problems are?
^{“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

December 10, 2008 at 3:12 am

#910186
RE: Slow function

pino_daddy (12/9/2008)
This query was a simple example of how we would use the function.
We are aquiring companies around teh world and for UTC we need to have one time zone....
^{“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

December 10, 2008 at 2:56 am

#910179
RE: Replacing multiple occurrences of a string in a text column

Dan Epps (12/9/2008)
Yep...tomorrow's prices with yesterday's technology!
Ironic this...prices are tumbling and yesterday's technology is robust!!
^{“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

December 10, 2008 at 2:32 am

#910168
RE: Slow function

pino_daddy (12/9/2008)
This query:
SELECT ROW_ID, CREATED, dbo.ConvertGMTToEST(CREATED)
FROM S_SRV_REQ S
returns 959,970 rows in 48 seconds
This query:
SELECT ROW_ID, CREATED
FROM S_SRV_REQ S
returns 959,970 rows in 4 seconds
Want to know how to speed up 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

December 9, 2008 at 11:49 am

#909841
RE: Min Max Quartile

Kelvin Phayre (12/9/2008)
I put 1.5m rows into a table and then ran your query. I then stopped the query before it crashed the server.
I then took a different tac. 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

December 9, 2008 at 11:21 am

#909827
RE: Return Values and store those values for evaluation

Hi Joe, I'n not reall sure what's going on there!
Here's a simple test setup, with a sp taking 6 parameters, three of them being output params.
It should be sufficient...
^{“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

December 9, 2008 at 10:55 am

#909811
RE: T-SQL Help

pvar (12/9/2008)
Thanks guys for your quick response. I tried Noeld's solution and it worked, I liked the simplicity of the select statement. But I am not sure about chris's solution,...
^{“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

December 9, 2008 at 10:40 am

#909801
RE: SQL Help

Ian (12/9/2008)
The product table contains a lot of records roughly 2800 and the productCategory table has roughly 3850 - should I include all the date?
No, twenty or so should be...
^{“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

December 9, 2008 at 10:21 am

#909791
RE: T-SQL Help

pvar (12/9/2008)
I am sorry, I should have provided that info. The field type is tinyint so the values are 0 & 1. Thanks.
No problem. This will do:
SELECT * FROM (
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

December 9, 2008 at 10:19 am

#909790
RE: T-SQL Help

pvar (12/9/2008)
Hi,
I have a table with 4 boolean fields. I need to find the records that have more than one boolean field set to true. That means records with A...
^{“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

December 9, 2008 at 10:10 am

#909778
RE: Updating using Execute SQL Task

stricknyn (12/9/2008)
Hi, yes I am only using the listed tables. I'm trying to figure out how to do update with a Execute SQL Task based on how 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

December 9, 2008 at 9:59 am

#909770

Viewing 15 posts - 9,196 through 9,210 (of 10,143 total)