WayneS

Forum Replies Created

Viewing 15 posts - 5,266 through 5,280 (of 5,588 total)

RE: Are the posted questions getting worse?

Lynn Pettis (6/5/2009)
Here is another OMG moment.
Lynn, I see yet once again why we refer to you as Saint.
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 5:24 pm

#1005591
RE: converting float to varchar...

This gets you closer, though some decimals are still lost.
if object_id('tempdb..#d') is not null drop table #d
create table #d (column3 varchar(255))
declare @var float
set @var = 654646548463.41646646
insert into #d
select 'column-Headding'...
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 5:42 am

#1005172
RE: Passing in lists to SQL 2005 parameters, is there a better approach?

Jackal (6/5/2009)
Can ignore that now, manged to resolve it using;
i.item.value('(*[local-name()=sql:variable("@searchelement")])[1]','nvarchar(15)')
Thanks.
Now that promises to be a useful trick that I haven't seen before. Thanks for sharing 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 5:27 am

#1005165
RE: Passing in lists to SQL 2005 parameters, is there a better approach?

Bruce W Cassidy (6/4/2009)
[font="Verdana"]I'd go for passing in the list as XML, even for the small list. The reason is that it's not difficult to get an object 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

June 5, 2009 at 5:25 am

#1005161
RE: beggining with sql server 2005

Well, this is pretty wide open. Do you mean with installing it? What are the new features? We're pretty good here, but we haven't mastered the brain meld thing over...
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 5:18 am

#1005156
RE: How did default definitions change?

Paul White (6/4/2009)
Jeff Moden (6/4/2009)
I agree... I must think differently and use the wrong search words. It's always a PITA for me to do a search on such 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

June 5, 2009 at 5:11 am

#1005149
RE: Are the posted questions getting worse?

Jeff Moden (6/4/2009)
WayneS (6/4/2009)
Jeff Moden (6/3/2009)
The following code creates a million row multiple account checkbook, does the "Fire Hose" cursor running total thing 5 times and follows that with 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

June 4, 2009 at 7:15 pm

#1004977
RE: Are the posted questions getting worse?

Paul White (6/4/2009)
WayneS (6/4/2009)
Hey friends, please help me out here. I'd really like to have an understanding of why this changed.
Thanks!
Helped. I think. 😀
Help you did, I do...
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 4, 2009 at 7:12 pm

#1004975
RE: How did default definitions change?

Paul, I do believe that you found what was going on.
Now, I searched the net for hours, and never found any of these articles. How did you do 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 4, 2009 at 7:09 pm

#1004974
RE: How did default definitions change?

GilaMonster (6/4/2009)
WayneS (6/2/2009)
Is there anything going on in sql 2005 that would cause these default definitions to be changed? How else could all of these have been changed?
None that I've...
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 4, 2009 at 7:03 pm

#1004972
RE: Are the posted questions getting worse?

Jeff Moden (6/3/2009)
The following code creates a million row multiple account checkbook, does the "Fire Hose" cursor running total thing 5 times and follows that with the "Pseudo Cursor" method...
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 4, 2009 at 3:29 pm

#1004933
RE: Are the posted questions getting worse?

Paul White (6/4/2009)
WayneS (6/4/2009)
...stuff..
Well that sucks - I just got the May edition in my inbox yesterday. Where's my June copy??? Grrr!
Thanks Wayne, I will look forward 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 4, 2009 at 3:13 pm

#1004923
RE: Are the posted questions getting worse?

Paul White (6/4/2009)
WayneS (6/4/2009)
Paul White (6/3/2009)
One thing to mention is that the article is the first of a series
Well, actually it's the second in a series.
The magazine I 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

June 4, 2009 at 3:05 pm

#1004916
RE: Bulk Insert without using format file differnt delimeter

Ghanta (6/4/2009)
I was wondering if varchar(max) can handle more than 2gb of data in a file as the entire file will be loaded in one varchar(max) field? Few files will...
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 4, 2009 at 11:56 am

#1004823
RE: Passing in lists to SQL 2005 parameters, is there a better approach?

For a small list, use the Numbers / Tally table method.
For a large list, use XML. See my article[/url] that covers this. It even includes a comparison to the Tally...
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 4, 2009 at 11:48 am

#1004817

Viewing 15 posts - 5,266 through 5,280 (of 5,588 total)