Forum Replies Created
Viewing 15 posts - 4,156 through 4,170 (of 5,588 total)
-
RE: rewriting the code in SUb queries
athatipamula (5/24/2010)
I have a code using except functioncan any one rewrite the code using sub queries?
I am using 2 databases and 2 different tables
here is the code:
SELECT [MODE],[NUMBER],[DESCRIPTION],[UNITSIZE]
FROM [database1].[DBO].[table1]...
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 -
RE: Index Structures
The Dixie Flatline (5/21/2010)
A thought provoking question anyway....I think "unique" should count twice or not at all. You can have unique clustered indexes and...
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 -
RE: Index Structures
About 3 weeks ago, I was doing some research on a related topic and found that this answer is wrong. I had asked Steve to change this question then.
This QotD...
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 -
RE: Are the posted questions getting worse?
Jack Corbett (5/19/2010)
Quiet in here today. Everyone at 24 HOP?Yep... I took the week off, and among all the chores I had a list of 13 sessions I wanted...
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 -
RE: Crosstab based on row counting
Here's an approach that is similar to the one Lutz posted. As he did, it's based off of tally table.
Main differences are that you can specify the number of rows...
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 -
RE: convert an interger to time
Slight modifications to the solution already provided by ColdCoffee, in order to show with the field name you specified. And a way to eliminate the case statement.
DECLARE @YOUR_TABLE TABLE
(
...
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 -
RE: Help with Date part
Rob Schripsema (5/18/2010)
Nice tweak, Jeff. Not perfect -- won't allow for years prior to 2000 (and I, for one, have a birthday before 2000 :hehe:) -- but a definite improvement.Perfectly...
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 -
RE: Are the posted questions getting worse?
Trey Staker (5/18/2010)
CirquedeSQLeil (5/18/2010)
Steve,I like the change to the headlines section on the front page.
Agreed, it's a nice change.
Yes, it looks VERY nice!
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 -
RE: Are the posted questions getting worse?
CirquedeSQLeil (5/18/2010)
Is Wayne out there changing his name?LOL.
Actually, I found that avatar on a post out here on SSC... but the poster hadn't been active in quite some while. Might...
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 -
RE: FOR XML PATH question on column data instead of column names
I would be interested in your solution to this also!
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 -
RE: Backup\ Restore completion Status.
gary.mazzone (5/18/2010)
I got it right but since when is a Dynamic Management View a table?I agree with you Gary... it's a view (albeit into a system table).
And with Carlo 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 -
RE: Need some help with query
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 -
RE: How to obtain week by week plus YTD totals
simflex-897410 (5/17/2010)
... rather than use WHERE EndDate BETWEEN @StartDate AND @EndDate, can I replace it with year so that users can just enter year to obtain the report for that...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 -
RE: Are the posted questions getting worse?
The Dixie Flatline (5/17/2010)
My wife had an interesting thought about plagiarism, which was that websites should NOT take down those articles. Instead they should keep the title, 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 -
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application
Paul White NZ (5/15/2010)
My normal optimisation trick for triangular joins will not work here.[CuriousMode]
Care to share this trick with us? Might be able to learn something new...
[/CuriousMode]
oh wait... is 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
Viewing 15 posts - 4,156 through 4,170 (of 5,588 total)