WayneS

Forum Replies Created

Viewing 15 posts - 4,426 through 4,440 (of 5,588 total)

RE: Trademark

JKSQL (4/14/2010)
SELECT CHARINDEX('AAAAAAAA™BBBBBBBBBBBBBB',Char(153))
I can not seem to get the trademark to work in charindex
You're using CharIndex wrong... you reversed the parameters.
Try:
SELECT CHARINDEX(char(153),'AAAAAAAA™BBBBBBBBBBBBBB')
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 14, 2010 at 2:49 pm

#1151751
RE: Are the posted questions getting worse?

Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.
It looks like you can come back now.
And I did. Just waiting now to...
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 14, 2010 at 2:40 pm

#1151737
RE: SQL Question

Mister Ken, I think the problem with the original query you posted is that you built a derived table, and properly aliased it, but then when you joined it to...
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 14, 2010 at 2:32 pm

#1151730
RE: 'Debugging Query' for a long time...

CirquedeSQLeil (4/14/2010)
WayneS (4/14/2010)
In SSMS, are you pressing the Green Triangle, or the Red Exclamation Point?
The Green Triangle is to run in Debug mode, the Red Exclamation Point executes the query....
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 14, 2010 at 2:22 pm

#1151723
RE: Combine two datasets in SSRS report?

Tammy,
Glad to be able to help you out. We know you're an "accidental DBA", and most people here will try to help you out.
One reason some people won't help out...
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 14, 2010 at 2:16 pm

#1151716
RE: 'Debugging Query' for a long time...

In SSMS, are you pressing the Green Triangle, or the Red Exclamation Point?
The Green Triangle is to run in Debug mode, the Red Exclamation Point executes the query. You want...
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 14, 2010 at 2:08 pm

#1151710
RE: Combine two datasets in SSRS report?

TAMMYAUDETTE (4/14/2010)
I reallly feel like this is something that is simple, but I'm completely missing the logic.
I have a report I'm building, a report of SKU numbers with sold...
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 14, 2010 at 1:57 pm

#1151705
RE: Select a string when data in the string varies

bill.brazell (4/14/2010)
This is looking very promising. Thank you.
As for the output, I'd prefer that it not include the name of the delimiter, only the value. i.e. "Ping" instead...
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 14, 2010 at 1:47 pm

#1151696
RE: Extract a Value in a str

In the next-to-last INSERT, you have TBMLxxx. It also looks like you did a cut-and-paste and have several lines of -- this should return TBM419, when TBM419 is not in...
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 14, 2010 at 10:35 am

#1151532
RE: Convert string to datetime error

Did you get the column converted to a datetime data type? If so, that constraint won't help 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 14, 2010 at 10:04 am

#1151502
RE: Convert string to datetime error

timotech (4/14/2010)
Hi thanks for your replies. unfortunately the fields has a lot of Null values. there are about 4000 records, how do i fill the nulls
UPDATE myPoorlyDesignedTable
...
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 14, 2010 at 5:16 am

#1151230
RE: Select a string when data in the string varies

Jeff Moden (4/13/2010)
... With that in mind, I have a present for you...
Awesome! thanks - it's been added to my code snippets templates.
And as is typical for code coming...
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 14, 2010 at 5:02 am

#1151221
RE: Select a string when data in the string varies

Jeff Moden (4/13/2010)
Heh... ya did it to me again, Wayne. 😉
Hey... ya snooze, ya looze. 😉 😀
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 13, 2010 at 9:05 pm

#1151115
RE: Proper disk configuration reading material

I sure wish that forums could be put into one's briefcase. This one would definitely qualify.
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 13, 2010 at 9:02 pm

#1151114
RE: Select a string when data in the string varies

Bill,
Thanks for the table DDL/DML; however you still haven't specified what the desired output should look like, so I'm making a WAG here. Let us know if this works 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

April 13, 2010 at 8:45 pm

#1151109

Viewing 15 posts - 4,426 through 4,440 (of 5,588 total)