WayneS

Forum Replies Created

Viewing 15 posts - 4,216 through 4,230 (of 5,588 total)

RE: Are the posted questions getting worse?

If anyone would care to comment on this SQL 2008 Upgrade Advisor message, I would really appreciate 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

May 6, 2010 at 9:06 am

#1163317
RE: Differences between sql server 2008 and 2008 R2

This might help you somewhat.
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

May 5, 2010 at 7:39 pm

#1162915
RE: Give users access to databases depending on which Active Directory group they are a member of.

You might want to take a look into DDL triggers.
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

May 5, 2010 at 7:30 pm

#1162913
RE: Need help with a query

lmu92 (5/5/2010)
Might be agood idea to turn it into an article...
Yes, it would. Which reminds me... are you writing one based upon that post last year where you found something...
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

May 5, 2010 at 7:27 pm

#1162912
RE: Need help with a query

lmu92 (5/5/2010)
I would rather recommend you to modify the related sp's not to use DATEPART() anymore. Instead of using DATEPART(dw,...) you could use DATEDIFF(dd,'19000101',YourDate)%7. This will ALWAYS return 0 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

May 5, 2010 at 5:10 pm

#1162879
RE: SQLServer Agent 'sed' job reporting success; but does nothing

johnzabroski (5/5/2010)
Sample data:
"1"|"7"|"D"|"2"|"_"||05/25/2007|05/25/2007|10.00|2.15
Should be:
"1"|"7"|"D"|"2"|"_"|""|05/25/2007|05/25/2007|10.00|2.15
First, thanks for the sample data.
In going with Lynn's suggestion, let's first load this stuff into a temp (aka staging) table.
IF OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE...
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

May 5, 2010 at 4:49 pm

#1162871
RE: Are the posted questions getting worse?

Paul White NZ (5/5/2010)
Hey Wayne,
How come your 2008 server is still at RTM? You're missing some pretty important fixes :crying:
:blush: it's the dev edition on my work laptop..... we're...
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

May 5, 2010 at 1:38 pm

#1162741
RE: A round number

Paul White NZ (5/4/2010)
Thanks Wayne, that's very useful! My only remaining question is what versions of SQL Server (engine and SSMS) you are running. I guess they are...
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

May 5, 2010 at 8:00 am

#1162453
RE: A round number

Paul White NZ (5/4/2010)
Results so far for SELECT ROUND(0.5, 0) for me:
Paul, this question has turned into a very interesting topic.
I also have isqlw / isql for SQL 2000 available,...
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

May 4, 2010 at 1:28 pm

#1162058
RE: Missing numbers in a series

Paul White NZ (5/4/2010)
My objective would be to get close to Jeff's rocket code performance here, I don't think there's much chance of a win...but hey I am awesome so...
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

May 4, 2010 at 7:51 am

#1161807
RE: Are the posted questions getting worse?

Lynn Pettis (5/3/2010)
jcrawf02 (5/3/2010)
Lynn Pettis (5/3/2010)
Do we need to draw a picture of what we are requesting?
reference: See Wayne's Avatar
Yes, that is exactly what it feels like. 😛
Glad you noticed......
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

May 3, 2010 at 7:53 pm

#1161570
RE: Are the posted questions getting worse?

Paul White NZ (5/3/2010)
Gianluca Sartori (5/3/2010)
I think Paul wants to join the "world's worst procedure" competition... :-P.
I would have put some more BREAK / CONTINUE in it and maybe...
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

May 3, 2010 at 2:38 am

#1161143
RE: FOR XML PATH command is altering data, trying to determine the cause.

mister.magoo (5/2/2010)
Here is a quick example (using WayneS sample code)
declare @test-2 TABLE (RowID int IDENTITY, Data varchar(200))
insert into @test-2
select 'some regular text' UNION ALL
select 'email: <bob.jones@domain.com>' UNION ALL
select 'Tom &...
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

May 2, 2010 at 12:19 pm

#1161009
RE: String splitter to table weird result

Digs (5/1/2010)
Jeff,
All works fine: And Fast !
I will keep your name on my list when I need to spend $$$ on my project .
Minutes have gone down to seconds...
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

May 2, 2010 at 8:52 am

#1160993
RE: FOR XML PATH command is altering data, trying to determine the cause.

As to the "Why", check out this link.
One thing to note there is that you can utilize a processing-instruction (thanks Jason & Paul!). So, this code might help you out.
declare...
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

May 2, 2010 at 8:16 am

#1160991

Viewing 15 posts - 4,216 through 4,230 (of 5,588 total)