Salim Fayad - All Comments

re: Arabic Textbox Control

Knowledge Seeker — Mon, 30 Jan 2012 05:28:14 GMT

Great Job Man!!!!!!!!!!

Is it possible to type the english with same style... I.e cursor wont move form the origin place.

re: Arabic Textbox Control

Deepak — Mon, 30 Jan 2012 05:16:59 GMT

dis control not supporting mozilla ,gopogle chrome except IE,so is the solution for tht..kindly let me know...

re: Rows to Columns

Carole C — Tue, 17 Jan 2012 19:54:16 GMT

The Rows to Columns worked GREAT!

I tried a number of suggestions that did not work.

Thanks so much!

re: Rows to Columns

crauzer — Wed, 04 Jan 2012 23:35:06 GMT

how can you read:))

re: Database Schema Comparison Using Simple Queries

Ken — Wed, 04 Jan 2012 19:39:27 GMT

I just thought there should be a comment from a non-spam actual human who actually read through your code. Nice work man.

- cheers!

re: Rows to Columns

hussein — Tue, 13 Dec 2011 18:23:00 GMT

well done but i want to ad another colume peside degre names degre1 how can apply that

re: Arabic Textbox Control

Rson — Tue, 29 Nov 2011 05:31:31 GMT

not work in mozilla

re: Rows to Columns

Sandeep — Thu, 17 Nov 2011 06:45:40 GMT

Can we get column Sum(Physics) i mean Physics SUM for all students as a row (like footer...)

re: Rows to Columns

mieow — Tue, 15 Nov 2011 12:41:09 GMT

I solved it up..

needs to add proper group by statements...

re: Rows to Columns

mieow — Tue, 15 Nov 2011 06:50:14 GMT

Can u please elaborate on how to do this for strings ?

what I want is like this :

select aID,sum(Bcode),RCode,ISCode,SEcode

from(

SELECT distinct(aID),

(CASE areftyp WHEN 'Bcode' THEN NVL(arefnum, '') END) AS Bcode,

(CASE areftyp WHEN 'RCode' THEN NVL(arefnum, '') END) AS RCode,

(CASE areftyp WHEN 'ISCode' THEN NVL(arefnum, 0) END) As ISCode,

(CASE areftyp WHEN 'SEcode' THEN NVL(arefnum, 0) END) AS SEcode

FROM table_ref where aID=2) a

;

where Bcode,RCode,ISCode and SEcode are strings...

and result I am getting for the inner query is :

aID Bcode RCode ISCode SEcode

2 MAKD (null) (null) (null)

2 (null) nmj (null) (null)

2 (null) (null) jfh77 (null)

2 (null) (null) (null) (null)

2 (null) (null) (null) 76745