WayneS

Forum Replies Created

Viewing 15 posts - 4,411 through 4,425 (of 5,588 total)

RE: Can I install SSMSE 2008 , and steel keep SSMSE 2005 and how?

Utsab Chattopadhyay (4/15/2010)
Also as a side note, you should be able to use your 2005 and all other older instances using 2008 client tools. So may be you want 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

April 15, 2010 at 7:53 am

#1152124
RE: How to tune/speed up a procedure

gregory.anderson (4/15/2010)
What is the purpose of this select, is this just to create the temp table since it will never work (because 1 does not equal 2)?
SELECT
...
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

April 15, 2010 at 7:37 am

#1152112
RE: Comparing Table Variables with Temporary Tables

Toby White (4/12/2010)
Excellent article...
Thanks Toby.
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

April 14, 2010 at 9:53 pm

#1151867
RE: Comparing Table Variables with Temporary Tables

Tom.Thomson (4/14/2010)
Great article, it's very thorough, meticulously clear descriptions and examples, I wish we could have more articles like this.
Thanks Tom! Nothing like a little pressure for any future articles......
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

April 14, 2010 at 9:52 pm

#1151866
RE: how to get only latest date and other columns from table

See if this gets what you need.
-- start off with the test data
-- See how you start off by actually creating a table and then
-- inserting the data into...
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

April 14, 2010 at 8:16 pm

#1151851
RE: how to get only latest date and other columns from table

duplicate post. Please direct all replies to the other thread at http://www.sqlservercentral.com/Forums/Topic903697-149-1.aspx
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

April 14, 2010 at 7:14 pm

#1151840
RE: how to get only latest date and other columns from table

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

April 14, 2010 at 7:12 pm

#1151839
RE: Extract a Value in a str

Based on this sample data, what do you want the output to look like? I'm just not understanding what it is that you are wanting to get out of this.
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

April 14, 2010 at 7:10 pm

#1151838
RE: select

PaulB-TheOneAndOnly (4/14/2010)
This is either homework or one of the top five most weird business specs I've ever seen.
I'd vote for this being the top 1 weird business spec :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

April 14, 2010 at 7:05 pm

#1151836
RE: Select a string when data in the string varies

Jeff Moden (4/14/2010)
Wayne... just split on the "=" sign using SUBSTRING and CHARINDEX. It doesn't need to be Pivoted using a CrossTab to be used very effectively.
I utilized 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

April 14, 2010 at 6:59 pm

#1151834
RE: Trademark

Happens to all of us at some point. I initially thought it might be because the TM symbol might need to be specified as unicode.... but it turned out 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

April 14, 2010 at 6:32 pm

#1151833
RE: Extract a Value in a str

mranganwa (4/14/2010)
Hi
works nicely but when I encounter a string like this one
INSERT #Test VALUES('TBM907 - 16/03: provided a new ,of TBM908 - 02/03: TBM908 has TBM908')--- I want to extract...
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

April 14, 2010 at 6:29 pm

#1151832
RE: Are the posted questions getting worse?

GSquared (4/14/2010)
I clicked Lynn's name, opened "All User's Posts" and opened the discussion for the first one that mentioned DDL. Didn't need to know it involved a CTE. ...
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

April 14, 2010 at 6:15 pm

#1151830
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/14/2010)
WayneS (4/14/2010)
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.
It looks like you can come back now.
And I did. Just waiting...
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

April 14, 2010 at 2:59 pm

#1151761
RE: Stored Procedure and Field Alias

You need to convert this all to dynamic sql. And, the object names (in this case, the column names), can't be dynamic. Something like this:
DECLARE @sql VARCHAR(8000)
SET @sql =
'SELECT...
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

April 14, 2010 at 2:53 pm

#1151757

Viewing 15 posts - 4,411 through 4,425 (of 5,588 total)