Viewing 15 posts - 31 through 45 (of 112 total)
Oops I got my environments mixed up. I am actually working in Visual Studio .Net and my code is C#. Your code is the equivalent of my code in C#....
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
May 4, 2012 at 12:56 pm
Actually none of this is documented. They are unable to give me documentation at all on the processes other then high level business processes that were created years ago. They...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 27, 2012 at 3:12 pm
That is the rosey side of it. But what do you do when their business requirements contradic themselves? When they refuse to see that they do and the next week...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 27, 2012 at 2:43 pm
Opc.three and Craig thank you very much for you advice and efforts in sharing your knowledge. I do very much value your replies. Thanks.
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 4, 2012 at 9:33 pm
opc.three (4/4/2012)
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 4, 2012 at 9:33 pm
opc.three (4/4/2012)
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 4, 2012 at 9:32 pm
opc.three (4/4/2012)
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 4, 2012 at 9:30 pm
opc.three (4/4/2012)
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 4, 2012 at 9:28 pm
Thanks Lynn for the code. Yes, I think you paraphrased it pretty well. The moving around of the file is the file and it's data being processed and moved to...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 4, 2012 at 3:53 pm
The ID column will never be changed. It is a chronological record of a file moving from one place to another. The only purpose outside that for the table is...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 3, 2012 at 9:16 pm
Preferred in your mind but in your mind you don't know what my table structure and business requirements are.
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 3, 2012 at 5:08 pm
Thanks opc.three. To answer your question, it isn't an identity column, it is an ID that is meant to track a file through-out it's journey on the network. So there...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 3, 2012 at 3:34 pm
This seems to work and has the added benefit of incrementing the ID by one which will work nicely with my next insert statement:
CREATE PROCEDURE [dbo].[spGenerateID] ...
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
April 3, 2012 at 10:38 am
Just to be closure to my post. I decided to copy the file to a staging folder and do the hash on that file. Seems to work really well.
TeraByteMe (3/28/2012)
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
March 29, 2012 at 6:47 pm
opc.three: Once again you surpass the brilliant. That is a great suggestion. I love the way you think!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
March 28, 2012 at 9:24 pm
Viewing 15 posts - 31 through 45 (of 112 total)