WayneS

Forum Replies Created

Viewing 15 posts - 4,306 through 4,320 (of 5,588 total)

RE: Sum of column instead of row

A picture's worth a thousand words, but setup code is worth more. If you can provide the tables structure via CREATE TABLE statements, and some sample data via INSERT statements,...
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 22, 2010 at 10:22 am

#1156285
RE: GROUP BY Query Help

AndrewSQLDBA (4/22/2010)
Hope that you don't mind if I take the code apart and figure out how it works, and what it does
Actually, I think you will find that most people...
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 22, 2010 at 8:53 am

#1156172
RE: A DBA's Daily routine (and other items...)

Grant Fritchey (4/22/2010)
jcrawf02 (4/21/2010)
GregoryF: "don't worry about not knowing how many instances/servers there are, every where I have ever worked, no one know all of them, there are some 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 22, 2010 at 8:44 am

#1156160
RE: Are the posted questions getting worse?

Gianluca Sartori (4/22/2010)
Jack Corbett (4/22/2010)
Gianluca Sartori (4/21/2010)
I've seen even worse things in my app (Visual Basic):
Public const SC AS String = "'" 'Yes, you got it right, it's...
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 22, 2010 at 8:20 am

#1156138
RE: Truncate rollback

Hugo Kornelis (4/22/2010)
Good question. Not sure why it's worth 2 points; knowing that TRUNCATE can be rolled back should be elementary knowledge.
Abrar Ahmad_ (4/22/2010)
[font="Verdana"]Goodish, easy hunt. but for the only...
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 22, 2010 at 6:03 am

#1156008
RE: A DBA's Daily routine (and other items...)

GregoryF (4/21/2010)
jcrawf02 (4/21/2010)
GregoryF: "don't worry about not knowing how many instances/servers there are, every where I have ever worked, no one know all of them, there are some that are...
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 21, 2010 at 9:59 pm

#1155840
RE: Median of Two dates

Matt Miller (#4) (4/21/2010)
For 2 exactly - the median is the average of the 2 numbers.
Well, keywestfl9 did say:
i have a requirement to find median of two date column 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

April 21, 2010 at 9:53 pm

#1155838
RE: SQL Syntax

ColdCoffee (4/21/2010)
Lynn Pettis (4/21/2010)
Please note that if you write the query the way Coldcoffee showed you it will not take advantage of any indexes that may exist on your table.
Guess...
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 21, 2010 at 9:37 pm

#1155832
RE: Checking if a stored procedure paramter is null

andy behrendt (4/21/2010)
Hi All,
I have a stored procedure that requests one parameter which is a bit field. In the stored procedure I want to check if the parameter 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

April 21, 2010 at 9:07 pm

#1155825
RE: Median of Two dates

keywestfl9 (4/21/2010)
i have a requirement to find median of two date column in a table.
Can anyone suggest how do i achieve it in sql query?
Thanks for any help
How's this?
DECLARE @Date1...
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 21, 2010 at 9:00 pm

#1155824
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/21/2010)
Trey Staker (4/21/2010)
Brent Ozar ranted on it in his blog.[/url]
Yeah - I saw that. I like how he began his blog.
That was indeed a novel way to start...
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 21, 2010 at 6:47 pm

#1155797
RE: A DBA's Daily routine (and other items...)

GregoryF (4/21/2010)
Me, and many of my friends do spend a few hours surfing the web during the day.
Then, to kill the time surf the web.
Might I suggest instead of just...
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 21, 2010 at 6:44 pm

#1155795
RE: Did the way SQL Server 2008 evaluates a CASE WHEN condition when used in a filter?

Paul White NZ (4/21/2010)
Well this took off while I was asleep!
You actually sleep??? When did this change occur? :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 21, 2010 at 5:00 pm

#1155770
RE: MCJ - The Missing Link

Steve Jones - Editor (4/21/2010)
I have spoken with my boss, and in principle he thinks it's a good idea to help out here. Any preferences on what you're like 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

April 21, 2010 at 4:54 pm

#1155764
RE: send a parameter (@theWhere)

Yes. Make a hidden parameter. Then use a variable to build the sql statement to run, using this parameter as the where clause.
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 21, 2010 at 3:43 pm

#1155724

Viewing 15 posts - 4,306 through 4,320 (of 5,588 total)