WayneS

Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 5,588 total)

RE: From SP to Excel

You'll probably need to play around with the Access 2010 64-bit driver then, which seems to be the Jet driver replacement.
I haven't had a chance to work with this myself,...
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

September 29, 2010 at 11:46 am

#1229235
RE: keywords in column names

Enclose the keyword in brackets: [Year]
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

September 29, 2010 at 11:38 am

#1229230
RE: Are the posted questions getting worse?

Brandie Tarvin (9/29/2010)
Or make him do documentation.
Brandie, I never realized that you hated fellow humans so much... :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

September 29, 2010 at 11:34 am

#1229228
RE: From SP to Excel

Jeffery Williams (9/29/2010)
Wayne,
Thank you so much for your reply. Ok I am not using the OpenDataSource method...
NOW... A simple way to accomplish what I need here (just thinking...
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

September 29, 2010 at 11:09 am

#1229219
RE: MSDB over 77 GB

job history. backup history (I think). they add up
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

September 29, 2010 at 9:24 am

#1229143
RE: Replace Function. Replace comma and all value after comma with Nothing

Debbie Edwards (9/29/2010)
IT WORKED!! 🙂
And I have a much better handle on how it does what it does.
Thanks everyone!
(geez, that sounds like you doubted us!)
No problem. Glad to help, 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

September 29, 2010 at 9:22 am

#1229141
RE: From SP to Excel

Jeffrey,
If you're doing this from a SP, then I assume that you're using the OpenDataSource xp to put the data in?
If so, then you will need to specify the column/row...
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

September 29, 2010 at 9:19 am

#1229138
RE: Replace Function. Replace comma and all value after comma with Nothing

You're not using the where clause to not return the rows without commas. This ends up providing a -1 to the LEFT function (which goes to the SUBSTRING function), which...
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

September 29, 2010 at 8:54 am

#1229112
RE: Querying For A List Columns In All Tables

Ronnie Jones (9/29/2010)
Wayne - Thank you for the query. It works great. I plan to research the "FOR XML PATH" statement just to see the use of it. One way...
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

September 29, 2010 at 8:28 am

#1229077
RE: convert string in a line feed with repeat characters into array

Whoops, I thought this was a SQL Server question. Sorry about that.
I don't know Access enough to give a suggestion on how to do it from 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

September 29, 2010 at 8:20 am

#1229063
RE: Replace Function. Replace comma and all value after comma with Nothing

Debbie Edwards (9/29/2010)
Hi,
Say I have the following field in a table (1 field there is a comma in the field 'Name')
Name
Support Centres , Miscellaneous SC
Support Centres , Care of tracey...
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

September 29, 2010 at 8:18 am

#1229061
RE: Msg 8152, Level 16 Error

Either you have an invalid date specification in the insert, or what is there is a different format than what sql is expecting. I see that your date is in...
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

September 29, 2010 at 8:16 am

#1229056
RE: Convert notes data to sql table usage

So you want to break apart this delimited string (with the ; being the delimiter) into separate fields? If I'm understanding this correctly, click here for the latest Delimited Split...
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

September 29, 2010 at 8:09 am

#1229045
RE: convert string in a line feed with repeat characters into array

I think I would try replacing "ZB5|" with char(7) + "ZB5|". Then utilize the delimited split function to split this, using char(7) as the delimiter. (Feel free to use any...
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

September 29, 2010 at 7:49 am

#1229022
RE: Cluster Failover notification

Set up a job to run. For the schedule, set it to be when SQL Server Agent starts. For the step, have it email you. I include ServerProperty('ComputerNetBiosName') (or something...
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

September 28, 2010 at 5:32 pm

#1228721

Viewing 15 posts - 3,076 through 3,090 (of 5,588 total)