WayneS

Forum Replies Created

Viewing 15 posts - 2,536 through 2,550 (of 5,588 total)

RE: Need advice on database integration

A trigger would work. You could also just run a job every 1 or 2 minutes to check for the presence of data, and do it's work if it's there.
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

November 5, 2010 at 7:04 am

#1247094
RE: Are the posted questions getting worse?

Hey gang - can I get your thoughts on using TFS to deploy database changes?
Thanks!
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

November 5, 2010 at 7:00 am

#1247090
RE: Row_number() over (partition by ....order by)

You might want to read my article that covers this at SQL Server Ranking Functions[/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

November 5, 2010 at 5:24 am

#1247048
RE: What's the definitive book on SQL Server DB design?

Try any of Louis Davidson's books. He is extremely good (I had the opportunity to work with him over a decade ago - he is very sharp, and has only...
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

November 4, 2010 at 6:19 pm

#1246930
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/4/2010)
Grant Fritchey (11/4/2010)
CirquedeSQLeil (11/4/2010)
Has anybody here contemplated changing their name (besides bob err ".") for the forums? I am curious if anybody much cares about the confusion that...
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

November 4, 2010 at 5:30 pm

#1246920
RE: Are the posted questions getting worse?

Chad Crawford (11/4/2010)
CirquedeSQLeil (11/4/2010)
Has anybody here contemplated changing their name (besides bob err ".") for the forums? I am curious if anybody much cares about the confusion that...
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

November 4, 2010 at 5:28 pm

#1246918
RE: Database roles

K. Brian Kelley (11/4/2010)
Here's where things get really nice. If you assign a permission at a scope level, such as GRANT EXECUTE ON SCHEMA::dbo TO ReportingUser, then any object contained...
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

November 4, 2010 at 3:39 pm

#1246896
RE: Extracting time from string

Check out the SubString, PatIndex and CharIndex functions.
Others that may prove useful to this are Left, Right, and Reverse.
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

November 4, 2010 at 1:31 pm

#1246795
RE: Total of records per set of seconds

You are still building the tally table Row-By-Agonizing-Row (RBAR).
It would be better to do it in a set-based fashion, such as is described in the article that I referenced 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

November 4, 2010 at 11:57 am

#1246743
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/4/2010)
GilaMonster (11/4/2010)
Gianluca Sartori (11/4/2010)
Nothing to complain about today?
Plenty, but I think most people are tired of hearing me whine about the Nightmare Project.
Nah - do tell.
I agree.
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

November 4, 2010 at 11:32 am

#1246719
RE: Are the posted questions getting worse?

Brandie Tarvin (11/4/2010)
And if she chooses not to, a new topic of discussion. I'll start.
TOPIC: Things you should never tell your parents
How those footprints *really* got on the ceiling.
ceiling...
This...
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

November 4, 2010 at 11:31 am

#1246717
RE: Total of records per set of seconds

Taking what GSquared and Jason suggested, try this out and see how it works for you.
SET @Seconds = DATEDIFF(second, @StartDate, @EndDate);
WITH CTE AS
(
SELECT TimeOfDay = DATEADD(second, N, @StartDate)
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

November 4, 2010 at 10:50 am

#1246686
RE: Columns in Row

dubem1-878067 (11/4/2010)
Thank, it works
Can this be done with a PIVOT?
You're welcome.
Sure, it can be done with a PIVOT. Actually, that is a pivot, it's just not using the PIVOT clause....
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

November 4, 2010 at 10:33 am

#1246672
RE: Columns in Row

You just need to join and perform an aggregate calculation between the tables:
SELECT t.IDTask,
t.Name,
[StatusA] =...
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

November 4, 2010 at 8:18 am

#1246568
RE: Domain user minimum privilegies to run SQL Services (SQL, Analisis and Report Server)

Adiga (11/4/2010)
This article explains the permissions that the SQL Server service account needs to have.
Now that is a good like to have bookmarked.
Thanks!
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

November 4, 2010 at 7:57 am

#1246546

Viewing 15 posts - 2,536 through 2,550 (of 5,588 total)