WayneS

Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 5,588 total)

RE: Are the posted questions getting worse?

Brandie Tarvin (9/9/2010)
...One of the other boards I frequent ....
A traitor!: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 10, 2010 at 7:18 am

#1219139
RE: dropdown list in ssrs

I can't tell if you just want the "ALL" option in the drop down in the report parameters area, or how to handle in it the following code. So, I'll...
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 9, 2010 at 9:14 am

#1218703
RE: Urgent: Need Help to change server connection of SSIS packages

Set up a configuration file for the server name. Modify each package to use the configuration file (yep, it's labor intensive for 100 packages). On the production server, put 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

September 8, 2010 at 9:03 pm

#1218335
RE: Are the posted questions getting worse?

Hey Steve - what's the new avatar?
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 8, 2010 at 6:29 pm

#1218314
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/8/2010)
I think Lutz has some bad karma going. It seems every weird thread I come across with a difficult OP is one in which Lutz is...
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 8, 2010 at 6:23 pm

#1218311
RE: This is SSC related actually

But how do you like the one I decided not to use?
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 8, 2010 at 3:33 pm

#1218284
RE: select distinct best row based on a condition

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...
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 8, 2010 at 11:46 am

#1218131
RE: Are the posted questions getting worse?

How about a table where the PK is on a text datatype? (as are most of the other columns also!)
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 8, 2010 at 10:49 am

#1218107
RE: SQL Query

call4ljw (9/8/2010)
Like this?
You should give appropriate data types. Having a text field (which allows for 2gb) as a PK just isn't a good idea.
You might want to try right-clicking 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

September 8, 2010 at 10:47 am

#1218106
RE: dynamic query

Jerry - You might want to take a look at Gail's excellent blog[/url] on what you're proposing.
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 8, 2010 at 10:23 am

#1218083
RE: Are the posted questions getting worse?

Still running at needing 24.9 posts/day to get to 20000 by 11/18
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 8, 2010 at 10:09 am

#1218075
RE: Selecting differences between datasets

richard.kirby (9/8/2010)
Hi Wayne - works as well!
Such a simple thing has will increase the efficiency of myself and a few colleagues immensely.
Great stuff all round.
-Richard
It's worthwhile to get to know...
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 8, 2010 at 9:55 am

#1218068
RE: DISTINCT & MAX & GROUP BY Query

Pete-L (9/8/2010)
Hi Mike, the table I gave was an example - the one im going to run it against has almost 100k lines, the script would end up way 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

September 8, 2010 at 9:51 am

#1218064
RE: Please help with a query

keymoo - thanks for providing the excellent sample data, table definitions, and desired output. Without it, I think you'd still be waiting for a solution.
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 8, 2010 at 9:40 am

#1218057
RE: Please help with a query

Chris Morris-439714 (9/8/2010)
WayneS (9/8/2010)
Here's my solution. I took a similar approach that Chris did to make a row for each unit, but how we did that is different (I'm using...
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 8, 2010 at 9:36 am

#1218052

Viewing 15 posts - 3,286 through 3,300 (of 5,588 total)