ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,851 through 8,865 (of 10,143 total)

RE: importing from excel

Since data imported from Excel almost always requires tweaking, it makes sense to import it into a staging table where it can be manipulated in isolation from the rest 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

February 2, 2009 at 4:10 am

#936321
RE: how to access whole row in a cursor

Can you post all or part of the code which you are currently attempting to use, with an explanation of what you are trying to achieve?
^{“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

February 2, 2009 at 3:50 am

#936313
RE: POOR QUERY PERFORMANCE

Please can you post the structure of the view test_result_view?
^{“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

February 2, 2009 at 3:46 am

#936312
RE: Looping in select query

How about setting up some sample data for folks to test against?
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

February 2, 2009 at 1:35 am

#936279
RE: CASE ISNULL

Philip Horan (1/31/2009)
Chris my code runs without error? What can I do to help? Let me explain further. The user may enter multiple custom fields on the app screens (SalesOrders...
^{“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 31, 2009 at 3:46 am

#935974
RE: Are the posted questions getting worse?

Jeff Moden (1/30/2009)
Sounds like a lot of fun but, consider this, would you like it if your post and name showed up on a "Twit List". Bad enough they...
^{“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 30, 2009 at 9:29 am

#935657
RE: 'Conditional aggregate'

Ramesh (1/30/2009)
Chris Morris (1/30/2009)
simonjw83 (1/30/2009)
Of course !! Thanks Ramesh. My excuse is it's late Friday afternoon in London - long day !!
Not only is it late afternoon, it's friday...
^{“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 30, 2009 at 9:14 am

#935643
RE: 'Conditional aggregate'

simonjw83 (1/30/2009)
Of course !! Thanks Ramesh. My excuse is it's late Friday afternoon in London - long day !!
Not only is it late afternoon, it's friday and it's almost...
^{“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 30, 2009 at 9:03 am

#935632
RE: Stored proc to count rows in a table based on a foreigh key different values

Surprisingly, no:
DROP TABLE #TableA
CREATE TABLE #TableA (idstatus INT)
INSERT INTO #TableA (idstatus)
SELECT TOP 500000 CAST(LEFT(number, 1) AS INT)
FROM dbo.Numbers
WHERE CAST(LEFT(number, 1) AS INT) < 7
ORDER BY NEWID()
----------------------------------------------------------------------------
-- Lowell's
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

January 30, 2009 at 8:08 am

#935572
RE: CASE ISNULL

Hi Philip
The code you posted doesn't run, it generates the error message:
'Msg 8124, Level 16, State 1, Line 38
Multiple columns are specified in an aggregated expression containing an outer...
^{“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 30, 2009 at 7:18 am

#935521
RE: Need Help!!!!! - Data manipulation

Try this...
DROP TABLE #Temp
CREATE TABLE #Temp (Users VARCHAR(10), [DateTime] DATETIME, Sections VARCHAR(1), Title VARCHAR(1))
INSERT INTO #Temp (Users, [DateTime], Sections, Title)
SELECT 'Client1', '2009-01-30 08:00 AM', 'I', 'A' UNION 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

January 30, 2009 at 4:59 am

#935406
RE: CASE ISNULL

I can see three WHERE's and only one FROM. You can only have one WHERE per FROM.
SELECT...
FROM...
WHERE...
^{“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 29, 2009 at 2:25 pm

#935082
RE: Are the posted questions getting worse?

Greg Edwards (1/29/2009)
The Thread (1/29/2009)
We do not know fear or pain or mercy. We will not stop. Ever.
So when The Thread gets a 100 posts or so, does...
^{“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 29, 2009 at 7:29 am

#934664
RE: Are the posted questions getting worse?

The Thread (1/29/2009)
We do not know fear or pain or mercy. We will not stop. Ever.
Hah! Prepare to meet...CARDINAL SCISSORHANDS!! 😛
^{“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 29, 2009 at 7:15 am

#934647
RE: Strange Error !!!!!!!!!

You have a statement in there for printing the SQL string
print @lstr
Have a look at the statement it generates. You will see that there are quotes missing.
^{“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 29, 2009 at 5:33 am

#934544

Viewing 15 posts - 8,851 through 8,865 (of 10,143 total)