Search results for query: *

Hello, I have a table which contains following data. TableA: ColumnA ColumnB A1 C1 A1 C2 A2 C3 A2 C4 I need to build query which give me follwing output : A1 C1:C2 A2 C3:C4 Can someone help me out. Thanks, Ram

Hello, I have a table which contains following data. TableA: ColumnA ColumnB A1 C1 A1 C2 A2 C3 A2 C4 I need to build query which give me follwing output : A1 C1:C2 A2 C3:C4 Can someone help me out. Thanks, Ram

Hello, I have a table which contains following data. TableA: ColumnA ColumnB A1 C1 A1 C2 A2 C3 A2 C4 I need to build query which give me follwing output : A1 C1:C2 A2 C3:C4 Can someone help me out. Thanks, Ram

Hi, I have a following sample source file. How do I extract data as target table as shown format. I will appreciate if some one help me in this. Source File: Customer: 111 Product code Product Description Amount A123 ABC 100.00 B123...

Friends, table A Product_id Product_Category PRICE 1 A 10 2 A 2 3 A 3 4 B 23 5 C 12 6 D 56 7 A 23 8 A 23 9 C 34 10 D 67 table B Product_id Product_Category PRICE Expected Result for Price 1 A 0 10 2 A 0 2 3 A 0 3 4 B 0 5 C 0 6 D 0...

Friends...!!! How do I find Previous month's first and last day from current date. Thanks, Ram

How do I find lenght of Numeric field in db2...??? For eg. Amount Length (Expected Result) -10202.343 10 19192222.44 11 -292.392 8 Thanks in advance Ram

Hi, I am new to datastage. I have following two simple question 1) How do I use not like function in datastage for eg. DB2: table_name.column_name1 not like '%AB%' datastage: ?? Thanks Ram

What is equivalent of Oracle rownum in db2 ? for eg. Create tabe dept ( deptno number(8) deptname char(10) loc char(10) seq_no nummber(8) ) insert into dept(deptno,deptname,loc,seq_no) select dept_no, deptname, loc...

Hi, How can I write a select statement that will retrieve last monday's date without knowing what today's date is? I know that if today where monday and I wanted to know last monday's date, I could just subtract 7 from today's date. If today were Tuesday, I could subtract 8 and so forth. But is...

Hi, SQL : Select MAX( business_start ) AS business_start from calendar output : 2004-09-01 I need date in 'Sep 01,2004' format in db2. How do I modify above sql to get me this result Thanks in advance.

Hi, How do I write following code in db2. select to_char(calendar.business_start ,'Mon DD,YYYY') AS mtd_bgn_date from dual Thanks,

Help needed in Left Outer Join in Db2 ===================================== Hi, I am migrating Oracle SQL queries to Db2 queries. How do I write following Left outer join in db2. 1) Oracle : ======== Select T1.COL1, T2.COL1, SUM(T2.COL2) FROM T1, ( SELECT MAX(DAY) FROM...

Hi, I have been told by my manager to find out advantage of using Crystal Report vs Business Objects. Could you tell me couple of major advantage of using Crystal Reports vs Business Objects. Thanks,

What is equivalent of Minus Operator (Oracle) in Ms-Access ??

How to get the Oracle's Decode Functionality in MS Access ?

Hi, what is Null function in Ms-access ? Oracle : select nvl(comm,0) from employee; Ms-Access : ?? Thanks, Ram

I have one string data for eg "ABCDE". I want research which table's field in database has this value. how do i do it ? thanks,

I have one string data for eg "ABCDE". I want research which table's field in database has this value. How do i do it ? thanks,

I am using Crystal 8.5 for my report. I have two group in my report. Group 1 :Country Group 2 :City Details : Rep_Name & Sales Amounts Reports Ouput Country= USA Boston Adam 2300 Scott 3000 New York Paul 300 I want to repeat...