WayneS

Forum Replies Created

Viewing 15 posts - 4,816 through 4,830 (of 5,588 total)

RE: Alphanumberic string search

lmu92 (2/2/2010)
WayneS (2/2/2010)
And yet, if you look at the last line of the OPs original post, this is exactly what he wants.... for now.
So, do you think having a persisted...
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

February 2, 2010 at 12:22 pm

#1112482
RE: Alphanumberic string search

And yet, if you look at the last line of the OPs original post, this is exactly what he wants.... for now.
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

February 2, 2010 at 11:54 am

#1112454
RE: Check for table EXISTence in SQL '08

whouston (2/2/2010)
My SQL 2000 stored proc was migrated as shown below. All the SQL 2000 tables & procs were built by [dbo] using "sa" login, and all the applications which...
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

February 2, 2010 at 11:52 am

#1112453
RE: Are the posted questions getting worse?

Paul White (2/2/2010)
GilaMonster (2/2/2010)
I'm fast losing both patience and hope. The last month, it feels like I've been correcting almost as many replies as I have been answering questions
http://www.sqlservercentral.com/Forums/Topic856902-145-1.aspx#bm857286
http://www.sqlservercentral.com/Forums/Topic475163-146-1.aspx#bm856344
http://www.sqlservercentral.com/Forums/Topic855771-360-1.aspx#bm855992
Am 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

February 2, 2010 at 11:13 am

#1112437
RE: Is there a way to remove the cancel button from a window?

Angela S. (2/2/2010)
We have an audit trail, but if you hit cancel it allows you to pass without putting info. Or if you hit the X in the upper right...
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

February 2, 2010 at 10:55 am

#1112428
RE: Stored Proc with table variables running very slow?

san43 (2/2/2010)
Thanks for all the suggestions that every one has given me. I have replaced the code for table variables with temp tables. Now it is running fine in prod...
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

February 2, 2010 at 9:29 am

#1112366
RE: Stored Proc with table variables running very slow?

Jeff Moden (2/1/2010)
Another good idea. Thanks Wayne. Just curious though... have you ever used it that way?
No, but I read about it and realized it would work pretty...
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

February 2, 2010 at 9:26 am

#1112364
RE: Is there a way to remove the cancel button from a window?

Angela, what language is this code even written in? I don't recognize it. And while you might be requiring a reason for why a field was changed for audit purposes,...
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

February 2, 2010 at 9:22 am

#1112357
RE: Are the posted questions getting worse?

BrainDonor (2/2/2010)
Roy Ernest (2/2/2010)
BrainDonor (2/2/2010)
This thread is going to get interesting.
I've been waiting for weeks for this one to show their head over the parapet.
BrainDonor.
By seeing your last post...
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

February 2, 2010 at 9:18 am

#1112354
RE: Alphanumberic string search

sql_ques (2/2/2010)
Hi All,
Here is a query,
SELECT LASTNAME FROM CPM.dbo.T_CANADIAN
WHERE '678567Z' BETWEEN '673001P' AND '679000P'
It should not display any result as the where value numerials fall in between '673001P' 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

February 2, 2010 at 9:14 am

#1112350
RE: Alphanumberic string search

Roy Ernest (2/2/2010)
Would this work in all cases? Why dont you try to use the functions that we re hinted to you by others?
Those were hints? Heck, IMHO, those were...
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

February 2, 2010 at 9:09 am

#1112347
RE: Datetime format

paucann (2/2/2010)
That field holds many values depending on table joins.
Paul, are you saying that sometimes it holds a date, and other times something else? Jeez, this is a horrible design!
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

February 2, 2010 at 8:32 am

#1112318
RE: Alphanumberic string search

sql_ques (2/2/2010)
Please tell me how to do it.
Look in BOL at the LEFT, RIGHT and SUBSTRING functions.
It looks like the root issue here is a single data field with multiple...
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

February 2, 2010 at 8:15 am

#1112303
RE: Indexing fields for JOINS and WHERE

confirm.
Note that your <column> can be multiple columns, and the sort order can be ASC or DESC on each column.
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

February 1, 2010 at 1:42 pm

#1111927
RE: SSIS And Sapce in EXCEL Tab Names

You are actually creating a tab and a named range. Since the named range cannot have spaces, any are converted to underscores.
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

February 1, 2010 at 1:41 pm

#1111926

Viewing 15 posts - 4,816 through 4,830 (of 5,588 total)