Sorry, correction...

i needed to get data from a single tbale by checkinf with 2 different tables (in whcih one of the table is on other server)...

🙂 thank you for your help.

i am new to SQL...

hi,

thank you for quick reply.

so that is not a system default trigger?

hi,

it worked for me. i was not comparing the right columns to match the data.

Thank you for you help.

i tried this..

SELECT a.rewardCode , b.FirstName

FROM tblCodes a JOIN tbloffer b on (a.RewardCode = b.code) WHERE b.code != null

but it didnt work for me.. could you please help me

i tried this..

SELECT a.rewardCode , b.FirstName

FROM tblCodes aJOIN tbloffer b on (a.RewardCode = b.code) WHERE b.code != null

but it didnt work for me.. could you please...

So, Could that help me to keep track of the recent updates on the table row updates?

So using Timestamp could i keep track of recent updates on the table row values?

So using Timestamp could i keep track of recent updates on the table row values?

hi,

compcatidno is not a unique constraint...

and datatypes for both the filelds are same.

and when i execute that statemet i get an error message like....

"Only one expression can...

Hi Imu92,

How are you doing. Nice to see your reply regarding my post again.

Huhh!! am still facing problems with that issue since then....

My code in SP seems to be working and where clause is working..

What i wanted to do is that i need to update other column of that table with...

I was just playing with that and i noticed that if i give space then am getting error like i mentioned.

As this site is live and users have started regisering...

name xtype length domain text

EducationCodeIdNo5640NULL

EducationCodeDomainIdNo5640NULL

EducationCode239301313439753CREATE RULE rDenyEmptyString AS DATALENGTH(RTRIM(@field))...