ASP.NET

6:42 AM

hi guys

Ranger

6:55 AM

@ArijitMukherjee hello guy

how are you

ive a sql query

Ranger

fine

2 table with same structure

1 is unique id and other is member id

so i want from table 1 where member id does not exist

select b.* from [RCCloud3_Cloud].dbo.ration_card_member_detail a
join [RCCloud3_Kaith].dbo.ration_card_member_detail b
on a.ration_card_id = b.ration_card_id
where a.member_id != b.member_id

this doesnot work

not exists is also not working

7:00 AM

@ArijitMukherjee\

in SQL

i want to add Header name

For Download Excel File

right click and copy with header

we return table format and Export that to Excel

in SQL i want to add header row

or you can export it in excel

SELECT
glaccount AS 'GL ACCOUNT' ,
controlid AS 'CONTROL #' ,
customerid AS 'CUSTOMER ID' ,
invoicedate AS 'INVOICE DATE' ,
itemno AS 'ITEMNO' ,
quantity AS 'QUANTITY' ,
glamt AS 'GLAMT' ,
netamt AS 'NETAMT' ,
mercfee AS 'MERCFEE' ,
fscount AS 'MYCOUNT' ,
Dcount AS 'DCOUNT' ,
Lcount AS 'LCOUNT' from #temp

here i want to add column header

with this

set @FirstRows = 'Records for ' + Convert(Varchar(Max),Convert(Date,@FromDate)) +' - ' + Convert(Varchar(Max),Convert(Date,@ToDate) )

this @firstRows as header

how i can Add

dont know bro

7:03 AM

ok bro

thankx

@Suresh any idea about my isuse?

@Ranger

Hello guys

have 3 dropdownlist and one hidden button in one page, I using autopostback = "true", its mean every time i selected each dropdown will be trigger the page

the button will be show when 3 drop down list selected.

any idea can replace autopostback ?

7:27 AM

select * from table1 , table2 Where tabel1.rationcardid = table2.rationcardid and table1.memberis != table2.memberid

@ArijitMukherjee

try this one

@KHLIM

in page laod u can check if auto post backor not

@Suresh tried it gives all items from table b instead of a

no your query returns 0 @Suresh

BASICALLY I WANT MEMBERS FROM TABLE A WHERE MEMBERID IN TABLE B DOES NOT EXIST BUT RATIONCARD ID EXISTS

select A.Membername,B.RationCardID from Table1 A , Table2 B Where B.RationCardID = A.RationCArdId and B.MemberID not in (Select MemberID in TableA)

try this

@ArijitMukherjee

r u there

yes

try this one

@Suresh select memberid in table a??\

7:41 AM

yes

Hi guyz

Can anyone clear my doubt?

sorry

u can change whatever this style

@ArijitMukherjee

@mohamedfaisal

tell me

var options = $('#lstRight option');
var values = $.map(options, function (option) {
alert("Text = " + option.text + " Value = " + option.value);
//alert("Values =" + values.forEach);
});

returns 0 @Suresh

This code is working fine.

But I want to know what is happening

Actually I am moving all list box text and values to map.

7:44 AM

@Suresh yes. i using autopostback

you can see variable values. What it contains now

if i don't use autopostback i cannot trigger to show button

any idea ??

@Suresh Do you understand what I am asking?

select A.Membername,(select B.RationCardID from TableB Where B.MemberID not in (Select MemberID in TableA) as RAtioncardID from Table1 A , Table2 B Where B.RationCardID = A.RationCArdId

@ArijitMukherjee

select A.Membername,(select B.RationCardID from TableA Where A.MemberID not in (Select MemberID in TableB) as RAtioncardID from Table1 A , Table2 B Where B.RationCardID = A.RationCArdId

7:48 AM

Now I want to pass a variable on json. Which variable I have to pass? Either option or values?

@mohamedfaisal

Yes

it maps your listbox values and text

@Suresh

u can pass values to JSOn

7:50 AM

var options = $('#lstRight option'); the variabe options contains list of text and values of listbox of #1stRight

which variable I have to pass?

using console.log('options ',options );

then check your browser

F12

click the tab console

it will shows ur Option details

not giving desired result @Suresh

if you dont mine

send me the table details

and ur result table details

`var values = $.map(options, function (option) {
alert("Text = " + option.text + " Value = " + option.value);
});` can you tell me what is this `function (option)`?

ok table 1 has 10.26 lac items and table 2 has 4.07 lacs items out of which 3.94 lacs are common uniqueness is defined from ration_card_id + member_id
so i want all the members from table 2 which are not common @Suresh

i.e 4.07 lacs - 3.94 lacs

7:55 AM

ok done

jst wait i will try

8:06 AM

select B.RationCArdid from tableB B where B.RationCArdid not in (select RationCArdid from tableA)

@ArijitMukherjee

r uther

its retrun only not common values

from table b

u can use memberID instead of rationcard id

create table TableA (UniqueID int identity(1,1), RationCArdid int, MemID int, NAme varchar(MAx), Primary Key(UniqueID))
create table TableB (UniquID2 int identity(1,1), RationCArdid int, MemID int, NAme varchar(MAx), Primary Key(UniquID2))

insert into tableA values(1,1,'a'),(2,2,'b'),(3,3,'c')

insert into tableB values(1,1,'a'),(2,2,'b'),(3,3,'c'),(4,4,'d'),(5,5,'f')

select B.RationCArdid from tableB B where B.RationCArdid not in (select RationCArdid from tableA)

in table B insert (1,2,a), (2,3,b)

and i want these 2 records

ive done it bro wait sending the code

select * from ration_card_member_detail
EXCEPT
(
select a.* from ration_card_member_detail a
join ration_card_member_detail b
on a.ration_card_id = b.ration_card_id and a.member_id = b.member_id
)

inner query select the common items and then select items except that

8:23 AM

super bro