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...

Currently I have the following which seems pretty useful: SET STATISTICS TIME ON --Code here SET STATISTICS TIME OFF

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, Sorry ignore this thread the above is working fine I had another condition in there which was preventing this from working correctly, Cheers,

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 Thanks for the response, If you could explain this line in a bit more detail that would be really useful as Im new to Perl, Thanks,

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,

The line in the source file is: abc,def,ghi,klm,HELLO_TEST,xyz The following identifies that this line contains _TEST in one of the fields. grep {/_TEST/} @commArray Once its been identified that the line contains _TEST all I need to do is print out the word on the line that contains...

Thanks for the suggestions, The above suggestion matches the lines with _INDEX but then I need to get the word on that line (which in the following example is HELLO_TEST) and print that out, e.g. if the line contains: abc,def,ghi,klm,HELLO_TEST,xyz I need to identify that this line contains...

Hi, Currently I am doing the following: open (COMMFILE,"<$commfile") || perror ( "Could not open $commfile for input\n"); @commArray = <COMMFILE>; #Loop through the file to get list of the allowed comm types foreach $commElem (@commArray) { @allowedCommodities = split(/,/, $commElem)...

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,

Thanks for the quick response, I dont think Ive explained the issue properly. Once I get to the line matched qwerty1 what I want to do is force Perl to go to the next line untill I get to a line natching qwerty2, Help is much appreciated,

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...