WayneS

Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 5,588 total)

RE: ERD Help

I would also suggest not having spaces in table/column names. Personally, I prefer where each word starts with a capital letter, ie. SoldItems.
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 6, 2010 at 10:49 pm

#1247432
RE: Are the posted questions getting worse?

Jack,
It sounds like the doctor's are really on top of this, and that in time Evan will be 100%. I'm very sorry that he had this accident, and that 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

November 6, 2010 at 10:44 pm

#1247431
RE: Are the posted questions getting worse?

LutzM (11/5/2010)
I hope he does since it helps parents too to deal with such a situation...)
Isn't this the truth. Parents tend to be OMG and all stressed out - kids...
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 3:50 pm

#1247362
RE: CTE and Union All

See the edit I made in the query.
I would have to agree with Pam... what's the purpose of this? It would be simpler to just run the one query.
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 3:35 pm

#1247360
RE: ERD Help

1. Tables are usually plural, ie. Sales, Products, Customers, Employees, etc. (they're not holding just one record, are they?)
2. In your deliveries, you have a SalesRecieptNum field. Is this 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

November 5, 2010 at 3:03 pm

#1247343
RE: Are the posted questions getting worse?

Jack Corbett (11/5/2010)
Diagnosis is in. Displaced fracture about 2 inches below the elbow which requires surgery to be set properly. Local ortho doesn't do kids (which makes me...
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 2:54 pm

#1247339
RE: CTE and Union All

Janie.Carlisle (11/5/2010)
Hi. I wrote a query to select the Top25 records from my dataset. I now want to write another query to select the records that are NOT in 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 5, 2010 at 12:28 pm

#1247285
RE: Need Calculation Performed Without Modifying Base Table(s)

Keep in mind that you won't be able to update this view. Since it seems like your issue is with the number of rows being printed on a report, then...
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 12:22 pm

#1247282
RE: Are the posted questions getting worse?

Roy Ernest (11/5/2010)
Ah Crap and double crap. Hurricane Tomas is threatening again. It is turning to the east and the tail is once again coming over the island. Why cant...
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 12:13 pm

#1247275
RE: Collation Problem

gbd77rc (11/5/2010)
Hi All,
After some more digging around I have isolated it to the fact when the database was originally created they had mix collations in the table creation scripts (these...
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 11:33 am

#1247255
RE: need help find overlapping dates in a table

If you need help in understanding the APPLY operator, check out that link in my signature. (That article links to another - both are excellent for understanding APPLY.)
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 11:13 am

#1247245
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/5/2010)
jcrawf02 (11/5/2010)
By the way, thanks Jason for the link and Steve for the presentation last night, I had to drop off about 7:40 your time but enjoyed what I...
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 9:05 am

#1247179
RE: Precautions to take when using TFS?

Thanks a bunch guys! Grant, I'm real interested in looking at that book when it's out.
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 8:04 am

#1247141
RE: Are the posted questions getting worse?

Grant Fritchey (11/5/2010)
WayneS (11/5/2010)
Hey gang - can I get your thoughts on using TFS to deploy database changes?
Thanks!
Posted. Hope that helps.
Thanks Grant, it does. Is it a good assumption 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 5, 2010 at 7:59 am

#1247138
RE: Enterprise Management

We utilize SSIS and the "Server Overview" articles written here (now I have to go look it up so I can post the link). A job fires off this package,...
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:15 am

#1247107

Viewing 15 posts - 2,521 through 2,535 (of 5,588 total)