Issue Resolved !!!

Hi,

Thanks. I made little modifications to your first query and it worked.

use prdyppl

select *

FROM company_role_match crm3

left join company_role_match crm on crm.company_id = crm3.company_id and crm.user_id = 547

left...

thanks, but the query i had posted in sql 2000 returns 903 records. So i tried to add filters to ur query as below which returns 0 records.

select *

FROM...

Thanks it worked

Hi

If you see my entire sql it will be a coalesce of many columns. In that one is a datecolumn and i do the following

COALESCE(CAST(ISNULL(IH.[HIRE_VEHICLE_REGISTERED_DATE],'')AS VARCHAR) + ',', '')...

Table structure:

create table A

id1 int,

status int

date created datetime

table B

id2 int

status int

date created datetime

table c

id3 int

status int

date created datetime

table status

id

description

The description field will be like pending, new etc...

i need the...

SET @sql = @sql + 'AND RS.ERROR_CODE = ' + CONVERT(VARCHAR,@p_Error)+ ''

thanks it worked

Yes. For example say, a training session can have many programs. So we pass a session id and it gives many programs.I need to insert all these programs in to...

Hi,

Thanks for ur reply.

I am not using AS400 for connection to db2.

Hi,

Thanks for your reply. The version of db2 i am using is 8.1 and it is the latest one. When i try to connect in db2 control center its connecting...