Click here to Skip to main content
15,899,663 members

Comments by Arvind_singh (Top 17 by date)

Arvind_singh 21-Nov-11 17:01pm View    
any action we should want only aspx page show in runtime only plain text not html .i m also remove all the content of aspx source page but this give html i want only plain text ;
Arvind_singh 2-Jul-11 6:55am View    
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[Sp_GetCompanyAddressNew]
@ContactTypeId as numeric(9)
as
begin
select distinct isnull(convert(varchar,Address1),'')+' '+isnull(convert(varchar,Address2),'')+' '+isnull(convert(varchar,Address3),'')+'*'
+isnull(convert(varchar,city.Name),'')+'-'+convert(varchar,PinCode)+'*'
+isnull(convert(varchar,state.Name),'')+','+convert(varchar,Country.Name) as address
from TblsubCompanyAddress SVA
Left outer join TblAddressBook City on SVA.City=city.AddressID
Left outer join TblAddressBook State on SVA.State=state.AddressID
Left outer join TblAddressBook Country on SVA.Country=Country.AddressID
where SVA.AddTypeId= @ContactTypeId
end
This is store procedure in in two database object Impact and Impact2 when we run this inside the impact this is working but when we run inside Impact2 this is not working this is return null values but both database table is same ......
Please give me solution
Arvind_singh 7-May-11 5:55am View    
But I Know your psychic is not working Properly ..........
Arvind_singh 18-Apr-11 5:47am View    
Thanks Sir
Arvind_singh 12-Apr-11 7:03am View    
Thanks Sir ,Code is Successfully running