WayneS

Forum Replies Created

Viewing 15 posts - 2,386 through 2,400 (of 5,588 total)

RE: column value balancing (copy previous value <> NULL)

This form of the update statement has special rules for running in this manner. They MUST be followed, or your data can be made wrong. See comments in code 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 17, 2010 at 2:08 pm

#1252155
RE: BDE x SQLServer (2005/2008) - Compatibility mode

Fernando,
Just to make sure that I'm on the right page with you, BDE is the Borland Database Engine? If so, the BDE was last updated to work with the SQL...
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 17, 2010 at 1:41 pm

#1252142
RE: sql server 2005 databases move to a new server

Ann Cao (11/17/2010)
Thank you, that's helpful.
But I don't have any ssis packages on the server, but I do have some maintainance plan and some application jobs in sql server jobs.
Since...
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 17, 2010 at 1:38 pm

#1252139
RE: SQL Query - Number of days between two dates, grouped by month

Remarks are in the code. Hope this helps.
DECLARE @StartDate datetime,
@EndDate datetime,
@days ...
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 17, 2010 at 1:13 pm

#1252126
RE: replace credit card numbers with *

Craig Farrell (11/17/2010)
As a note, you comment that you were instructed to write a script that shows the CC numbers with all but the last 4 as *s.
GOOD CATCH!
If 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 17, 2010 at 12:18 pm

#1252096
RE: sql server 2005 databases move to a new server

Ann Cao (11/17/2010)
We will restore sql 2005 to another new sql 2005 server.
We plan to name the new computer something else first, then after restore, turn off old server, 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

November 17, 2010 at 12:14 pm

#1252094
RE: Get the Current Date

Well, BOL does say (for CURRENT_TIMESTAMP)
This function is the ANSI SQL equivalent to GETDATE.
I guess they really mean it's an alias for 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 17, 2010 at 11:43 am

#1252072
RE: column value balancing (copy previous value <> NULL)

Dick Herberts-320552 (11/17/2010)
Hi ,
Wow , sounds too good to be true. Do you have an example , Please help
Regards,
Dirk
@? Is your name Dick, or Dirk?
Can you verify also:
1. 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 17, 2010 at 11:36 am

#1252065
RE: Comma Delimited List from Query

kknobloch (11/17/2010)
I have a Stored Procedure that returns a comma delimited list (ex: one, two, seven, nine) - when I pull this into SSRS 2008 rather than it displaying...
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 17, 2010 at 11:29 am

#1252056
RE: SSIS on a cluster.

SSIS is not licensed separately, and it is in fact installed on all of the cluster nodes during the installation. If MS had a problem doing it this way, 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 17, 2010 at 11:24 am

#1252050
RE: Populating a new column in a SQL2K table with incremental numbers by row

Clinton Finch (11/17/2010)
@Wayne - that worked great - thank you!
I did make one error in my answers to your questions: the PK is clustered. Don't know...
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 17, 2010 at 11:20 am

#1252044
RE: SSIS on a cluster.

One small thing you need to do when running SSIS on a cluster.
On each node, go to the C:\Program Files\Microsoft SQL Server\100\DTS\Binn directory, and modify the MsDtsSrvr.ini.xml file.
On the line...
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 17, 2010 at 9:38 am

#1251966
RE: Get the Current Date

I think SSIS is using .Net functions. It would support current_timestamp in an ExecuteSQL task.
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 17, 2010 at 9:02 am

#1251948
RE: replace credit card numbers with *

I have to agree with Steve - if this is what you came up with after seeing the solutions posted here, then you need to STOP and get someone 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 17, 2010 at 8:24 am

#1251925
RE: Gap in Dates

GrassHopper: What version of SQL are we dealing 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 17, 2010 at 7:26 am

#1251885

Viewing 15 posts - 2,386 through 2,400 (of 5,588 total)