how i can add parameters in to it?

No Its not work if i set Run64bit false

Thanks it works

I cant. file coming form client is excel file.

Select distinct SCode, Spec from CLEANSED_DATA

where State ='NC' and Application_Header_ID=82 and Ntwk_ID='NCN201' and File_Type='Provider'

and SCode not in

(select Spec_Code from vw_Geo

where State='NC' and File_Type='Provider' and

Application_Header_ID=82 and...

Its Development so less record but in future when it deploy in production then it has large amount data going to insert. so what is suitable fill factor for...

so not worry right?

table has 3500 records

CREATE NONCLUSTERED INDEX [INX_NONCLUSTER_State]

ON STATE_COUNTY_CODES(State)

with (FILLFACTOR=80)

CREATE TABLE STATE_COUNTY_CODES(

[County_Name] [varchar](150) NULL,

[State] [varchar](2) NULL,

[State_County] [varchar](5) NULL,

[County_Type] [varchar](15) NULL,

[State_ID] [int] IDENTITY(1,1) NOT NULL,

PRIMARY KEY CLUSTERED

I need to read only one cell.

not entire file

Thanks for giving solution.

I had try like if I enter new data like gl code CA700-40165_Home Dt Canada - Expedited Air' then its work but old data which already in table that cant...

I had compare the string without white space string is like ' 602-401165_Planning - Expedited Air' but it not find record from table By the way that record...

Yes I also try it but show me nothing if string has space then it not show the result

Hello

I had tried but don't work I had check there is data same but not showing