Search results for query: *

Hi all, I have a Stored Proc I am trying to optimise. Theres a select statement in there which puts a value into a variable which is then used further down in the SProcedure. What I want to do is pre-run this stage so add a value to a variable and then be able to run the Stored Proc which...

Hi all, I have a huge Stored Proc (T-SQL) that I need to get some information on. I want to put in print statements at specific points of the procedure to get back the timestamp, How can I get the timestamps of specific points? GETDATE()? Thanks for any suggestions,

Hi all, I am trying to match the following: $text = "abcdef-TO"; if($text =~ /-TO/){ #do something here } This doesnt seem to work, something to do with the "-" as in "-TO"? I have tried escaping it but no joy, any help much appreciated, Cheers,

Hi all, I have 2 HashArrays: %a %b %a contains the following key/value pairs: Forward/Value %b contains the following key/value pairs: Curve/Forward What I need to do is create a new HashArray that is a combination of %a and %b and has the following key/value: Curve/Value Any assistance...

Hi could someone tell me if its possible to join 2 hash arrays together in Perl? Thanks,

Hi all, I have a csv file which is comma seperated and around 500mb. The string that I am searching on is _INDEX" in the file and what I need to do is find this string and then print out the full word that contains _INDEX. The issue is that the word _INDEX may not occur in the same place on...

Hi all, I have an array which muliple values in it and what I wanted to do is add the 5th element of the array to a new array which only stores unique values. I would normally do this in shell scripting but wanted to learn some Perl so any suggestions would be much appreciated, Thanks,

Hi all, I have some data that Im working on: ,qwerty1,data1,data2,data3 ,,,,,,,,,,,,,,,,,,,2005 ,,,,,,,,,,,,,,,,,,,2006 ,,,,,,,,,,,,,,,,,,,2007 ,qwerty2,data1,data2,data3 ,,,,,,,,,,,,,,,,,,,2008 ,,,,,,,,,,,,,,,,,,,2009 ,,,,,,,,,,,,,,,,,,,2010 In my code I want to get to the point where I...