WayneS

Forum Replies Created

Viewing 15 posts - 4,891 through 4,905 (of 5,588 total)

RE: parse comma-delimited list into seperate columns

lmu92 (1/11/2010)
It's always awesome to see the alternatives being shared on this community! By no means I'm going to disrespect Wanes solution! Not at all!! It's just interesting that there...
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

January 11, 2010 at 5:46 pm

#1102118
RE: parse comma-delimited list into seperate columns

vstitte (1/11/2010)
Wayne, Cool script.
BUT in the final Select statement, did you mean to use column names instead of the variables?
WHOOPS! You are exactly right about that! Good catch. I have...
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

January 11, 2010 at 5:37 pm

#1102117
RE: parse comma-delimited list into seperate columns

CirquedeSQLeil (1/11/2010)
WayneS (1/11/2010)
Well, the concept comes from Jeff. 'nuf said. 😉
Heh, started testing it after my last post. Still need to look at exec plans. From 2 records...
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

January 11, 2010 at 3:05 pm

#1102075
RE: parse comma-delimited list into seperate columns

Well, the concept comes from Jeff. 'nuf said. 😉
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

January 11, 2010 at 2:46 pm

#1102069
RE: parse comma-delimited list into seperate columns

Try this.
-- if temp table already exists (failed previous run), drop it
if OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE #test
-- simulate the table with the data in it.
-- NOTE how your...
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

January 11, 2010 at 2:42 pm

#1102065
RE: Is there a system procedure that lists what stored procedure(s) call a specific one?

Thanks Gus.
I saw that, and I'm sure that I fixed it before posting.... 😉
Can I blame in on the way things get quoted 'round here?
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

January 11, 2010 at 2:07 pm

#1102049
RE: importing tab delimited file with various line length

... and PATINDEX.
You might want to check out the article by Phil Factor on http://www.simple-talk.com dealing with the "quirky update". It shows an excellent example of splitting up a line...
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

January 11, 2010 at 2:04 pm

#1102047
RE: importing tab delimited file with various line length

rnikandrov (1/11/2010)
Thank you for your suggestion,
the plan is to:
#1 import file into single array
#2 parse the right line into temp table, so that i can work with it
can 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

January 11, 2010 at 11:00 am

#1101946
RE: Is there a system procedure that lists what stored procedure(s) call a specific one?

This might help you out.
declare @proc sysname
set @proc = '<Your Procedure Name here>'
SELECT schema_name(sp.schema_id) [Schema], object_name(sasm.object_id) [Procedure]
FROM sys.all_sql_modules sasm
INNER JOIN sys.procedures...
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

January 11, 2010 at 10:45 am

#1101936
RE: Women in Technology

Manic Star (1/6/2010)
Lynn Pettis (1/6/2010)
Jen, based on what I have read, I'd enjoy the opportunity to work with you.
You'd be welcome here too 🙂
Maybe I'm chiming in maybe a 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

January 6, 2010 at 6:47 pm

#1099991
RE: Using SSIS to zip files and email the zipped files

clive-421796 (1/1/2010)
How can I automate this so that I dont have to edit the Script Task every day and specify the date of previous days files to include, in 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

January 4, 2010 at 1:08 pm

#1098603
RE: Are the posted questions getting worse?

Anyone that wants to review an article of fixing Msg 8992 DBCC CHECKDB errors after upgrading from sql 2000, please PM me with how to send it to you. It's...
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 29, 2009 at 3:03 pm

#1097255
RE: Are the posted questions getting worse?

Jack Corbett (12/29/2009)
My commute is about 3 minutes by foot. It would take me longer to drive. 😛
Guess who to call after hours? 😀
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 29, 2009 at 3:00 pm

#1097252
RE: Are the posted questions getting worse?

Lynn Pettis (12/29/2009)
Congrats Gus. How about sending some of that good luck my way. Can't seem to catch a break at all.
Kassondra was in a car accident Sunday...
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 29, 2009 at 11:05 am

#1097147
RE: Are the posted questions getting worse?

GSquared (12/29/2009)
For anyone here a month or so ago, I have good news on the employment front. Starting a new job with a much better company in mid-Jan. ...
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 29, 2009 at 11:03 am

#1097144

Viewing 15 posts - 4,891 through 4,905 (of 5,588 total)