WayneS

Forum Replies Created

Viewing 15 posts - 2,986 through 3,000 (of 5,588 total)

RE: Finding Sequences (Need help ASAP)

Here's some code.
Note that I kept in the prefix checking... I need to strip it out anyway, so I just kept it in.
-- need to add some columns to 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

October 7, 2010 at 10:54 am

#1233774
RE: Finding Sequences (Need help ASAP)

craig-404139 (10/6/2010)
Please skip to post Post #1000624 for updated requirements.
It's actually post # 1000643. Also, if you click the post number, you will get a URL that you can...
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

October 7, 2010 at 10:13 am

#1233741
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/7/2010)
Alvin Ramard (10/7/2010)
CirquedeSQLeil (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.
Sounds like a college exam to me. Or...
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

October 7, 2010 at 9:31 am

#1233709
RE: set @t1=(select sum(a) from order where type='1') + (select sum(b) from order2 where code='3')

Gianluca Sartori (10/7/2010)
WayneS (10/7/2010)
try:
set @t1=IsNull((select sum(a) from order where type='1'),0) + IsNull((select sum(b) from order2 where code='3'),0)
... ok, it was me! 🙂
:w00t::hehe::-P
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

October 7, 2010 at 8:30 am

#1233628
RE: Query row count across several databases

Here's an alternative way that doesn't require verifying if the table exist, and doesn't perform a count(*) against the table if it does:
IF OBJECT_ID('tempdb..#TEST') IS NOT NULL DROP TABLE #TEST;
CREATE...
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

October 7, 2010 at 7:59 am

#1233585
RE: set @t1=(select sum(a) from order where type='1') + (select sum(b) from order2 where code='3')

try:
set @t1=IsNull((select sum(a) from order where type='1'),0) + IsNull((select sum(b) from order2 where code='3'),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

October 7, 2010 at 7:43 am

#1233564
RE: Finding Sequences (Need help ASAP)

Jeff Moden (10/7/2010)
So... without me running all the code presented so far, what has been decided? Does the numbering restart for each prefix or not?
Haven't heard back from 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

October 7, 2010 at 7:41 am

#1233560
RE: Finding Sequences (Need help ASAP)

Andrew - I'll test out your modifications tonight. Interesting the large difference in time between our systems.
Thanks for making the change to use the same # of characters for 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

October 7, 2010 at 7:04 am

#1233512
RE: Puzzling backup issue

Okay, I am seeing the IO frozen/thawed messages in the sql log, so it does appear that NT backup is the culprit. Time to work with the SAs to fix...
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

October 7, 2010 at 6:51 am

#1233489
RE: Are the posted questions getting worse?

Brandie Tarvin (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.
Apparently it's my turn to feel snippy. I couldn't resist.
IMO, 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

October 7, 2010 at 6:29 am

#1233459
RE: Finding Sequences (Need help ASAP)

Craig Farrell (10/6/2010)
WayneS (10/6/2010)
craig-404139 (10/6/2010)
Question: when a prefix changes, do the numbers restart at 1? Or do they continue?
(I've got some real nifty, high-speed code (thanks to Jeff!) to quickly...
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

October 6, 2010 at 7:07 pm

#1233229
RE: Finding Sequences (Need help ASAP)

Craig Farrell (10/6/2010)
Edit: Sorry for the multi-edit. Something didn't play nicely with the code= statements when I tried to first post this.
The Test Harness:
SELECT TOP 1000000
IDENTITY(INT, 1,1) AS N
INTOTally
FROM
Master.dbo.SysColumns...
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

October 6, 2010 at 6:54 pm

#1233226
RE: DeadLock

Craig Farrell (10/6/2010)
WayneS (10/6/2010)
Research links, no. But I've seen deadlocks caused by parallelism before myself... so self-research - yes.
Well, in that case, Amit, try a MAXDOP 1 and see 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

October 6, 2010 at 6:45 pm

#1233224
RE: DeadLock

Craig Farrell (10/6/2010)
WayneS (10/6/2010)
Craig Farrell (10/6/2010)
Answer: No and no.
This code, as is, will not deadlock independently. There's no transaction calls.
What is the serverwide setting for isolation?
Craig, did you consider...
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

October 6, 2010 at 6:32 pm

#1233219
RE: Finding Sequences (Need help ASAP)

craig-404139 (10/6/2010)
Craig Farrell (10/6/2010)
craig-404139 (10/6/2010)
Craig Farrell (10/6/2010)
Craig,
Is it safe to assume that this field will alway end in numerics? If so, I may have a simple solution for 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

October 6, 2010 at 6:25 pm

#1233216

Viewing 15 posts - 2,986 through 3,000 (of 5,588 total)