WayneS

Forum Replies Created

Viewing 15 posts - 4,576 through 4,590 (of 5,588 total)

RE: Add a set number to each group of records in a table

It's difficult to understand what your data is. Can you provide the data in the form of create table statements, and populate that table with your sample data in the...
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

March 30, 2010 at 10:59 am

#1142467
RE: Trying to JOIN

Norm,
If what Lowell suggests doesn't help you out, they you are going to have to help us help you. Please read the first link in my signature, and provide table...
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

March 30, 2010 at 10:55 am

#1142464
RE: The Missing Certification

Lynn Pettis (3/30/2010)
Something you just mentioned could be used to help this along, SQLSaturday. These venues could also be used to host sessions for certification purposes, as well as...
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

March 30, 2010 at 8:25 am

#1142256
RE: The Missing Certification

Lynn Pettis (3/29/2010)
Restricting the panel to just 4 specific individuals, however, could make getting the cert more difficult. As Grant indicated, this one should be attainable internationally without having...
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

March 30, 2010 at 8:13 am

#1142233
RE: The Missing Certification

dma-669038 (3/29/2010)
...found ... to be an MVP whose title was revoked in 2007.
Okay, I did a little bit of a search to find lists of revoked MVPs. Where do 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

March 29, 2010 at 10:09 pm

#1141938
RE: Are the posted questions getting worse?

CirquedeSQLeil (3/29/2010)
I am glad I persisted. The comments are a ton better now and it is making a lot more sense. Thus making the discussion profitable.
I was slightly...
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

March 29, 2010 at 8:39 pm

#1141910
RE: Are the posted questions getting worse?

CirquedeSQLeil (3/29/2010)
WayneS (3/29/2010)
CirquedeSQLeil (3/29/2010)
Thanks guys. You gave her the idea to ignore, and now she is ignoring me. :crying:
Aww, isn't Jason the lucky one? Do you think it's possible...
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

March 29, 2010 at 7:18 pm

#1141875
RE: The Missing Certification

Gift Peddie (3/29/2010)
I find your arrogance appalling. You refuse to say anything about yourself, but want to know our MCP # (note: it's a MCP #, not a MCITP #)....
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

March 29, 2010 at 5:18 pm

#1141827
RE: Are the posted questions getting worse?

CirquedeSQLeil (3/29/2010)
Thanks guys. You gave her the idea to ignore, and now she is ignoring me. :crying:
Aww, isn't Jason the lucky one? Do you think it's possible to tap...
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

March 29, 2010 at 5:17 pm

#1141825
RE: The Missing Certification

Michael Meierruth (3/28/2010)
Gift Peddie (3/26/2010)
If you did not see it I left out condescending. Now have a nice day.
Gift Peddie,
Above is the last thing you said.
I have read 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

March 29, 2010 at 4:08 pm

#1141793
RE: Are the posted questions getting worse?

john.arnott (3/29/2010)
...I would think it entirely appropriate to ignore any of her further attempts to stir things up.
I'm very much in agreement with you John. I think that everyone needs...
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

March 29, 2010 at 3:50 pm

#1141779
RE: Are the posted questions getting worse?

CirquedeSQLeil (3/29/2010)
ARRRRRRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
HHHHH...
So Jason, anything special happening with you today? :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

March 29, 2010 at 2:42 pm

#1141729
RE: Split column values into multiple rows using sql

mlak (3/29/2010)
NA
And your question is?
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

March 29, 2010 at 1:22 pm

#1141666
RE: Parse field with Numeric ranges and comma deliminated values

Paul White NZ (3/27/2010)
The article I wrote on APPLY is in the queue for publication.
I'm ready for it! Judging solely by some of the posts where you have utilized 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

March 28, 2010 at 11:40 am

#1141117
RE: Parse field with Numeric ranges and comma deliminated values

steve-893342 (3/27/2010)
Sorry folks, can't leave this one alone. I have come up with another variation, which like Wayne's, uses the TALLY table to do both the split 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

March 27, 2010 at 10:38 pm

#1141027

Viewing 15 posts - 4,576 through 4,590 (of 5,588 total)