WayneS

Forum Replies Created

Viewing 15 posts - 766 through 780 (of 5,588 total)

RE: Are the posted questions getting worse?

Hey Brandie... I noticed your LinkedIn profile has you in a new position - are you moving away from SQL, or is this additional stuff that you're piling on yourself?...
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 20, 2012 at 1:43 pm

#1527838
RE: Are the posted questions getting worse?

Lynn Pettis (8/16/2012)
Here is one for the do not hire list.
Or it could be the needs much training list.
I just had to respond.
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 16, 2012 at 3:00 pm

#1526842
RE: sql logics1

Insufficient information to answer:
1. How many rows are in this TOYS table to begin with?
2. As asked earlier, how do the people "see" the "12" rows?
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 16, 2012 at 2:58 pm

#1526841
RE: Are the posted questions getting worse?

SQLRNNR (8/15/2012)
For the Rhode Island SQLSat, how about we all wear kilts?
Is that for speakers, attendees, or all?
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 15, 2012 at 12:31 pm

#1526154
RE: Can't KILL a process

Update: the distributed transaction had to be killed (aborted) in the DTC snapin.
Edit: Link for tracking this down and doing this[/url]
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 15, 2012 at 9:35 am

#1526067
RE: While Loop into a Set Based Insert

Check out the 2 "There must be 15 ways to lose your cursor" articles by RBarryYoung at http://www.sqlservercentral.com/Authors/Articles/RBarry_Young/659055/[/url]. They walk you through pretty much exactly what you need to do.
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 15, 2012 at 8:40 am

#1526027
RE: Can't KILL a process

All that shows up in sys.dm_exec_requests are the transactions being blocked by session id "-2".
And then, just seconds later, it has cleared.
Okay, any ideas of what caused it to clear?
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 15, 2012 at 8:33 am

#1526021
RE: BIT Conversions

buntyteg (8/14/2012)
in correct answer -1,1 is correct
but how 25 is correct
means to say... in bit datatype how we can store 25 (2 digit) value
??????
If it helps, think of 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

August 14, 2012 at 1:50 pm

#1525771
RE: Are the posted questions getting worse?

Stefan Krzywicki (8/14/2012)
Lynn Pettis (8/14/2012)
Brandie Tarvin (8/14/2012)
I get ideas from the weirdest places. I keep threatening to write stories about you people and never do. Well, this debate has inspired...
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 14, 2012 at 12:16 pm

#1525719
RE: BIT Conversions

Hugo Kornelis (8/14/2012)
WayneS (8/14/2012)
One of the things that I'm trying to learn is to write better QotD questions. It looks like most that have responded here about missing it 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 14, 2012 at 8:11 am

#1525538
RE: BIT Conversions

Dana Medley (8/14/2012)
I almost fell prey to the wording of the question, but after reading it twice I realized my original answers were incorrect. Thank you for the great question.
Dana,
I'm...
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 14, 2012 at 7:37 am

#1525513
RE: BIT Conversions

Jan.Sundbye (8/14/2012)
Good one. Once again I fell right into the trap. Must remember to RTFQ / RTFS (Read the **** Question / Statement)
Jan,
I was trying to not have a "trap"....
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 14, 2012 at 7:35 am

#1525508
RE: BIT Conversions

One of the things that I'm trying to learn is to write better QotD questions. It looks like most that have responded here about missing it have acknowledged not reading...
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 14, 2012 at 7:34 am

#1525506
RE: Passing different parameters to the same query

If you want to pass in a ProVerCode, then why don't you try something like this?
WITH cteEnrollm AS
(
SELECT Enrol_ID, ProVerCode, Stude_ID
FROM (
Values
('11111', 'AR-216', '65468'),
('77777', 'AR-216', '54564'),
('22222', 'AR-216', '56475'),
('66666', 'PO-216', '87953'),
('33333',...
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 13, 2012 at 11:32 am

#1525191
RE: Working with Management Studio Solutions

'Cause that's too easy???
Seriously, thanks. It was so obvious. I thought I had ran into problems doing this in the past, but it seems to be working okay right now.
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 13, 2012 at 10:29 am

#1525162

Viewing 15 posts - 766 through 780 (of 5,588 total)