WayneS

Forum Replies Created

Viewing 15 posts - 5,086 through 5,100 (of 5,588 total)

RE: SQL brian teaser...

Okay, I pushed my tally table from 30,000 to 1,000,000 records (30,000 / (14 char acct# + comma)) = 2000..... 😀
I get these results when running the code in my...
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

July 3, 2009 at 9:54 pm

#1019898
RE: SQL brian teaser...

@jeff - would you mind trying out this little piece of code and let me know how fast it is on your "computer in a deathbox"?:-D
Also, would you compare the...
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

July 3, 2009 at 9:14 pm

#1019896
RE: rows group by second

lmu92 (7/3/2009)
I'm sorry for not asking all questions I have at once... :blush:
Your example has two rows with 12 rsp 15 seconds.
How would you handle those?
a) add it up...
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

July 3, 2009 at 7:48 pm

#1019890
RE: Substitute publisher server

Roy... do you have a link to that document?
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

July 3, 2009 at 3:50 pm

#1019877
RE: rows group by second

First, I want to thank you for posting the DDL and DML for the test data.
Now, I have a question. What second are you looking for... elapsed, TranIn, or TranOut?
If...
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

July 3, 2009 at 3:28 pm

#1019875
RE: Fields From Record Returned With MAX

@Lynn - it looks like the beginning of your CTE is missing, and the select from it isn't referencing the CTE. Otherwise, very nicely done.
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

July 3, 2009 at 1:37 pm

#1019854
RE: Are the posted questions getting worse?

GilaMonster (7/3/2009)
You laugh. I was speaking with someone recently and he said that he and his team do some SQL development, but nothing complex, no joins or anything.
chuckle...
Makes one wonder......
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

July 3, 2009 at 9:57 am

#1019814
RE: Sum fields accross multiple days

Be careful when using the Between operator with dates.
In your requirements, you basically are saying that your billing date starts promptly at 9am; everything prior to that is the previous...
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

July 3, 2009 at 6:24 am

#1019738
RE: How to making the column name dynamic....

only4mithunc (7/3/2009)
Ok.... any way once again thanks a lot...
Regards
MC
I'm glad that we could 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

July 3, 2009 at 6:08 am

#1019731
RE: Unable to insert Dynamic Database Name

John Marsh (7/2/2009)
Hello Wayne,
You can find a definition of irony here: http://www.askoxford.com/concise_oed/irony?view=uk
You may like to spend your time writing code to duplicate logic already provided elsewhere but that does not...
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

July 3, 2009 at 5:59 am

#1019727
RE: problem with parameters multivalue in ssrs

If I remember correctly (and it's been a year since I did any SSRS), just remove the "(0)".
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

July 3, 2009 at 5:49 am

#1019721
RE: Are the posted questions getting worse?

Dave Ballantyne (7/3/2009)
Generally i try to 'teach a man to fish'.
But really, come on give it a try.....
http://www.sqlservercentral.com/Forums/Topic746875-49-1.aspx
Well Dave, it seems that you did help him. http://www.sqlservercentral.com/Forums/FindPost746898.aspx
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

July 3, 2009 at 5:47 am

#1019719
RE: Unable to insert Dynamic Database Name

Nag,
Yes, sp_msForEachDB is an undocumented system stored procedure. Which just means that google will have the information you need for how to use it.
What I find ironic is the suggestion...
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

July 2, 2009 at 9:39 pm

#1019567
RE: Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

GilaMonster (7/2/2009)
WayneS (7/2/2009)
Is there a way to tell when / how often a file has grown in the past?
Default trace, for as far back as it goes.
Thanks Gail!
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

July 2, 2009 at 5:06 pm

#1019522
RE: Need Date out of DateTime in Text Field

latingntlman (7/2/2009)
I need to pull the date only from a text field that contains the date and time in it. I tried using convert but it hasen't worked, so 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

July 2, 2009 at 5:03 pm

#1019521

Viewing 15 posts - 5,086 through 5,100 (of 5,588 total)