WayneS

Forum Replies Created

Viewing 15 posts - 706 through 720 (of 5,588 total)

RE: Are the posted questions getting worse?

Koen Verbeeck (11/28/2012)
At a SQL Server conference I was speaking at two weeks ago, I met one of the co-founders of lessthandot.com/[/url]. Later that day he asked me if I...
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

November 28, 2012 at 7:01 pm

#1563536
RE: Are the posted questions getting worse?

For those that are observing the USA holiday of Thanksgiving - enjoy your day (or 2) off. If traveling, be safe.
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

November 21, 2012 at 9:00 pm

#1561455
RE: Are the posted questions getting worse?

Revenant (11/21/2012)
SQLRNNR (11/21/2012)
Man, where did you get this picture? Bascule is all wrong - it would not swing. And where are the belts to tie the condemned SQL 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

November 21, 2012 at 8:58 pm

#1561454
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (11/18/2012)
Leaving for a week in the mountains. Y'all behave.
No can do. We're wired against that.
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

November 18, 2012 at 10:00 pm

#1560160
RE: Are the posted questions getting worse?

<sigh>
First day back at work after a wonderful week at Summit. Very happy to have run into several regulars here, and to have met Bob and Paul for the first...
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

November 12, 2012 at 6:26 am

#1558145
RE: What Do You Want from SQL in the City?

Something that I'd like to see more of (PASS, SQL Saturdays, and SQL In The city) is more hands-on training, in a lab type environment, where people can do things...
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

November 9, 2012 at 11:26 pm

#1557883
RE: Are the posted questions getting worse?

GilaMonster (10/30/2012)
WayneS (10/30/2012)
Gail, when do you start your trip, and how has the flight cancellations in the NE USA affected it?
Friday and probably not at all, the flight path goes...
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

October 30, 2012 at 5:44 pm

#1554433
RE: Creating a comma-separated list (SQL Spackle)

So, what you are looking for is:
Col1, comma-separated list of Column 2 (in order)
Col1 should only be there once.
Col2 is an integer, and should be sorted by it's value.
Is this...
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

October 30, 2012 at 12:36 pm

#1554326
RE: Creating a comma-separated list (SQL Spackle)

chris.westgate (10/30/2012)
Great solution Wayne, thank you...
But for me, here's a tiny spanner in the works.
The column that I need to produce a delimited list from is an int column -...
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

October 30, 2012 at 8:58 am

#1554211
RE: Are the posted questions getting worse?

Gail, when do you start your trip, and how has the flight cancellations in the NE USA affected 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

October 30, 2012 at 7:04 am

#1554136
RE: Are the posted questions getting worse?

Geez Tom, that's quite a bit of stuff you went through - hope I never have to do something like this. Sure am glad that you got it all fixed.
Long...
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

October 29, 2012 at 8:31 am

#1553740
RE: Creating a comma-separated list (SQL Spackle)

COTS... say no more. I feel your pain.
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

October 26, 2012 at 3:06 pm

#1553417
RE: Creating a comma-separated list (SQL Spackle)

That's great Ed!
... but 1 second is kinda slow for this method on 10,000 rows
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

October 26, 2012 at 1:09 pm

#1553360
RE: Are the posted questions getting worse?

Anyone still alive out here? 3 days with no comments... that has to be a record for The Thread.
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

October 25, 2012 at 6:29 pm

#1552991
RE: Duplicate Foreign Key

table can contain unlimited number of duplicate foreign keys, though the recommended maximum is 253
So, we're now recommending building duplicate foreign keys?
Personally, I thought that this is essentially 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

October 23, 2012 at 7:21 am

#1551885

Viewing 15 posts - 706 through 720 (of 5,588 total)