WayneS

Forum Replies Created

Viewing 15 posts - 4,276 through 4,290 (of 5,588 total)

RE: Optimising Server-Side Paging - Part I

Paul - very nice article. Looking forward to the next ones...
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 26, 2010 at 8:02 am

#1157630
RE: @@Servername

Check out sp_AddServer in BOL.
You'll probably need to run it as:
execute sp_AddServer 'MyServerName', 'LOCAL'
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 25, 2010 at 8:41 pm

#1157437
RE: Special Grouping with ROW_NUMBER

There might be a better way of doing this, but this does get you your desired results:
with cteGroupData AS
(
SELECT Row1 = row_number () over (order by diary_id, row_begin_date,diary_status_text desc),
...
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 25, 2010 at 8:39 pm

#1157436
RE: MCJ - The Missing Link

Jeff Moden (4/24/2010)
Lynn Pettis (4/23/2010)
Jeff Moden (4/23/2010)
[font="Arial Black"]The Oath and Pledges of the ______________[/font] (insert the correct name of the certification. For example, if the name of the certification...
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 24, 2010 at 11:52 am

#1157293
RE: Are the posted questions getting worse?

Adam Machanic (4/23/2010)
... and things get even more interesting. I just got an e-mail from a guy at an organization called the "Network Professional Organization". Apparently they caught wind of...
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 23, 2010 at 6:42 pm

#1157193
RE: Finding previous record based on a single common field.

Thomw (4/23/2010)
I've modified mister.magoo's code to take into account your test table name, and to restrict prior lookups to starting with 'US'.
Does this do what you want?
select [Datetime] = Manpower_Record_Time,
...
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 23, 2010 at 10:02 am

#1156997
RE: Are the posted questions getting worse?

Steve Jones - Editor (4/23/2010)
What gets me is would anyone, Indian or not, talk to you at some event like a TechEd or UG meeting and say "Hey, I wrote...
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 23, 2010 at 9:36 am

#1156973
RE: Are the posted questions getting worse?

Steve Jones - Editor (4/23/2010)
I saw the email late last night from Brad as I was watching a movie with my wife and (wisely) declined to open the laptop.
Tough decision....
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 23, 2010 at 9:27 am

#1156963
RE: Finding previous record based on a single common field.

Thomw (4/23/2010)
WayneS
Thank you for the review of you forum's practices. I apologize for not lurking longer before posting. I had gone back and forth on whether to post 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 23, 2010 at 9:13 am

#1156944
RE: Are the posted questions getting worse?

Adam Machanic (4/23/2010)
Yup: I escalated last night with the INETA board of directors, and the e-mail thread eventually wound up in the hands of one of the INETA India people...
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 23, 2010 at 8:14 am

#1156883
RE: Are the posted questions getting worse?

The Dixie Flatline (4/23/2010)
Roy, I don't believe you personally have anything to worry about in this community.
Roy, I agree. Nothing to do about you, but I do understand how 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 23, 2010 at 8:01 am

#1156862
RE: Are the posted questions getting worse?

Grant Fritchey (4/23/2010)
I can't get through. Looks like they've taken the stuff down.
Looks to me like they've pretty much taken the entire site down!:w00t:
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 23, 2010 at 7:58 am

#1156857
RE: Displaying varchar as time

malavika.ramanathan (4/23/2010)
The client DB has that column in INT.
We must store as NVARCHAR.
So, the INT value 10 should be stored as NVARCHAR "00:10"
Taking Ken's fine code, changing the source 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 23, 2010 at 6:37 am

#1156776
RE: Are the posted questions getting worse?

Paul White NZ (4/23/2010)
WayneS (4/23/2010)
Good, fast job to all for getting this wrong righted!
Getting this copyright wrong righted, right - or wrong?
uhhh... left? yeah? :-P:w00t:
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 23, 2010 at 6:14 am

#1156754
RE: Are the posted questions getting worse?

Adam Machanic (4/22/2010)
Not just his articles. I just checked a bunch of the .NET articles, and some other SQL Server stuff. It's all plagiarized. The entire site is a sham.
http://www.hyderabadtechies.info/index.php/articles/39-articles/707-hyderabad-techies-article
http://www.sqlservercentral.com/articles/Date+Manipulation/69694/
http://www.hyderabadtechies.info/index.php/articles/39-articles/710-hyderabad-techies-article
http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
http://www.hyderabadtechies.info/index.php/articles/39-articles/716-hyderabad-techies-article
http://www.codeproject.com/KB/WCF/WCF_Example.aspx
http://www.hyderabadtechies.info/index.php/articles/39-articles/661-hyderabad-techies-article
http://kb.hogandata.com/afmviewfaq.aspx?faqid=86
http://www.hyderabadtechies.info/index.php/articles/39-articles/672-hyderabad-techies-article
http://dotnetperls.com/substring
http://www.hyderabadtechies.info/index.php/articles/39-articles/639-hyderabad-techies-article
http://www.databasejournal.com/features/mssql/article.php/3867651/SQL-Server-Indexed-Views.htm
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

April 23, 2010 at 5:20 am

#1156713

Viewing 15 posts - 4,276 through 4,290 (of 5,588 total)