Hi there,
I have a two tables table1 and table2 and both containing ID column. I want to find max(ID) of table1 and max(ID) of table2 and if both max IDs are same, I will call a C# program using .exe.
Is this possible in a single SQL statement in a batch file?
Create table table1(ID int not null,
CONSTRAINT [pkid1] PRIMARY KEY CLUSTERED
(
[Id] ASC
));
Create table table2(ID int not null,
CONSTRAINT [pkid2] PRIMARY KEY CLUSTERED
(
[Id] ASC
));
Thanks
rash