Viewing 15 posts - 196 through 210 (of 1,315 total)
I created a CMS with an instance name and duplicated your problem. There is no way to use SERVER\INSTANCE in the SQLRegistration path.
I was able to see the CMS...
March 6, 2015 at 11:34 am
Word files are going to look normal when viewed in Word, or another application that understands the Word file format. Same with xls, PDF, and so on. The...
February 9, 2015 at 1:26 pm
DATEDIFF does not compute the timespan and round it off to an integer number of the given time unit. It just counts how many boundaries of the given time...
February 9, 2015 at 1:16 pm
I had similar problems with a Teradata linked server. There was no way to use the Teradata linked server that did not perform horribly compared to an Access application...
February 9, 2015 at 12:14 pm
Louis's code puts the entire remainder in the first payment, which is technically what you asked for. Another approach would be to add 0.01 per month to make up...
January 29, 2015 at 2:25 pm
The Table3 results are consumed by the UNPIVOT operator, producing a new derived table with the alias UP. So the Table3 alias in out of scope in the outermost...
January 29, 2015 at 1:26 pm
With you around here Jeff, I figured it wasn't up to me to post another article comparing all possible string splitting techniques. I've enjoyed your articles on string splitting,...
January 23, 2015 at 1:58 pm
Your string can be turned into valid XML with three REPLACE functions, then you can use XML functions to do all the parsing. Assuming none of the possible RR...
January 22, 2015 at 3:20 pm
A CMDEXEC job step should be able to run the command "MOVE C:\Temp\Ack\*.dat C:\Temp\Reports".
If you want to use the File System Task in an SSIS package to move the files,...
January 22, 2015 at 1:41 pm
The number of database files is unrelated to the number of backup files. The database will be restored with the same file structure it had when backed up.
If the...
December 17, 2014 at 2:38 pm
Step 1 would be to figure out how to write code to make a web request and save the response to a file, in a .Net framework language. This...
December 17, 2014 at 2:11 pm
Are you sure the problem is with the column collation and not the XML encoding? I have experienced XML imports from people who banged a bunch of text together...
December 17, 2014 at 1:22 pm
You could also use nested CASE functions to avoid repeating the Server_Excluded test.
CASE WHEN Server_Excluded <> 'Yes' THEN
CASE WHEN Aged30 > 0 THEN 'Green'
...
October 29, 2014 at 9:59 am
Since I was playing with your code without any schema, everything was underlined with red squiggles so it was hard for me to see which fields had underscores and which...
August 20, 2014 at 11:14 am
Those should be END_DT, which I believe is the what I originally posted.
August 20, 2014 at 8:23 am
Viewing 15 posts - 196 through 210 (of 1,315 total)