WayneS

Forum Replies Created

Viewing 15 posts - 4,381 through 4,395 (of 5,588 total)

RE: Are the posted questions getting worse?

Roy Ernest (4/15/2010)
What is the best way to beat writer's block? Anybody have any ideas? I am half way through an article and now I cant seem to complete it....
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

April 15, 2010 at 3:10 pm

#1152470
RE: define composite primary key with more than 900 bytes

bteraberry (4/15/2010)
Manual entry is always a problem, but by extending your constraint over such a large number of fields, the chances of entry errors invalidating the constraint are greatly increased.
Do...
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

April 15, 2010 at 3:08 pm

#1152468
RE: Are the posted questions getting worse?

Lynn Pettis (4/15/2010)
Okay denizens of The Thread, here's a good one!
Jeez. (Where's the shaking head emoticon?) There is a lot to be learned by that one. Yoda? Oh Yoda? where...
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

April 15, 2010 at 3:06 pm

#1152464
RE: How to SELECT a specifc column based on the content of a field of a joined table

Based on the sample data you provided, what are the expected results?
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

April 15, 2010 at 2:53 pm

#1152452
RE: Better Excel Insert procedure?

Jayded (4/15/2010)
Thanks Wayne! In this instance when I'm making the lists do I have to have a consistency that SQL column 2 points to Excel column 3 such that if...
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

April 15, 2010 at 2:42 pm

#1152442
RE: How to tune/speed up a procedure

lmu92 (4/15/2010)
WayneS (4/15/2010)
lmu92 (4/15/2010)
blah blah blah.... Right, Wayne?
uh, sure, jeff :w00t:
You consider my statement as "blah blah blah"? I'm depressed now. :crying:
I just wanted to quote the one part... to...
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

April 15, 2010 at 2:31 pm

#1152437
RE: How to tune/speed up a procedure

lmu92 (4/15/2010)
Side note:
I really enjoy working on this "challenge" for several reasons:
#1 (and most important): You take the code provided as something to start with and modify/improve it to meet...
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

April 15, 2010 at 2:21 pm

#1152432
RE: How to tune/speed up a procedure

gregory.anderson (4/15/2010)
The update of the conversionstatus statement isn't working how I want because it updates ALL of the records even though only 557000 of the 680000 are getting inserted (because...
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

April 15, 2010 at 2:12 pm

#1152425
RE: How to tune/speed up a procedure

lmu92 (4/15/2010)
blah blah blah.... Right, Wayne?
uh, sure, jeff :w00t:
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

April 15, 2010 at 2:05 pm

#1152420
RE: What are the Limitations of having SQL server as a DR server for Oracle 10g database

GSquared (4/15/2010)
I'd replicate from Oracle to Oracle.
I agree.
If your Oracle db is using stored procedures, then you're probably going to have a big issue with this - unless they...
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

April 15, 2010 at 11:31 am

#1152314
RE: Are the posted questions getting worse?

Tom.Thomson (4/15/2010)
Kit G (4/15/2010)
A man and a horse walk into a bar. The bartender says, "Why the long face?"
(Bad Joke #2) 😀
And the horse replied "because the old grey...
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

April 15, 2010 at 11:22 am

#1152305
RE: Better Excel Insert procedure?

Jayded (4/15/2010)
INSERT INTO MAPPINGTABLE
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\Documents and Settings\user\My Documents\Length Adjustments\Mapping\Mapping Table.xls', 'SELECT * FROM [Sheet1$]')
Try:
INSERT INTO MAPPINGTABLE (Col1, Col2, Col3)
SELECT Col1, Col2, Col3
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Documents 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

April 15, 2010 at 10:42 am

#1152291
RE: Maximum Date

The GROUP BY clause goes before the ORDER BY clause.
Edit: You'll also need to add dbo.[IH_RE-TENANCY].[tenancy-ref] to the GROUP BY clause... try it without it and you'll get a new...
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

April 15, 2010 at 10:30 am

#1152280
RE: Moving Databases

Gus, FWIW, I think you have an excellent list of steps to do. Can we get you to update this when you actually do move the databases to include those...
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

April 15, 2010 at 10:22 am

#1152272
RE: SQL Join

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...
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

April 15, 2010 at 10:12 am

#1152266

Viewing 15 posts - 4,381 through 4,395 (of 5,588 total)