WayneS

Forum Replies Created

Viewing 15 posts - 4,696 through 4,710 (of 5,588 total)

RE: Tally table and substring error

Okay, try N <= len(@input). It doesn't fix your issue, but it does now work on the whole string.
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 2, 2010 at 11:05 am

#1127293
RE: Tally table and substring error

Lowell,
If you substitute this for the end of your code, you will see that @input does not end with a CRLF... just a CR. Maybe this 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

March 2, 2010 at 11:00 am

#1127290
RE: update 2 tables at once

Exactly what I was thinking. (also didn't like 4 updates going on...)
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 25, 2010 at 10:41 pm

#1125355
RE: SARGable

The "correct" answer doesn't have a column in the where clause... how can that be SARGable?
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 25, 2010 at 10:38 pm

#1125353
RE: update 2 tables at once

ray-SQL (2/25/2010)
Try this, not sure it handles all of your scenarios, so more sample data would be good. But it is working for what you given us.
I've modified what 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

February 25, 2010 at 9:53 pm

#1125341
RE: update 2 tables at once

ray-SQL (2/25/2010)
Try this, not sure it handles all of your scenarios, so more sample data would be good. But it is working for what you given us.
It's looking good 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

February 25, 2010 at 9:23 pm

#1125336
RE: SSMS extension to allow categories/organise DBs

callum.bundy (2/25/2010)
Hello,
After having a discussion with someone regarding how SSMS organises databases in the list (i.e. alphabetically) I was wondering if anyone had ever created an addon for it that...
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 25, 2010 at 9:07 pm

#1125334
RE: Dude, Your Fly is Open

Daniel Hallam (2/25/2010)
We here have a team mascot of Fozzie Bear from the Muppets. He sits on the desk of whoever messed up last. We've even attached a bicycle horn...
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 25, 2010 at 9:05 pm

#1125333
RE: Two queries that should be returning the same # of rows are not returning the same # of rows, how can that be?

Asha.Richardson-1129890 (2/25/2010)
to Wayne:
Basically, your change worked as long as I put in a few column names, but when i just ran your query, I got this message:
Msg 421, Level 16,...
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 25, 2010 at 9:02 pm

#1125332
RE: Need SQL Statement To Increment A Column Sequen. In A Group

GilaMonster (2/25/2010)
Compat mode is controlled by the current DB context, not the source and destination of the data
Okay, I made it through the day and finally learned something new! Good...
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 25, 2010 at 3:21 pm

#1125255
RE: Two queries that should be returning the same # of rows are not returning the same # of rows, how can that be?

Asha.Richardson-1129890 (2/25/2010)
I have two query's here. One is a select statement to verify the # of rows I am going to update, the ohter is the actual update statement....
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 25, 2010 at 3:14 pm

#1125251
RE: update 2 tables at once

dbaltazar (2/25/2010)
The sample data already given is realistic but I'll work on getting more.
This would be appreciated.
AcctID+FundID are the key between the 2 tables.
Okay, understood.
I want to loop thru payment...
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 25, 2010 at 10:58 am

#1125117
RE: update 2 tables at once

Yes... and all of your sample data is for 1 account, and 1 fund, on one date. How do we tell that the $75 payment goes to the first pledge,...
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 25, 2010 at 10:41 am

#1125111
RE: update 2 tables at once

First, please provide the table structure information, and test data via "CREATE TABLE" / "DECLARE @TableVar TABLE" and "INSERT" statements (see the first link in my signature for how 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

February 25, 2010 at 10:37 am

#1125107
RE: SQL Server Version (T-SQL)

Based on what Lowell started, how does this work for you?
select case convert(tinyint,PARSENAME(convert(varchar(20),SERVERPROPERTY('productversion')),4))
when 8 then 2000
...
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 25, 2010 at 9:56 am

#1125083

Viewing 15 posts - 4,696 through 4,710 (of 5,588 total)