Viewing 15 posts - 8,851 through 8,865 (of 10,144 total)
Thanks...also the view limit_set_view please.
Views of views can be performance hogs. Others have pointed out the correlated subqueries - they may not be much of a problem however combining the...
February 2, 2009 at 5:39 am
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...
February 2, 2009 at 4:10 am
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?
February 2, 2009 at 3:50 am
Please can you post the structure of the view test_result_view?
February 2, 2009 at 3:46 am
How about setting up some sample data for folks to test against?
Cheers
ChrisM
February 2, 2009 at 1:35 am
Philip Horan (1/31/2009)
January 31, 2009 at 3:46 am
Jeff Moden (1/30/2009)
January 30, 2009 at 9:29 am
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...
January 30, 2009 at 9:14 am
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...
January 30, 2009 at 9:03 am
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
...
January 30, 2009 at 8:08 am
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...
January 30, 2009 at 7:18 am
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 ...
January 30, 2009 at 4:59 am
I can see three WHERE's and only one FROM. You can only have one WHERE per FROM.
SELECT...
FROM...
WHERE...
January 29, 2009 at 2:25 pm
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...
January 29, 2009 at 7:29 am
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!! 😛
January 29, 2009 at 7:15 am
Viewing 15 posts - 8,851 through 8,865 (of 10,144 total)