Viewing 14 posts - 1 through 14 (of 14 total)
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...
November 17, 2011 at 1:14 pm
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 ?
November 4, 2011 at 11:16 am
Is there any way without using inline SQL.
November 4, 2011 at 11:11 am
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...
June 27, 2011 at 8:32 am
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...
June 24, 2011 at 4:43 pm
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...
June 24, 2011 at 4:32 pm
No not all po_num can be converted as varchar because some values are char's so those cannot be converted as INT.
June 24, 2011 at 4:31 pm
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.
June 24, 2011 at 4:24 pm
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...
March 28, 2011 at 10:29 am
yes , i understand the dynamic synonym creation too. 🙂
i was thinking to aviod the dynamic sql in the SP like ( set @sql = ‘select * from …’...
March 25, 2011 at 2:17 pm
can i have like 10 diff synonyms (which has 10 linked serves mentioned in 10 sysnonyms).. and............
in my SP...
if @ID = 1
if @ID = 2
March 25, 2011 at 1:41 pm
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...
March 25, 2011 at 1:23 pm
i mean 10 different synonyms created for 10 different linked servers am pointing to.
March 25, 2011 at 1:19 pm
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...
March 25, 2011 at 1:17 pm