WayneS

Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 5,588 total)

RE: Are the posted questions getting worse?

GSquared (4/20/2011)
GilaMonster (4/20/2011)
LutzM (4/20/2011)
Is there any other method than using the mouse pointer? There are so many words on the screen. How else to keep track where the next word...
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 20, 2011 at 1:00 pm

#1314171
RE: numbering sequential orders for groups?

You're most welcome Amy.
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 20, 2011 at 11:14 am

#1314120
RE: numbering sequential orders for groups?

This article should help you out: SQL Server Ranking Functions[/url]
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 20, 2011 at 11:01 am

#1314108
RE: Convert Military date to standard

Well, what you have is one of the standard date formats (20/120). I guess what you need is to pick which one you actually want... this might help you out:
SET...
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 20, 2011 at 10:58 am

#1314103
RE: Are the posted questions getting worse?

Koen Verbeeck (4/20/2011)
WayneS (4/20/2011)
Brandie, thanks for calling me on this. You're absolutely right.
You were probably acting like your avatar when you were reading Celko's post 😀 😉
Well, yeah, but...
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 20, 2011 at 8:29 am

#1313983
RE: TSQL Logic help needed-- Nested IF

;
WITH cteAccountOrder (ColumnName, ColumnOrder) AS
(
-- the preferred sorting order when > 2 accounts in a row
SELECT 'Acc1', 1 UNION ALL
SELECT 'Acc3', 2 UNION ALL
SELECT 'Acc2', 3 UNION ALL
SELECT 'Acc4', 4
),...
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 20, 2011 at 8:08 am

#1313964
RE: Getting the details of the rows into columns

What you are looking for is to PIVOT the rows into columns. Please check out the two articles linked to in my signature dealing with CROSS-TAB or PIVOT tables: Parts...
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 20, 2011 at 7:12 am

#1313913
RE: Are the posted questions getting worse?

Brandie Tarvin (4/20/2011)
WayneS (4/19/2011)
Greg Edwards-268690 (4/19/2011)
GSquared (4/19/2011)
Lynn Pettis (4/19/2011)
And once again Celko sticks his nose where it really wasn't needed. The OPs question had already been answered.
And Joe's answer,...
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 20, 2011 at 6:41 am

#1313893
RE: Contained database temporary tables

Just to make sure you understand... the temporary tables still physically reside in tempdb. They still show up in tempdb.sys.tables and tempdb.sys.columns (indexes, constraints, etc.) They are just of 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 19, 2011 at 7:53 pm

#1313714
RE: Are the posted questions getting worse?

Greg Edwards-268690 (4/19/2011)
GSquared (4/19/2011)
Lynn Pettis (4/19/2011)
And once again Celko sticks his nose where it really wasn't needed. The OPs question had already been answered.
And Joe's answer, while demanding 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

April 19, 2011 at 3:29 pm

#1313666
RE: I need a query for getting avg from the below table.

Edit: in hindsight, I was inappropriate. Comments removed.
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 19, 2011 at 3:28 pm

#1313664
RE: Convert to bigint

have you tried varbinary?
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 19, 2011 at 3:24 pm

#1313661
RE: Creating loops within loops

NP. After you have tested everything out, please respond back with how things are going. (BTW, I only tested this on a SQL 2008 box, but I believe that 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

April 19, 2011 at 3:18 pm

#1313658
RE: TSQL Logic help needed-- Nested IF

MV,
If you're willing to help us help you, I think we can come up with something.
What I need is for you to read the first article in my signature, then...
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 19, 2011 at 3:14 pm

#1313657
RE: Need a way to write clever query with dynami columns

Look at the two links in my signature dealing with Cross-Tabs and Pivot tables. Part 2 covers dynamic pivoting.
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 19, 2011 at 3:04 pm

#1313654

Viewing 15 posts - 1,471 through 1,485 (of 5,588 total)