WayneS

Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 5,588 total)

RE: Nested Temporary Tables

SQLkiwi (12/20/2010)
This is true (although table variables can also have a primary key and unique non-clustered indexes, albeit without statistical information).
Paul,
I know you know this - this is just be...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 20, 2010 at 1:55 pm

#1264794
RE: Are the posted questions getting worse?

Ray K (12/20/2010)
Celko warning alert
But the OP blasted him right back
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 20, 2010 at 1:07 pm

#1264768
RE: Getting ethnicity information - multiple columns to single column

torpkev (12/20/2010)
I could put a cursor on the table - use variables to hold the ethnicity types and various if statements to get the end value and then do an...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 20, 2010 at 12:59 pm

#1264764
RE: Getting ethnicity information - multiple columns to single column

Something like:
SELECT PersonID,
Ethnicity = CASE WHEN (Expression to determine Caucasion) THEN 'Caucasion'
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 20, 2010 at 10:21 am

#1264707
RE: DateDiff on Consecutive Rows

Wildcat (12/20/2010)
Based on the sample data, what kind result you want to get?
Well, the expected results that you provided are not based on the sample data you provided. (the expected...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 20, 2010 at 10:16 am

#1264703
RE: Are the posted questions getting worse?

Greg Edwards-268690 (12/20/2010)
WayneS (12/19/2010)
WayneS (12/16/2010)
What are your preferences for VM machines - VMWare or VirtualPC?
I've been using VMWare for years (and am happy with it), but to install a 64-bit...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 20, 2010 at 8:43 am

#1264659
RE: Are the posted questions getting worse?

WayneS (12/16/2010)
What are your preferences for VM machines - VMWare or VirtualPC?
I've been using VMWare for years (and am happy with it), but to install a 64-bit Windows 7 and...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 19, 2010 at 8:59 pm

#1264470
RE: Are the posted questions getting worse?

Gianluca Sartori (12/17/2010)
GilaMonster (12/17/2010)
CirquedeSQLeil (12/17/2010)
I see an x86 and amd64 version. Too bad they don't have an intel 64 bit version.
The x64 processor architecture is sometimes known as AMD64...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 17, 2010 at 2:43 pm

#1264270
RE: Under Appreciated Features

Charles Kincaid (12/17/2010)
I did not know that you could put a CTE in a view. I tried it and it worked. Seems reasonable given what a view actually...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 17, 2010 at 9:27 am

#1264132
RE: Deadlock Question

The actual code being run is:
(Deadlock victim)
From procedure: DB.dbo.proc_AddWorkflow
IF (@Configuration & (128 | 1024 | 512)) = 0 AND
((@Configuration & 256) <> 0 OR
NOT EXISTS (SELECT
*
FROM
dbo.Workflow
WHERE
SiteId = @SiteId AND
ListId =...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 17, 2010 at 9:03 am

#1264116
RE: Need SQL Query to get latest CurrencyRate

This should give you an idea for how to do this.
If this doesn't work, please follow the advice given by Gianluca.
-- See how you start off by actually creating a...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 17, 2010 at 8:40 am

#1264105
RE: date comparison issue with < and <= operator

This code:
SET NOCOUNT ON;
DECLARE @test-2 TABLE (Name char(5), createdate datetime);
INSERT INTO @test-2
SELECT 'Test1', '12/01/2010' UNION ALL
SELECT 'Test2', '12/02/2010' UNION ALL
SELECT 'Test3', '12/03/2010' UNION ALL
SELECT 'Test4', '12/04/2010' UNION ALL
SELECT 'Test5', '12/05/2010';
SELECT...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 17, 2010 at 8:13 am

#1264086
RE: Series of INSERT INTO queries, only the first one works

It sounds to me like the either the PK or a UNIQUE constraint is firing. The first runs fine because there are no duplicates; the second+ fails because of a...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 17, 2010 at 8:05 am

#1264080
RE: Deadlock Question

If you post your deadlock graph, we can probably help you figure it out.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 17, 2010 at 8:00 am

#1264074
RE: Under Appreciated Features

fthiemonge (12/17/2010)
I'm a big fan of making my own templates in the template explorer. Not many people in my office use them but they are a huge help getting you...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 17, 2010 at 7:57 am

#1264071

Viewing 15 posts - 2,086 through 2,100 (of 5,588 total)