WayneS

Forum Replies Created

Viewing 15 posts - 5,251 through 5,265 (of 5,588 total)

RE: Are the posted questions getting worse?

Hey Barry... how many more articles do you have planned for your "15 ways to lose your cursor" series, and when would the next one be publishing? It's been too...
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

June 8, 2009 at 9:19 pm

#1006397
RE: convert Float

Krasavita (6/8/2009)
I am exporting float field as 0.006 to the flat file and when I open file the data looks different,what should I do?
Use the STR function with the proper...
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

June 8, 2009 at 9:01 pm

#1006395
RE: Multi-value parameter show all by default

Hi there,
It's been a year since I did this, so I don't remember the exact steps, but you can set up the multi-value checkbox to set the default items 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

June 8, 2009 at 8:50 pm

#1006394
RE: sql text

Profiler.
see this link.
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

June 8, 2009 at 8:47 pm

#1006393
RE: Are the posted questions getting worse?

Lynn Pettis (6/7/2009)
<>
Oh No. I can't read Books Online. SQL Gurus, tell me the answer please.
Yeah, but it appears that he at least read it over some. 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

June 7, 2009 at 7:41 pm

#1005887
RE: Trouble Attaching a Database

I have noticed on my Vista computer that when I want to attach a database, that I need to run SSMS as administrator (right-click on SSMS, select Run As Administrator)....
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

June 7, 2009 at 8:20 am

#1005809
RE: Need to export column headings with stored procedure

siboyd07, I guess the main thing to mention here is that in order to include the column headings, you are going to have to change the way you are running...
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

June 6, 2009 at 9:44 pm

#1005767
RE: Globals!ReportFolder in Call to Custom Function

Duplicate post.
Please post all responses 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

June 6, 2009 at 9:27 pm

#1005766
RE: Are the posted questions getting worse?

lmu92 (6/6/2009)
WayneS (6/6/2009)
You know, it's always those complex T-SQL concepts that trip up so many people.
Good going Gail!
Hi Wayne,
your link doesn't work (double referenced).
Thanks, I fixed 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

June 6, 2009 at 8:24 am

#1005706
RE: Need to export column headings with stored procedure

I came up with a way to accomplish this:
CREATE PROC dbo.BCPOUT AS
declare @header varchar(max),
@details varchar(max),
...
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

June 6, 2009 at 8:14 am

#1005700
RE: converting float to varchar...

Paul White (6/6/2009)
The entry in BOL has always been badly worded and confusing, at least to me.
It goes on to say: "SQL Server treats n as one of two 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

June 6, 2009 at 7:10 am

#1005690
RE: Are the posted questions getting worse?

You know, it's always those complex T-SQL concepts that trip up so many people.
Good going Gail!
Edit: fixed link
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

June 6, 2009 at 7:01 am

#1005688
RE: What SQL Server Sites do you use?

Like Jeff, it's usually reserved to this site. Though simple-talk has some great articles, esp those by Phil Factor.
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

June 6, 2009 at 6:56 am

#1005687
RE: What SQL Server Sites do you use?

Jeff Moden (6/5/2009)
99.99% SQLServerCentral.com - I like folks like you and the others I've come to know and some of the other sites just seem to bloody rude at times.
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

June 6, 2009 at 6:55 am

#1005686
RE: converting float to varchar...

David Burrows (6/5/2009)
I'm not sure why it's being rounded up at the 4th decimal spot (yet)
Because if the number is too big, decimals are sacrificed to make 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

June 5, 2009 at 10:05 pm

#1005626

Viewing 15 posts - 5,251 through 5,265 (of 5,588 total)