WayneS

Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 5,588 total)

RE: Age

ColdCoffee (5/26/2010)
You can use DATEDIFF function:
LIke:
SET DATEFORMAT DMY
SELECT DATEDIFF(yy,'21-03-1985',GETDATE()) AGE
Since DateDiff returns the number of boundaries crossed in comparing these two dates, it will report the wrong age if today's...
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

May 26, 2010 at 9:35 pm

#1173097
RE: May or may not have to use the pivot table for weekly compare data ?

Check out the two links in my signature for dealing with CROSS-TABS and PIVOTS - this looks like what you'll need.
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

May 26, 2010 at 9:22 pm

#1173096
RE: Selects Within Selects

Rog Saber (5/26/2010)
I'm trying to add some computed fields to my select by adding something like column = (Select count(*)...)
But, it is making the query take a really long time...
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

May 26, 2010 at 6:04 pm

#1173078
RE: Cursors Be Gone! by Gaby Abed, 2010/06/18 (first published: 2008/12/24)

You might want to check out the articles by RBarryYoung on 15 Ways to Lose Your Cursor[/url] - he walks you through it step by step.
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

May 26, 2010 at 5:54 pm

#1173075
RE: Are the posted questions getting worse?

CirquedeSQLeil (5/26/2010)
WayneS (5/26/2010)
Roy Ernest (5/26/2010)
We have lots of PM's and BA's here with degrees. But none has what we commonly call as common sense. I never knew that common sense...
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

May 26, 2010 at 4:23 pm

#1173057
RE: Elegant way to change field to "Identity" type?

Paul White NZ (5/26/2010)
Is the current column defined as NOT NULL? If so, there is a neat trick that makes it almost instant regardless of the number of rows.
Table...
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

May 26, 2010 at 3:25 pm

#1173047
RE: How to setup the file path value without change the code in dev & test & Prod

Use a config file to set up a package variable. Pass the package variable to the script task. Check out this 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

May 26, 2010 at 3:06 pm

#1173039
RE: Are the posted questions getting worse?

Roy Ernest (5/26/2010)
We have lots of PM's and BA's here with degrees. But none has what we commonly call as common sense. I never knew that common sense was not...
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

May 26, 2010 at 2:58 pm

#1173035
RE: SQL 2000 Running Total Reset

You might want to check out Jeff Moden's excellent article on Running Totals[/url].
After doing this, if you have any more problems, come on back!
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

May 25, 2010 at 8:23 pm

#1172439
RE: Can someone help me with this Query

How does this work out for you?
SELECT DISTINCT
e.EMPLID,
e.EMP_STATUS,
e.EMP_IDENTITY,
...
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

May 25, 2010 at 8:13 pm

#1172436
RE: Mulitple Join

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...
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

May 25, 2010 at 7:59 pm

#1172432
RE: how to identify numbers in varchar column

Not a problem... but it does GREATLY help us out... if we can just cut-and-paste some code that creates the problem you're trying to figure out, you will get 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

May 25, 2010 at 7:57 pm

#1172431
RE: Howw to Group by some group

Great job of posting the table DDL, sample data, and expected output! Makes me just want to jump in and help you out.
How does this work for you?
SELECT DISTINCT
...
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

May 25, 2010 at 7:53 pm

#1172430
RE: how to identify numbers in varchar column

-- See how you start off by actually creating a table
-- and then inserting the data into it? Doing this really
-- makes things a lot easier for all 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

May 25, 2010 at 6:51 pm

#1172422
RE: Result Set to Excel OR Text

Jeffery Williams (5/24/2010)
2. I am running SQL 2008 on a 64 bit machine. Some of the things I have tried are giving me problems because of this fact
INSERT INTO OPENROWSET...
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

May 24, 2010 at 7:13 pm

#1171823

Viewing 15 posts - 4,141 through 4,155 (of 5,588 total)