WayneS

Forum Replies Created

Viewing 15 posts - 4,651 through 4,665 (of 5,588 total)

RE: RegexMatch Help

Well, this doesn't use RegEx (just plain ole T-SQL), but it accomplishes what you're wanting:
select * from #temp where [text] like '%[0-9]%'
Since you want to return a 1/0 for 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

March 22, 2010 at 9:33 am

#1137648
RE: Are the posted questions getting worse?

GilaMonster (3/19/2010)
No, it doesn't get quite that hot here. 6 hours drive north (Messina), it does.
For those of us in the Northern Hemisphere, that just sounds so wrong!
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 19, 2010 at 10:12 pm

#1137137
RE: deletion of 2 million records

ncodner (3/19/2010)
@WayneS - you're saying if I do the deletion in a loop there will be no locks on the table? Is this better than specifying 'no lock' in 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

March 19, 2010 at 2:04 pm

#1137018
RE: deletion of 2 million records

sandip.vs (3/18/2010)
I want to delete 2 million records from my table(based upon a condition)....what is the easiest way to do???
Assuming that you read Stefan's post, and you need to perform...
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 18, 2010 at 11:04 am

#1136164
RE: UPDATE QUERY

steveb. (3/18/2010)
you can do an update based upon an inner join
from your code provided it would look something like this;
UPDATE Leas
SET Leas.amount = Cmrecc.amount
FROM...
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 18, 2010 at 10:55 am

#1136154
RE: How do I convert a string with trailing sign to a signed integer?

Duplicate post. Use http://www.sqlservercentral.com/Forums/Topic885560-1292-1.aspx discussion.
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 18, 2010 at 9:16 am

#1136047
RE: How to convert from string to numeric with trailing sign

Does this do it for you?
declare @test-2 varchar(50),
@num int
set @test-2 = '000150000-'
set @num = left(@test,DataLength(@test)-1) * case when right(@test,1) = '-' 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 18, 2010 at 9:15 am

#1136044
RE: Are the posted questions getting worse?

Roy Ernest (3/18/2010)
Everyday morning I open up my email, I see atleast 50 replies on the THREAD. I am going on vacation from tomorrow onwards till April 12th. I wonder...
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 18, 2010 at 8:46 am

#1136013
RE: Are the posted questions getting worse?

Paul White (3/17/2010)
WayneS (3/17/2010)
In BOL for ODBC Scalar Functions, it has a syntax of {fn ...}. Do you have a link that shows the use of d/t/ts like you 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 17, 2010 at 6:57 pm

#1135662
RE: Differences between SQL Server 2005 and SQL Server 2008

This will list a few things...
http://www.lmgtfy.com/?q=sql+server+2008+what%27s+new
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 17, 2010 at 7:21 am

#1135208
RE: Are the posted questions getting worse?

Paul White (3/16/2010)
Jeff Moden (3/16/2010)
I assume that by "explicit date" you mean something like '1900-01-01'... and that's not a date either... that's a string that looks like a date. 😛
Aside...
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 17, 2010 at 5:24 am

#1135123
RE: remove leading Zeros while importing any column from text file to SQL database

Have you tried transforming it to an int, and then back to a string? That seems like it should do what you're trying to accomplish.
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 16, 2010 at 2:40 pm

#1134823
RE: Are the posted questions getting worse?

tstaker (3/16/2010)
Grant Fritchey (3/16/2010)
CirquedeSQLeil (3/16/2010)
Roy Ernest (3/16/2010)
CirquedeSQLeil (3/16/2010)
Roy Ernest (3/16/2010)
I got my $500 yesterday. If I can write an article there, anyone here can write it for sure. 🙂
You wrote...
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 16, 2010 at 2:35 pm

#1134817
RE: Are the posted questions getting worse?

Alvin Ramard (3/16/2010)
Mesa be back a shortly.
No, please not!
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 16, 2010 at 7:32 am

#1134429
RE: Are the posted questions getting worse?

Alvin Ramard (3/15/2010)
GilaMonster (3/15/2010)
CirquedeSQLeil (3/15/2010)
Steve, we really need a "devil emoticon"
I need an angel. For all those 'looks around innocently' type comments
How about a "knocking head against the wall" one...
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 15, 2010 at 3:54 pm

#1134133

Viewing 15 posts - 4,651 through 4,665 (of 5,588 total)