And right here on SSC

http://www.sqlservercentral.com/Books/

and

http://www.sqlservercentral.com/Forums/Topic1122014-391-1.aspx

Try the Redgate site,

http://www.red-gate.com/?utm_source=google&utm_medium=cpc&utm_content=brand_aware&utm_campaign=redgate&gclid=CK2zp9SUp6kCFRG4KgodEhwWtg

You might want to test this.

DECLARE @String VARCHAR(200)

SET @String = 'Microsoft Windows Server 2003 R2 Standard Edition|C:\WINDOWS|\Device\Harddisk0\Partition1'

SELECT SUBSTRING(@String,1,PATINDEX ( '%|%' , @String) -1)

Result:

Microsoft Windows Server 2003 R2 Standard Edition

For SQL Server 2005 Expess Edition

Edition ...

a) On a recurring schedule

Using Google "sql server scheduled job"

You should get About 285,000 results (0.16 seconds)

b) without Using SSIS

Use Google "SQL Server Bulk Export"

You should...

Here is group of date calculations that you might find very useful

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

A question. You must now use "Business days", does that exclude holidays? If so search...

I like the idea of looking at each of the business aspects rather than the mechanical aspects of the data flow but I think becuase of the lack of understanding...

The problem and details of the input are well known to yourself, but not to those who would like to assist you.

Can you supply sample data, database table definition ......

You appear to be concentrating on what I would term the "mechanical" aspects. What I would deem that should be included, is a word description of what the desired...

For example, the data you supplied was "20110531095841", apparently May...

You might use something like this to achieve what you require.

DECLARE @T VARCHAR(15)

DECLARE @X VARCHAR(20)

SET @T = '20110531095841'

SET @X = (SUBSTRING(@T,1,4)+'-'+SUBSTRING(@T,5,2)+'-'+SUBSTRING(@T,7,2)+' '

+SUBSTRING(@T,9,2)+':'+SUBSTRING(@T,11,2)+':'+SUBSTRING(@T,13,2))

SELECT CONVERT(SMALLDATETIME,@X,101)

Result: 2011-05-31 09:59:00

1. To "see" the records it is termed a SELECT statement. For example SELECT Column1, column2...

Read this article, it may be what you require.

http://www.sqlservercentral.com/articles/ASP.NET/66511/

Revenant (5/31/2011)

---

Ron aka bitbucket-25253,

According to GAAP, for each change to business data there has to be a "ledger correction document." DBA should not touch the DB without a copy...

I am rather appalled that all the answers to date are so narrowly concerned with T-SQL, scripts, etc., to "correct" the so called errors.

There appears,...