Search results for query: *

SQL Server 2008 R2 64 bit - running a windows 2008 24 CPU's 50GB Ram Issues below happen also on a smaller spec pc table with 144 fields 17 million rows 7.5GB data size file index IX_COMP_movements_PolNum - non clustered columns policynumber asc compoundkey asc average index row size - 406...

Hi all, been ask to do a small audit table of logins, and respective reports, and I have come out with some SQL which does do what I need. But can't help and wonder if there would be another way of doing it without using cursors or temporary tables. sample schema, data and code below...

Hi all, Been looking the net for this and could not find it - maybe not possible, or different search criteria required. Basically I am looking for a way to create and enforce a Windows group policy at domain level to force particular settings for SSMS, mainly the text editor options for tabs...

Hi all, Been trying to get our printers to print the Euro symbol and been unlucky so far from doing it unless I manually change my files to include PCL codes. Any help I can get from here would be great. All our files are plain text without any PCL or control characters. the only character...

Hi all, Quick question for those of you that work with datawarehouses. Would there be any situation where it would be advisable to store a date (just date, not time) as a integer, and if so why would that be. Please do not consider the possibility of having a primary key of a date table to...

Hi all, Company I am at the moment is doing a migration from MF version 2.2 to 5.1 and we come across one particular problem which im posting below. If anyone had had this experience and has been able to solve it with some compiler/runtime directive it would be great if I could have it. Old...

Ok. Have done the SQL below, it works, but I think theres a better way of doing it, so would like to see what others say about it. At the bottom of this post there is code to create the required tables and populate them with sample data. Real tables have 2million records, with around 500k...

have a look at thread1662-1609753 although it is on a Oracle database, if it can be done with standard Ansi SQL it will be fine with me. Regards Frederico Fonseca SysSoft Integrated Ltd www.syssoft-int.com FAQ219-2884 FAQ181-2886

hi all, Need help with the following. I know I can do this using temp tables, but looking for another solutions if it makes it easier I have to give a list of items id's to our testers that include all the possible combinations of item_id/category in order to make their life easier...

Hi all, Just looking for some guidance on what would be the best option(s) to set up our new COBOL environment on this mix. MF Cobol Server Express 5 - latest version of the compiler AIX 6 Oracle 11. we will be working on 64bit mode Intention is to look at what are the best options with...

Hi all, As part of my work I have sometimes to reconcile lists of amounts in such a way that any combination of them matches a particular value or list of values. sample. a=-100 b=-20 c=20 d=250 e=350 f=700 g=100 I want to find the possible combinations whereby adding 1 or more values match...

Hi all, I'm having a bit of a problem with checking the return codes from a EXEC CICS VERIFY PASSWORD command. Code as follows WORKING-STORAGE SECTION. 01 WSBB-PASSWORD PIC X(8) VALUE SPACES. 01 WSBB-USERID PIC X(8) VALUE SPACES. 01 WSBB-RESP-CODE PIC S9(8) COMP...

Hi all, This is a question that was raised back in 2004 on thread209-773928 - Netcobol for windows and FarPoint Spread 6.0 problem (so Gianny if you are there and have the solution please enlighten us). Situation again. Power COBOL V7, 3rd party OCX control, properly licensed. When run in...

Hi all, Just created a new FAQ on how to use Fujitsu NetCOBOL with ADO, as Fujitsu themselves are very poor in helping people with howto's. faq209-5475 Enjoy. Regards Frederico Fonseca SysSoft Integrated Ltd www.syssoft-int.com

Hi all, I would like to hear your comments on the following situation. Background. Foreign IT Contractor working for a multinational (short term contract). Company policies are 1- Free internet access outside working hours 2- No restrictions on received calls outside working hours 3- Normal...