WayneS

Forum Replies Created

Viewing 15 posts - 4,606 through 4,620 (of 5,588 total)

RE: Are the posted questions getting worse?

Jack Corbett (3/24/2010)
I had problems with FF 3.5 so got off of it into Chrome. I don't even have FF installed now. I do use IE especially for...
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

March 24, 2010 at 1:27 pm

#1139200
RE: Index

It depends. Are there any non-clustered indexes on that 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

March 24, 2010 at 12:51 pm

#1139182
RE: The Missing Certification

Jack Corbett (3/24/2010)
I would think that might work for development, but administration of different platforms is very different, at least in my understanding. I have only been a DBA...
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

March 24, 2010 at 12:02 pm

#1139137
RE: Query using the LIKE OPERATOR

ronaldkrex (3/24/2010)
I have been running the query below. For some reason I can type a value for name that I know is in the Name Field and I don't get...
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

March 24, 2010 at 11:54 am

#1139132
RE: Query using the LIKE OPERATOR

PaulB-TheOneAndOnly (3/24/2010)
upper(Name) LIKE upper(@Name) or @Name IS NULL
also remember to add "%" ... like in: upper(name) like upper('Jerem%')
Using a function on the field being searched is going to negate any...
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

March 24, 2010 at 11:51 am

#1139129
RE: T-SQL Problem

How does this work?
exec ('declare @cnt int;select @cnt=count(*) from ' + @nome + 'sys.objects where name = ''sp_actualizaaut'';if @cnt > 0 select ''ola'' else select ''no ola''')
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

March 24, 2010 at 11:46 am

#1139123
RE: Identify a group of common values across several columns

I think this will do it for you.
-- see how the test data can be put into a table? It sure helps others to not have to do this!
declare @test-2...
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

March 24, 2010 at 11:26 am

#1139100
RE: Parse field with Numeric ranges and comma deliminated values

Based on the single row of test data you supplied, and assuming that all other rows are in the same exact format, this will work:
declare @test-2 table (MixedData varchar(50))
insert 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

March 24, 2010 at 11:09 am

#1139078
RE: Parse field with Numeric ranges and comma deliminated values

This looks interesting, and I'd like to help you out, but there just isn't enough information to begin. So, to start off, please read the first link in my signature...
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

March 24, 2010 at 10:53 am

#1139070
RE: Bit Param Evaluation alters Execution Plan

nwoolls (3/24/2010)
Thanks for the response Paul. I had actually broken the statement into two, as you suggested, as a work around for now.
A little background on that syntax: we used...
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

March 24, 2010 at 10:10 am

#1139037
RE: T-SQL Oddities

Gianluca Sartori (3/24/2010)
You definitely have to check out this[/url] and this.
Very funny.
I knew I had seen this, but I thought it was on this site. Thanks for the links.
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

March 24, 2010 at 9:12 am

#1138980
RE: Find first missing number

Paul White NZ (3/24/2010)
sku370870 (3/23/2010)
Can you mark posts as resolved on this forum?
No, because you never know when someone else might find the question or discussion interesting and make another...
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

March 24, 2010 at 9:00 am

#1138962
RE: SSMS - feature

Very nice. I didn't know about this.
It seems that you can only have one web tab open though... it would be REALLY nice if you could open up multiple tabs.
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

March 24, 2010 at 8:44 am

#1138953
RE: Are the posted questions getting worse?

Barry!!! Welcome Back!!!
Hope everything went well with your surgery.
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

March 23, 2010 at 7:38 pm

#1138653
RE: Are the posted questions getting worse?

tstaker (3/23/2010)
One of these days (probably nights) I'm going to have to check out what this twitter thing is. It's blocked at work. Am I the only person...
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

March 23, 2010 at 7:34 pm

#1138650

Viewing 15 posts - 4,606 through 4,620 (of 5,588 total)