WayneS

Forum Replies Created

Viewing 15 posts - 2,311 through 2,325 (of 5,588 total)

RE: Replacing only numeric value on a string

Luis,
Assuming:
1. That the numbers to be replaced are the only place in the string that any numbers are, and
2. That you want what is to the left of it, plus...
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

November 23, 2010 at 6:35 pm

#1254851
RE: Slow query when using specific date range = very frustrated

I've got two suggestions to try. Please get back and let us know how they work for you.
The first one moves the correlated subquery in the where clause to a...
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

November 23, 2010 at 6:26 pm

#1254849
RE: Slow query when using specific date range = very frustrated

Frank Nadal (11/23/2010)
GRRR I highlighted the sql results and clicked on "plain" on the left and it still inserted those stupid faces. Sorry.
I'll bet that those faces are a ":...
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

November 23, 2010 at 6:15 pm

#1254848
RE: SQL Server Ranking Functions

I'm glad I was able to straighten it out for you. Thank you for you comments, and I hope to see you more online here!
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

November 23, 2010 at 5:27 pm

#1254842
RE: cross apply

SELECT column = (select column FROM function (t.address))
FROM Table t
you would have to repeat the call for each column you want.
On 2000, you might want to include an...
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

November 23, 2010 at 3:49 pm

#1254806
RE: Dynamic SQL issue

LutzM (11/23/2010)
The reason you can't use a local temp table in a dynamic sql statement (straight from BOL):
Local temporary tables are visible only to their creators during the same connection...
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

November 23, 2010 at 3:45 pm

#1254801
RE: Calculate dates an individual lives in apartement each month

How does this work for you?
-- See how this starts off with a table and data in it?
-- If you had provided us the data in this format,
-- 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

November 23, 2010 at 3:38 pm

#1254797
RE: Dynamic SQL issue

DECLARE @SQL VARCHAR(1000)
DECLARE @Where VARCHAR(500)
SET @Where= 'Price >3.0'
SET @SQL = 'SELECT Symbol,Price FROM' +@test + ' '+@Where
In this, you are trying to concatenate a string and a table variable together....
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

November 23, 2010 at 2:30 pm

#1254753
RE: Dynamic SQL issue

The scope of a table variable is the current batch only. It is NOT in scope to any nested procedures, including dynamic sql. So, if you want to use 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

November 23, 2010 at 2:24 pm

#1254748
RE: transaction size limit

GSquared (11/23/2010)
Alternately, strangle the developer who came up with the idea
Always a viable option!
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

November 23, 2010 at 2:22 pm

#1254744
RE: Are the posted questions getting worse?

Craig Farrell (11/23/2010)
We laugh (or at least chuckle) at Alvin's jokes, for example.
No, that's a groan. 😀
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

November 23, 2010 at 2:18 pm

#1254742
RE: Datbase is in Suspect mode

Craig Farrell (11/23/2010)
GSquared (11/23/2010)
If you want, I'll put the whole thing into article form and give it to Steve. Probably should have done that a year ago, when I...
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

November 23, 2010 at 1:57 pm

#1254729
RE: Are the posted questions getting worse?

GilaMonster (11/23/2010)
CirquedeSQLeil (11/23/2010)
GilaMonster (11/23/2010)
CirquedeSQLeil (11/23/2010)
If you were to buy a SQL book, what would you buy? If there is a topic you wanted to learn about, what is 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

November 23, 2010 at 11:35 am

#1254651
RE: Help with SQL SCRIPT Causing Deadlock

GilaMonster (11/23/2010)
Just as one hand can't clap, one session can't deadlock.
I like this analogy!
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

November 23, 2010 at 11:25 am

#1254634
RE: Need help with some code..

Oh - you don't need the TOP 100 PERCENT on all your queries - all you're doing is making SQL work harder / take longer to return your results.
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

November 23, 2010 at 11:15 am

#1254629

Viewing 15 posts - 2,311 through 2,325 (of 5,588 total)