WayneS

Forum Replies Created

Viewing 15 posts - 3,526 through 3,540 (of 5,588 total)

RE: recursive or a better way to solve this problem

thava (8/28/2010)
this way is slow when i used a large amount of data so i want change it for that, i need a little explanation there, could you provide...
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

August 28, 2010 at 6:30 am

#1213405
RE: Implementing Either This One OR these two Logic

Jack Corbett (8/27/2010)
WayneS (8/27/2010)
Jack Corbett (8/27/2010)
Wayne,
Thanks. This is a very nice solution, but as you said at the end, it definitely meets US requirements, but I can't say 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

August 27, 2010 at 10:22 pm

#1213378
RE: SQL SERVER 2000 DataType Definition

This link will give you some good answers.
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

August 27, 2010 at 10:13 pm

#1213377
RE: Missing sequence number

Jeff Moden (8/27/2010)
I love programming on this old machine... if I can make it run fast on the old machine, things pretty much cook when someone runs it on 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

August 27, 2010 at 10:06 pm

#1213375
RE: Excel Colum Formatting

Jeff Moden (8/27/2010)
WayneS (8/27/2010)
Using OpenRowset/OpenDatasource, it can't be done.
However, you can accomplish the formatting by:
1. Use the Export wizard.
2. Use a SSIS package.
3. Use the sp_OA procedures to perform OLE...
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

August 27, 2010 at 10:01 pm

#1213373
RE: Adding a back button on a child report

Are you rendering this in a browser? Because on the child report all you have to do is click the browser's back button... or press backspace.
If you are rendering 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

August 27, 2010 at 9:57 pm

#1213372
RE: Missing sequence number

Jeff Moden (8/27/2010)
You folks already have the split thing pretty much down pat so I'll just demo another method for detecting and displaying "gaps". I haven't tested every method...
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

August 27, 2010 at 7:37 pm

#1213358
RE: Implementing Either This One OR these two Logic

Jack Corbett (8/27/2010)
Wayne,
Thanks. This is a very nice solution, but as you said at the end, it definitely meets US requirements, but I can't say that it will 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

August 27, 2010 at 3:47 pm

#1213300
RE: Try...Catch not catching

Brandie, you could just change your code to:
Create Procedure spMySillyProc (@Varme)
AS
BEGIN TRY
IF @Varme = 1
PRINT 'Tag, you are it.'
ELSE
BEGIN
...lots of code...
INSERT INTO dbo.MyTable (GoodCol1, GoodCol2, BadCol)
...
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

August 27, 2010 at 3:39 pm

#1213298
RE: How to know what user created a table?

To track this information going forward, you could put in a database level trigger.
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

August 27, 2010 at 3:33 pm

#1213297
RE: The most bizarre SQL issue ever

SQLWannabe (8/27/2010)
.5. WayneS, love the avatar. LOL!!!
Thanks! You can imagine that I feel like doing that a lot.
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

August 27, 2010 at 3:24 pm

#1213293
RE: How to Pivot using T-SQL

sqlbi (8/27/2010)
Thanks for your help i solved the issue..
here im entering dates manaully and i dont want to do that.. is there any solution to solve it?
Yes. Dynamic pivot...
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

August 27, 2010 at 3:21 pm

#1213290
RE: parameters = NULL

Great! but it's only fair to tell us how.
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

August 27, 2010 at 3:18 pm

#1213287
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/27/2010)
BTW, to a large extent, Monday's editorial (Aug 30) is meant for you citizens of The Thread.
Thanks for the support.
Hmmm. Now this is going to have...
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

August 27, 2010 at 3:16 pm

#1213285
RE: Are the posted questions getting worse?

David Burrows (8/27/2010)
WayneS (8/27/2010)
Sigh. (Bang head on desk).
How to do troubleshooting 101...
PBKAC 😀
Most definitely!
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

August 27, 2010 at 11:14 am

#1213122

Viewing 15 posts - 3,526 through 3,540 (of 5,588 total)