WayneS

Forum Replies Created

Viewing 15 posts - 2,281 through 2,295 (of 5,588 total)

RE: Need help building a query.

Jeff Moden (11/24/2010)
Ram2002 (11/24/2010)
Thanx Criag. I appreciate all you ppl in this post time.
This was the first post so went wrong. Next time will be in appropriate forum.
Except for...
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 24, 2010 at 4:59 pm

#1255397
RE: Calculate dates an individual lives in apartement each month

See??? Instrumental! :-D:-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

November 24, 2010 at 4:52 pm

#1255394
RE: char() vs. varchar()

dpulliam3 (11/24/2010)
Thanks Wayne for the reply. I must have missed the "actual length" part in the BOL.
No problem.
@jason: if you find that blog, I'd be interested in seeing 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

November 24, 2010 at 4:08 pm

#1255381
RE: Calculate dates an individual lives in apartement each month

stan-617410 (11/24/2010)
Wayne, Thank you for your persistence and patience.
No problem. To be fair, Lutz and Ron were pretty instrumental in getting this solved also!
Is this working right for you now?
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 24, 2010 at 4:03 pm

#1255378
RE: Calculate dates an individual lives in apartement each month

LutzM (11/24/2010)
WayneS (11/24/2010)
:blush: (not again!!!) This should do it this time!
...
@Lutz: thanks, but it's reporting the days in the following months as zero, not the proper days. It comes down...
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 24, 2010 at 4:00 pm

#1255375
RE: char() vs. varchar()

dpulliam3 (11/24/2010)
I have done research and I am not finding any detailed information about what I am looking for regarding char() vs. varchar().
Example:
If you have 2 columns, one defined as...
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 24, 2010 at 3:52 pm

#1255372
RE: Need help building a query.

How does this work for you?
-- need a temporary table with a clustered index on emp_id + auID,
-- enforce PK on the auID, and add an identity column 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

November 24, 2010 at 3:10 pm

#1255356
RE: Need help building a query.

Craig Farrell (11/24/2010)
Ram2002 (11/24/2010)
Unfortunatly i have to do this on MS SQL 2000. So can i have the equivalent for MSSQL2000 please.
There isn't one. You're going to have 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

November 24, 2010 at 3:00 pm

#1255352
RE: Calculate dates an individual lives in apartement each month

:blush: (not again!!!) This should do it this time!
-- See how this starts off with a table and data in it?
-- If you had provided us the data in 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 24, 2010 at 2:29 pm

#1255340
RE: Need help building a query.

Ram2002 (11/24/2010)
Unfortunatly i have to do this on MS SQL 2000. So can i have the equivalent for MSSQL2000 please.
FYI: you posted this in a SQL 2008 forum, so 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 24, 2010 at 2:15 pm

#1255330
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/24/2010)
WayneS (11/24/2010)
CirquedeSQLeil (11/24/2010)
WayneS (11/24/2010)
Speaking of Joe... he's asking for help at http://www.sqlservercentral.com/Forums/Topic1026157-391-1.aspx
Don't have a good answer for that. My initial response would be go take some math classes...
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 24, 2010 at 1:40 pm

#1255316
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/24/2010)
WayneS (11/24/2010)
Speaking of Joe... he's asking for help at http://www.sqlservercentral.com/Forums/Topic1026157-391-1.aspx
Don't have a good answer for that. My initial response would be go take some math classes at 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 24, 2010 at 1:31 pm

#1255312
RE: Are the posted questions getting worse?

Craig Farrell (11/24/2010)
I've been there and noticed that. Where they really want you to go from there is your local retailer (ANSI for USA), which can be found here:http://webstore.ansi.org/SdoInfo.aspx?sdoid=39&source=iso_member_body
Type...
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 24, 2010 at 1:24 pm

#1255306
RE: Are the posted questions getting worse?

Alvin Ramard (11/24/2010)
WayneS (11/24/2010)
WayneS (11/24/2010)
Craig - I thought about posting this over "there", but decided to keep this to us threadizens.
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/iso-11179-naming-conventions
(Just gotta love how it starts out by talking...
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 24, 2010 at 1:20 pm

#1255304
RE: Previous Month Function

DateDiff(month, -1, '20100901')
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 24, 2010 at 1:01 pm

#1255296

Viewing 15 posts - 2,281 through 2,295 (of 5,588 total)