WayneS

Forum Replies Created

Viewing 15 posts - 4,486 through 4,500 (of 5,588 total)

RE: avoiding dynamic sql for updating

Given the choice of:
if @Param1 > '' and @Param2 > '' update table1 set column1 = @param1, column2 = @param2
else if @Param1 > '' update table1 set column1 = @param1
else...
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 8, 2010 at 1:25 pm

#1148612
RE: IN function

You basicly have two options:
1. Use dynamic sql @cmd = '... IN(' + @tech_list + ')'
2. Use a string splitting routine to make separate rows out of each entry, 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

April 8, 2010 at 12:02 pm

#1148532
RE: Are the posted questions getting worse?

Gianluca Sartori (4/8/2010)
WayneS (4/7/2010)
As a parent, you always need to be ready to follow through on any threat that you make. And the sooner you do it, the sooner 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 8, 2010 at 8:51 am

#1148354
RE: Are the posted questions getting worse?

RBarryYoung (4/7/2010)
WayneS (4/7/2010)
Jeffrey Williams-493691 (4/7/2010)
Grant Fritchey (4/7/2010)
You kids take this outside or I'm going to get my belt!
If you don't stop right now - I'm going to turn this car...
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 8, 2010 at 8:49 am

#1148351
RE: Are the posted questions getting worse?

Paul White NZ (4/7/2010)
*cough*
Whose QotD? 😛 :rolleyes:
Crap... Sorry Paul. I fixed it, but you have me quoted with the wrong name forever...
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 7, 2010 at 7:21 pm

#1147952
RE: Two job offers..two different companies

Oh, personal note. In 1998, I started a position for a 6 month contract. I left it almost 8 years later.
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 7, 2010 at 6:14 pm

#1147928
RE: Are the posted questions getting worse?

I see Paul's QOD is still running 47%, w/ 1250 attempts.
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 7, 2010 at 6:04 pm

#1147923
RE: Are the posted questions getting worse?

Jeffrey Williams-493691 (4/7/2010)
Grant Fritchey (4/7/2010)
You kids take this outside or I'm going to get my belt!
If you don't stop right now - I'm going to turn this car around 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

April 7, 2010 at 6:02 pm

#1147922
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/7/2010)
Grant Fritchey (4/7/2010)
CirquedeSQLeil (4/7/2010)
Grant Fritchey (4/7/2010)
You kids take this outside or I'm going to get my belt!
And then put on your pants?
Alternatively
If you kids don't stop right now, you'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

April 7, 2010 at 5:57 pm

#1147920
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/7/2010)
I find myself amazed that there are three that carried through with that threat and it worked.
That is awesome. If I ever need to hold true to 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 7, 2010 at 5:51 pm

#1147917
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/7/2010)
Jeffrey Williams-493691 (4/7/2010)
Grant Fritchey (4/7/2010)
You kids take this outside or I'm going to get my belt!
If you don't stop right now - I'm going to turn this car around...
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 7, 2010 at 5:43 pm

#1147911
RE: Don’t Change Anything

Jack Corbett (4/7/2010)
I agree with Wayne on this one.
But not on others? Jack, you should always agree with me. 😀 😉
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 7, 2010 at 3:51 pm

#1147818
RE: Two job offers..two different companies

Some places use a 6 month contract to "try you out". If you do a good job, they'll turn it into a FT job. If not, bye bye. Can you...
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 7, 2010 at 3:38 pm

#1147810
RE: Don’t Change Anything

RalphWilson (4/7/2010)
Whil;e I agree that data should not be changed without careful consideration, I also have to deal with the very problem discussed in the editorial and yet I am...
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 7, 2010 at 12:56 pm

#1147695
RE: How to fing first letter is a number or letter in a column

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 7, 2010 at 10:21 am

#1147524

Viewing 15 posts - 4,486 through 4,500 (of 5,588 total)