Viewing 15 posts - 1,186 through 1,200 (of 3,221 total)
And right here on SSC
http://www.sqlservercentral.com/Books/
and
http://www.sqlservercentral.com/Forums/Topic1122014-391-1.aspx
June 8, 2011 at 2:44 pm
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
June 6, 2011 at 4:06 pm
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...
June 6, 2011 at 3:21 pm
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...
June 3, 2011 at 3:48 pm
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...
June 3, 2011 at 6:51 am
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 ......
June 2, 2011 at 4:39 pm
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...
June 2, 2011 at 12:06 pm
river1 (6/2/2011)
"If everything seems to be going well, you have obviously overlooked something"Sorry didn't understood? what did you meant by that?
For example, the data you supplied was "20110531095841", apparently May...
June 2, 2011 at 10:26 am
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
June 2, 2011 at 8:16 am
let you to see the records,update as well as delete the records.
1. To "see" the records it is termed a SELECT statement. For example SELECT Column1, column2...
May 31, 2011 at 5:53 pm
Revenant (5/31/2011)
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...
May 31, 2011 at 12:51 pm
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,...
May 31, 2011 at 12:03 pm
Viewing 15 posts - 1,186 through 1,200 (of 3,221 total)