ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,641 through 8,655 (of 10,143 total)

RE: Update int field with Datediff in subquery?

dji (3/26/2009)
Blimey! That looks impressive.
I have copied the code and will have a play around as I really do need to get on top of T-SQL instead of writing apps...
^{“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

March 26, 2009 at 5:41 am

#966547
RE: Update int field with Datediff in subquery?

Here's a simple way of doing it:-- set up some sample data
DROP TABLE #MstHorse
CREATE TABLE #MstHorse (HorseID INT, HorseName VARCHAR(30))
INSERT INTO #MstHorse (HorseID, HorseName)
SELECT 1, 'Red Rum' UNION ALL
SELECT 2,...
^{“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

March 26, 2009 at 5:31 am

#966535
RE: top - 1 ROW !

Here's the old-fashioned way:
DROP TABLE #temp
CREATE TABLE #temp ([pk id] INT, numero INT, statut INT, majdate DATETIME)
INSERT INTO #temp
([pk id], numero, statut, majdate)
SELECT 2480, 202, 0, '2009-03-26 08:15:55.00' UNION ALL
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

March 26, 2009 at 4:19 am

#966506
RE: Openrowset Error

Some of your commas are a little random. Try the first query, if this works, try the second.
SELECT *
FROM OPENROWSET('SQLNCLI',
'Server= anyserver;Trusted_Connection=yes; Initial Catalog=anydb',
'SELECT GETDATE()')
SELECT *
FROM OPENROWSET('SQLNCLI',
'Server= anyserver;Trusted_Connection=yes; Initial...
^{“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

March 26, 2009 at 4:09 am

#966500
RE: Automatically change LOWER to UPPER

Why not do this client-side? It's formatting, after all.
^{“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

March 26, 2009 at 3:41 am

#966494
RE: Long running queries when using DISTINCT with Strings

musab (3/26/2009)
Hi !
I am using data type nvarchar(max) and have 13 million records and want to get unique records out of it based on the text.
but the query...
^{“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

March 26, 2009 at 3:35 am

#966491
RE: top - 1 ROW !

christophe.bernard (3/26/2009)
pk id numero ...
^{“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

March 26, 2009 at 3:31 am

#966488
RE: Large Data Set Returns Faster Than Small?

Can you post the code for the procedure please?
^{“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

March 25, 2009 at 6:52 am

#965949
RE: Are the posted questions getting worse?

Kit G (3/24/2009)
Yeah, I have to agree with Bob. I'm new to SQL and CR's help didn't make much sense to me. Had it been me getting 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

March 25, 2009 at 1:48 am

#965832
RE: SQL GROUP statement

munderhill73525 (3/24/2009)
The "root" of my problem is the assignment itself. It specifically states to use GROUP BY statements to accomplish the scenarios which in turn has me TOTALLY confused!!...
^{“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

March 24, 2009 at 8:22 am

#965238
RE: Are the posted questions getting worse?

Lynn Pettis (3/24/2009)
Is it me or are the people we are trying to help just getting dumber, or do we need to start commenting are code a lot more heavily?
Hell...
^{“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

March 24, 2009 at 8:16 am

#965229
RE: Are the posted questions getting worse?

Kit G (3/24/2009)
Roy Ernest (3/24/2009)
I guess I am the shortest here...:-) I am just 5'6". 😀
The chance of meeting anyone from THE THREAD is very remote for me since 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

March 24, 2009 at 8:09 am

#965218
RE: SQL GROUP statement

It seems you're confusing "group the employees together by some attribute" (which you would achieve with ORDER BY) with sql GROUP BY, which is something quite different - usually used...
^{“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

March 24, 2009 at 8:06 am

#965213
RE: SQL GROUP statement

Select Last_name,Salary,EE01_Classification
FROM Employees
WHERE Salary IN (SELECT Salary
FROM Employees
GROUP BY EE01_Classification,Salary)
ORDER BY EE01_Classification;
This means:
Select Last_name,Salary,EE01_Classification
FROM Employees
WHERE Salary IN (all employee salaries)
ORDER BY EE01_Classification;
Which is the same as:
Select Last_name,Salary,EE01_Classification
FROM Employees
WHERE 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

March 24, 2009 at 7:42 am

#965177
RE: deleting some rows leaving one.

foxjazz (3/23/2009)
problem with this is the last subquery seems to take forever on the server.
Take a look at the code posted above, and work it as setbased. Should be simple...
^{“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

March 23, 2009 at 11:28 am

#964622

Viewing 15 posts - 8,641 through 8,655 (of 10,143 total)