WayneS

Forum Replies Created

Viewing 15 posts - 3,181 through 3,195 (of 5,588 total)

RE: Need help in this query

Craig Farrell (9/15/2010)
sql.abhishek (9/15/2010)
I am desperately looking for some piece of code to get this type of out put .... kindly help me out of this.
For the code, you'll really...
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

September 15, 2010 at 2:42 pm

#1221706
RE: OK This is a weird one

You're quite welcome. Glad I could help.
jeff.mason (9/15/2010)
I don't know what I would do when stuck in a rut without a place like this. With so many of 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

September 15, 2010 at 2:25 pm

#1221687
RE: Finding the two highest values for a criteria

Derrick Smith (9/15/2010)
You mean you want to pull the two most recent orders for each product, sorted by OrderDate, and then display the corresponding OrderNumber, right?
FelixG (9/15/2010)
I need to get...
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

September 15, 2010 at 2:10 pm

#1221672
RE: OK This is a weird one

jeff.mason (9/15/2010)
Yeah, I know, I feel stupid too. What can I say, it was 11:30 PM, we are tired, and stuck in a rut for troubleshooting. We attacked...
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

September 15, 2010 at 2:03 pm

#1221666
RE: Finding the two highest values for a criteria

Something like this should get the top two of each:
DECLARE @Orders TABLE (ProductCode int, OrderDate datetime, OrderNumber varchar(5));
INSERT INTO @Orders
SELECT 1, '20100915', '11112' UNION ALL
SELECT 1, '20100823', '11122' UNION ALL
SELECT...
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

September 15, 2010 at 2:00 pm

#1221661
RE: i want to join more than two table using left or right outer join

Yes.
select t1.*
from dbo.table1 t1
LEFT JOIN dbo.table2 t2
ON t1.col1 = t2.col1
...
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

September 15, 2010 at 1:50 pm

#1221652
RE: OK This is a weird one

jeff.mason (9/15/2010)
I think I am going to kill that developer tomorrow....
Why wait that long? A 5 minute start is all he should get... :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

September 15, 2010 at 1:47 pm

#1221647
RE: Alternatives for nested cursors

Craig Farrell (9/15/2010)
WayneS (9/15/2010)
Craig Farrell (9/15/2010)
[EDIT:] Heheh, Wayne, fastest code gun in the west. 🙂 [/EDIT]
Maybe, but sometimes it's draw,shoot,aim instead of aim,shoot,draw... heh, wait-a-minute... :crazy:
And thus, we find...
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

September 15, 2010 at 1:41 pm

#1221643
RE: OK This is a weird one

INSERT INTO dbo.ContractItems
(
Trading_Partner_ID,
Corp_Item_Num,
ContractID,
IsRebateEligible,
ChangedDate,
ChangedUser
)
SELECT
cs.Corp_Item_Num,
cs.Trading_Partner_ID,
ContractID,
0 IsRebateEligible,
GETDATE() ChangedDate,
SUSER_SNAME() ChangedUser
Are the items in bold in the wrong order?
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

September 15, 2010 at 1:37 pm

#1221639
RE: add value 0 to a datetime column in sql with SSIS

Wouldn't you use DT_DBDATE instead of DT_DBTIMESTAMP? Also, try replacing the "/" with "."
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

September 15, 2010 at 1:30 pm

#1221633
RE: Alternatives for nested cursors

Craig Farrell (9/15/2010)
[EDIT:] Heheh, Wayne, fastest code gun in the west. 🙂 [/EDIT]
Maybe, but sometimes it's draw,shoot,aim instead of aim,shoot,draw... heh, wait-a-minute... :crazy:
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

September 15, 2010 at 1:08 pm

#1221622
RE: Are the posted questions getting worse?

Hey you'll...
I know a lot of people don't like Joe Celko's online personna. You might be interested in how his tone changed in this thread after it was discovered 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

September 15, 2010 at 11:07 am

#1221543
RE: Replacing substring with a substring

No problem - glad I could help.
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

September 15, 2010 at 11:02 am

#1221540
RE: Social Engineering Dangers

Eric Russell 13013 (9/15/2010)
The problem with social engineering and digital authentication is that it involves information that can be easily forged. If I call someone up and say I'm from...
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

September 15, 2010 at 10:58 am

#1221535
RE: add value 0 to a datetime column in sql with SSIS

Since this is a character field, what happens to a date that just happens to contain a zero (like year 2010, or days 10, 20, 30)? You might need 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

September 15, 2010 at 10:47 am

#1221525

Viewing 15 posts - 3,181 through 3,195 (of 5,588 total)