How often will you be doing this comparison? Daily, Hourly, Every millisecond, as part of another process, etc...?

may be 7-8 times a day

How many records are you talking about comparing...

Wow.. thats somthing i dont get it..

i might go with inline..

so how do i set the

and rh.CREATED_DATE between @StartDate and @endDate in the same inline query ?

Is there any way without using inline SQL.

hi, i cannot do anything about the database design now ...

now i understand the criteria that both columns datatypes needs to match...

So, as a work around could i go...

ok good. as a new developer in the team am not sure if i would be allowed to modify table to add extra column with my permission levels here... and...

correction :

No not all po_num can be converted as varchar INTbecause some values are char's so those cannot be converted as INT.

so, i am trying to convert Orderheader_ID into varchar...

No not all po_num can be converted as varchar because some values are char's so those cannot be converted as INT.

so, i am trying to convert Orderheader_ID into varchar...

hi , po_num is the column which is varchar from other table that because that could names in the columns too. and OrderHeader_ID in OrderHeader table is INT only.

so, about...

thank you all. i appriciate your help 🙂

i will probabaly save server/database details on tables and pull them up to build a connstion string to call values from those database...

yes , i understand the dynamic synonym creation too. 🙂

i was thinking to aviod the dynamic sql in the SP like ( set @sql = ‘select *...

can i have like 10 diff synonyms (which has 10 linked serves mentioned in 10 sysnonyms).. and............

in my SP...

if @ID = 1

//use Synonym1

if @ID = 2

...

currently we are storing those linked server/database details in a table and retrieving the values in SP based on the condtions .

now we are trying to aviod building the connection...

i mean 10 different synonyms created for 10 different linked servers am pointing to.

hi,

i wouldnt know which linked server i need to point to untill query in in SP decides it.

so after that i am trying to use related synonym (one...