WayneS

Forum Replies Created

Viewing 15 posts - 4,741 through 4,755 (of 5,588 total)

RE: While Loop for Inserts from Read-only Function

Nugby (2/22/2010)
Sorry, the Function produces Fund Manager Information, e.g. Manager Name, Portfolios, Securities, Net Asset Values etc. It's table-based as you can therefore imagine.
...
To reiterate, can someone can confirm...
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

February 23, 2010 at 1:56 am

#1123475
RE: Help- Very Complex SQL query

Paul White (2/22/2010)
Totally awesome job there Wayne.
Fixed that for you, Paul. 😀
... but seriously, Thanks!
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

February 23, 2010 at 1:39 am

#1123474
RE: Are the posted questions getting worse?

RBarryYoung (2/22/2010)
Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no one...
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

February 22, 2010 at 7:47 pm

#1123391
RE: better way to rewrite this code

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...
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

February 22, 2010 at 6:30 pm

#1123378
RE: While Loop for Inserts from Read-only Function

You don't mention if:
1. What the function returns (datatype), and
2. Whether this is a table-valued function, or a scalar-valued function.
So, assuming that this is a table-valued function that returns 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

February 22, 2010 at 6:22 pm

#1123377
RE: Help- Very Complex SQL query

Paul White (2/22/2010)
WayneS (2/22/2010)
I must have missed the updated requirements... let me look at what those are and see what I can do.
The updated test data setup script 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

February 22, 2010 at 5:57 pm

#1123372
RE: FizzBuzz

Steve Jones - Editor (2/22/2010)
Thanks, John. Hopefully it will be done tomorrow 🙂
Nope... Gus seems to be the type that would have the code finish 'bout the time the weekend...
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

February 22, 2010 at 4:50 pm

#1123361
RE: FizzBuzz

reidres (2/22/2010)
Jeff,
I don't want people on my team optimizing for trivial things, and the constraints of the project define those things. Speed may not be essential, or it may....
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

February 22, 2010 at 3:36 pm

#1123328
RE: dynamic sql issues

If you use sp_executesql, the dynamic string can be set up so that all variables are parameters, and the parameters also passed in thru sp_executesql. As you add/drop lines 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

February 22, 2010 at 1:53 pm

#1123263
RE: FizzBuzz

Ivanna Noh (2/22/2010)
ok - but does the code look ok?
I welcome constructive criticism 🙂
I think you want to change your INNER JOIN to a CROSS JOIN (which means remove 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

February 22, 2010 at 1:49 pm

#1123255
RE: FizzBuzz

Sean-752587 (2/22/2010)
Hi jcrawf02
How would you change it to avoid the cast?
like this... you don't need to cast ROW_NUMBER to an int... it already is
select top 100
case
when ROW_NUMBER() 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

February 22, 2010 at 12:14 pm

#1123179
RE: FizzBuzz

GSquared (2/22/2010)
Just to annoy Jeff, here's my "ultimate version":
SOM! :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

February 22, 2010 at 10:04 am

#1123102
RE: Are the posted questions getting worse?

Paul White (2/22/2010)
tstaker (2/22/2010)
I'll second this one... I'd love to see a good article on APPLY.
Ok, ok! I'll give it some thought...:cool:
Well??? Haven't you had enough time to think...
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

February 22, 2010 at 8:56 am

#1123019
RE: Help- Very Complex SQL query

Paul White (2/21/2010)
Wayne,
Thanks for that. I'm a bit old-school and also include an INDEX(0) too. I was rather hoping for a quirky implementation for the updated requirements though...
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

February 22, 2010 at 6:05 am

#1122876
RE: Help- Very Complex SQL query

Paul White (2/21/2010)
So, would anyone like to post a correct quirky-update solution to the updated requirement, just for completeness?
Good idea Paul... we've talked about the need for doing it right,...
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

February 21, 2010 at 11:10 pm

#1122711

Viewing 15 posts - 4,741 through 4,755 (of 5,588 total)