Viewing 15 posts - 196 through 210 (of 26,487 total)
could be worse jeff - I called a colleague over for some guidance on who wrote some code... he talked me through the 5000 line long proc with cursors,...
March 4, 2020 at 5:31 pm
Is this a good example of someone who may have picked the wrong thing to do with their lives?
https://www.sqlservercentral.com/forums/topic/ssis-package-error-22
oh man i wish i was in that stream...
March 4, 2020 at 5:03 pm
Lynn Pettis the collation of tables was changed as i point in the post 1.
But the Sqlsever database Views are in different Collation any advise how to set those...
March 3, 2020 at 2:01 pm
How to you get 26 different columns from the string 'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P'? I see 6 at most. Where are the other 20 coming...
March 3, 2020 at 1:55 pm
don't - I went once and it was "an experience" (this is from Wikipedia)
Kæstur hákarl, fermented Greenland shark.
Súrsaðir hrútspungar, the testicles of rams pressed in blocks, boiled and...
March 2, 2020 at 4:53 pm
Nothing wrong with COBOL!!!! and still use it on my shop.
I had to convert a Cobol system (well part of a Cobol system, as I didn't...
February 29, 2020 at 6:09 pm
Nothing wrong with COBOL!!!! and still use it on my shop.
I had to convert a Cobol system (well part of a Cobol system, as I didn't finish it)...
February 29, 2020 at 6:08 am
Different subject and a bit of a rant/warning.
I went into work this morning as I needed to work with a coworker, basically a code review of changes I was making. ...
February 28, 2020 at 11:22 pm
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone...
February 28, 2020 at 11:06 pm
I'm going to be pedantic (surprise! Surprise!). What do you mean by "return info" from a procedure? Technically if it returns a single value the programming structure is a...
February 28, 2020 at 10:46 pm
I doubt that using PRINT to return information is used on a regular basis. The only time I use PRINT for the purpose is for debugging a procedure I am...
February 28, 2020 at 1:34 pm
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.
In my...
February 28, 2020 at 12:34 pm
Is this coming to you in a file?
You beat me to that question, Lynn. If it is (and I think this is where your going with this), we...
February 27, 2020 at 9:03 pm
There is a potential gotcha with this syntax:
WHERE [Invoice Date Key] BETWEEN '2014-01-01' AND '2014-12-01'
The data types of the table in this example are of "date"...
February 27, 2020 at 5:53 pm
Viewing 15 posts - 196 through 210 (of 26,487 total)