WayneS

Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 5,588 total)

RE: why the avatar picture you use

Craig Farrell (2/28/2011)
Some days I think I know exactly how that dog is feeling at that moment...
Heck, when I saw Lowell's avatar, I said to myself "Craig should be using...
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

February 28, 2011 at 1:41 pm

#1292565
RE: Left join in a one to many relationship

Can you verify what version of SQL you're using?
This will work with SQL 2005+ (I changed the tables to be table variables...). If you're on 7/2000, we'll have to change...
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

February 28, 2011 at 1:31 pm

#1292561
RE: clustering

ramyours2003 (2/28/2011)
can any one send me the material of how to install cluster in sql 2008...
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

February 28, 2011 at 11:42 am

#1292494
RE: Transaction logs? Snapshots? What to do?

Patrick Trongo (2/28/2011)
Hey folks,
We have our SQL Servers running on a virtual cluster with fail-over everything.
I've been baby sitting this data for quite a few years, and have always...
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

February 28, 2011 at 11:23 am

#1292476
RE: Creating 2 Rows from 2 fields currently in the same row.

How does this work? (Also... please read the article in the first link in my signature for better ways to post to help us help you - it also makes...
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

February 28, 2011 at 9:45 am

#1292412
RE: Will You Become a Master?

Michael Valentine Jones (2/28/2011)
Mastering skills that may be worthless in five years seems pointless.
I don't really agree with this. While it is true that SQL will continue to evolve and...
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

February 28, 2011 at 9:36 am

#1292409
RE: Odd Questions

amenjonathan (2/28/2011)
Wow if you gave me either of those here's what you're saying: "I'm going to be a pain in your back side. If you hire me, it's your own...
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

February 28, 2011 at 9:11 am

#1292393
RE: Quoting when replying

Frequent problem, and you've corrected pegged it to others posting to the same thread while you were reading it. Just refresh the browser page before clicking the quote button.
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

February 28, 2011 at 8:18 am

#1292342
RE: ERD Software Needed

SQL_Student (2/27/2011)
http://databaseanswers.org/modelling_tools.htm
I did some research online and found a good site. Here's a great place to try all kinds of data modeling products.
Now that is a very good link...
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

February 28, 2011 at 8:09 am

#1292335
RE: Syntax help - split string into separate components

This takes a little bit of:
1. Splitting the string apart into it's delimited parts, and
2. Utilizing some dynamic sql.
For the first part, we'll utilize the DelimitedSplit8K function. Since there are...
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

February 28, 2011 at 7:53 am

#1292324
RE: How to solve this 2 query

Craig - you missed one key thing.
Each table had the required constraint
This probably should have specified that each table had the required CHECK constraint to ensure that data within 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

February 27, 2011 at 7:49 pm

#1292114
RE: Set based trigger with decision to update or insert

Three things to point out:
1. In SQL 2008 (I see you posted in 2005, so this is just for FYI purposes), you could use the MERGE statement to do 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

February 27, 2011 at 7:38 pm

#1292109
RE: How to solve this 2 query

daveriya (2/25/2011)
But i am getting result,whats wrong in this?tell me
How can you tell which row is for registered, and which is not registered?
daveriya (2/27/2011)
group by o f what?registered
Yes.
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

February 27, 2011 at 8:58 am

#1292036
RE: Split coulumn value

infodemers (2/25/2011)
That did niot do the trick!
I found my answer here -->
Thanks anyway!
Are you sure? When I run this code:
DECLARE @test-2 TABLE (Num CHAR(7), Code VARCHAR(50), [Start Date] DATETIME,...
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

February 25, 2011 at 6:56 pm

#1291863
RE: How to solve this 2 query

daveriya (2/25/2011)
2(b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January...
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

February 25, 2011 at 6:48 pm

#1291862

Viewing 15 posts - 1,756 through 1,770 (of 5,588 total)