WayneS

Forum Replies Created

Viewing 15 posts - 1,681 through 1,695 (of 5,588 total)

RE: T-SQL Help

Jeff Moden (3/16/2011)
The most recent code offered by Wayne S works exactly the way you want it to. Try it.
Jeff, I think that you're replying to the message just...
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 16, 2011 at 7:51 am

#1299375
RE: Are the posted questions getting worse?

GilaMonster (3/15/2011)
WayneS (3/15/2011)
So Gail - how did your presentation go? I'm sorry that I couldn't see it.
Awesome. Great fun. Timing went perfectly too (for once)
Trying to figure if I managed...
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 15, 2011 at 9:59 pm

#1299203
RE: Are the posted questions getting worse?

So Gail - how did your presentation go? I'm sorry that I couldn't see 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 15, 2011 at 4:00 pm

#1299155
RE: String

jude-32296 (3/15/2011)
Also, if you know of a good way to get references that cross databases, I would appreciate any suggestions.
thx
I'm not sure what you mean by this... can you elaborate...
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 15, 2011 at 3:55 pm

#1299153
RE: String

I think you are going to have to look for it with the PATINDEX function - specify " %.%.%" as the pattern. This will return the position where the space...
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 15, 2011 at 3:55 pm

#1299152
RE: String

jude-32296 (3/15/2011)
thanx. When i do a like statment it brings back the entire string, which I know is correct. What I am hoping to do is just pull...
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 15, 2011 at 11:30 am

#1299016
RE: Are the posted questions getting worse?

Craig Farrell (3/15/2011)
WayneS (3/15/2011)
Steve Jones - SSC Editor (3/15/2011)
Just a reminder, 24 hours of PASS, the Women's edition, is going on today.
http://www.sqlpass.org/24hours/spring2011/SessionsbySchedule.aspx
Interesting... I only recognize the names of five...
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 15, 2011 at 11:24 am

#1299013
RE: Are the posted questions getting worse?

GilaMonster (3/15/2011)
WayneS (3/15/2011)
Does anyone know if we'll be able to download them later on?
Streaming, not download. Something an issue with but PASS doesn't seem to be willing to change
Darn. Yours...
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 15, 2011 at 11:24 am

#1299010
RE: Excel import - force column to be string (SSIS 2005)

About the only way to do that with the JET engine is to have some alpha characters in that field in the first few records. I agree, this is 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

March 15, 2011 at 11:17 am

#1299006
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (3/15/2011)
Just a reminder, 24 hours of PASS, the Women's edition, is going on today.
http://www.sqlpass.org/24hours/spring2011/SessionsbySchedule.aspx
Interesting... I only recognize the names of five of the speakers...
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 15, 2011 at 11:04 am

#1298997
RE: clustered index

Steve Jones - SSC Editor (3/15/2011)
Keep in mind that this key is in EVERY nonclustered index, so you don't want it narrow.
Actually (and I believe you meant to say 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 15, 2011 at 10:51 am

#1298985
RE: Help me in understanding this

Take the current day (of the month) and add 100 to it.
Then, starting at the second character, take two characters.
It looks to me like they are trying to get 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

March 15, 2011 at 10:44 am

#1298981
RE: T-SQL Help

MattW2010 (3/15/2011)
I actually already got feedback from the biz and that's exactly what they were looking for!
😎
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 15, 2011 at 10:40 am

#1298975
RE: SP- Performance improvement

You might want to look at the two articles by R Barry Young[/url] on "15 Ways to Lose Your Cursor".
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 15, 2011 at 10:34 am

#1298971
RE: T-SQL Help

Thanks for the feedback Matt. To be fair, you actually did get most of the way there yourself. Do you have any questions about 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 15, 2011 at 10:31 am

#1298969

Viewing 15 posts - 1,681 through 1,695 (of 5,588 total)