Search results for query: *

thanx guys.. works ! i used the code from james as George used temp02 which i am alreayd using for sometign else. Not to say that it wouldnt have worked but i felt james solution was easier.. thanx again M.Bajwa http://www.nextgenlogic.com/bajwa

You say it is pulling back more than one transmittal number (TRANSMITTAL_NR ) are there multiple records with transmittal number (TRANSMITTAL_NR ) number as '01980000' ?? SELECT Distinct COMPANY AS Co, DIVISION AS Div, FIN_TRANS_DT, TRANSMITTAL_NR AS TransNum, AMOUNTS_1 / 100 AS Debit...

I have two temp tables in a stored procedure.Both have a date field. suppose #temp01 has 1000 company records and #temp03 has 100 company records. The 100 companies in #temp03 are already included in #temp01. I need an updat estatement where I need the date field from #temp03 to over write the...

got the problem solved guys.. even though I used 3 temp tables ! thanx a bunch M.Bajwa http://www.nextgenlogic.com/bajwa

hope someone is happy NOW :P M.Bajwa http://www.nextgenlogic.com/bajwa

Hey as far as "customer" or "current" is concerned, I meant current. thanx for catching that. date values do have time with them too ! M.Bajwa http://www.nextgenlogic.com/bajwa

Well we have a problem. Apparently I did not state the requirements right. I went back and checked and there are some customers who for instance place orders right away when they are entered into our database . So the very first entry for these customers would show them as "customer" instead...

hey J. Not to take anythign away from you but now that i see the solution i think it is pretty easy.. shud have figured it out ! Anyways.. its always good to kow someones "got ur back !" will get back to you with more problems soon :P M.Bajwa http://www.nextgenlogic.com/bajwa

we have tons of prospective customers in our database and whenever they call we have an audit table in the database where an entry is made. Now once the customer makes a purchase the audit table changes the customer type from prospective to current. I need to find the dates of all thes customers...

well.. u r right.. I just wanted to save the user some time by giving him all the prompts in one page instead of choosing an option .. clicking next page . then choosing another option.. I guess thats not possible ! M.Bajwa http://www.nextgenlogic.com/bajwa

By Not possible , do you you not possible in one page or not possible at all ? I have seen it working on multiple pages for eg I have a report which asks for the state in one page and the next page it will show me zip codes for that specific state which was chosen ! SO this just confirms that...

I am looking Into Making cascading Prompts. I know how to make the cascading prompts using different power prompt Pages. Like the prompts on the 2nd power prompt is generated based upon whats chosen in the 1st one. I was wondering if this all can be done in one page only . How do i get all the...

We are usign Cognos Impromptu and currently we have users log on to the cognos web interface with a serparte username and password. I was wondering if there was a way to use Active Directory authentication vs LAE file Any ideas on where to start with ? M.Bajwa http://www.nextgenlogic.com/bajwa

hey sylve . sorry i couldn't try this for quite a while. I always thought it would take quite a while to implement this. Anyways i got down today and in about 2 minutes , I had the query running because of your bright idea. Thanx a bunch. My next mission is to schedule a cron job to email me...

Thanx guys. I will install the apps and get back to you guys with the results by tommorow. M.Bajwa http://www.nextgenlogic.com/bajwa

sorry for not making that clear earlier LloydSev. I do have the option of connecting by both name and IP but i prefer IP to bypass any DNS issues. M.Bajwa http://www.nextgenlogic.com/bajwa

When u say computers in the room. are these computers desktop machines that dont leave the room or are these student laptops which they bring in themselves ? If these are desktop machines you could simple set the nearest printer as the default one and that should take care or it. M.Bajwa...

I am in a fix here. I have a computer at a remote location. It is not a branded computer and was custom made at home. Now I need to get it upgraded. I first want to start off with a memory upgrade. I only have access to this machine using VNC and have no physical access. As far as the specs of...

No.. thats not an issue bill. Even though it has the last IP saved. once you start the application , you can change it then which I do. So its not a matter of looking for that registry M.Bajwa http://www.nextgenlogic.com/bajwa

lol.. this certainly has turned out to be quick a HI LEVEL technical thread ! As far as the lan which has pc2 is conerned here are the spec. it is a simple home network with a LINKSYS router . the linksys router has DHCP enabled Now as LloydSev talked about the inmternal DNS on the that...