Yes,

Exactly it does the same operation here you need to mention which column it should join(look) on

eg: you need to mention unique key in that table

select a from tablea a...

Hi,

You can try this

Select col1 from A

INTERSECT

select col1 from B

It will give you resultset of A where col1 which are present in B

Even if table exist now, I want to handle this situation in future any table is dropped and I dont want my SP to suffer. so any workaround on it?

Hi,

Even I have done some JAVA programming before so this suggesion might help. But if you know any links that provides good tutorials that will be great! Thanks for replying

sorry i think html tags are not diplayed here I am attaching these files now please refer

Got it! Thanks a lot

Now below given is SP1 code in last line its calling SP2

================================

CREATE PROCEDURE ODS_VLD_JCU07

AS

SET NOCOUNT ON

BEGIN TRANSACTION

DECLARE @JobID INT,@LoadInstanceID INT, @ODSTableID INT,@DataTypeID SMALLINT,

...

There is one part of code which is common to all procedures(SP's)

I want to saperate that code as new SP and call if from respective procedures. below given is...

Hi,

My senerio is...

CREATE PROC p1

AS

CREATE TABLE #foo ( a INT )

EXEC p2

go

CREATE PROC p2

AS

SELECT *

FROM #foo

go

When...

Thanks a lot will use TFS from now. 🙂

Hi,

Data is in TFS which is path based Source control from microsoft, As i am administrator for this scripts I can alter scripts.

But my requirement is that i want to...

Hi,

In the sample Code given above there is query which checks for some condition, if matches that condition it deletes old records and inserts new records else it will insert...

Thanks for replying,

Here is the sample code of it...Code is pretty big, i am sure you people can understand.

This function checks Customer Arabic address data quality, the function returns a...

Hi,

Yes data is stored in TFS, Thanks a lot for suggesion.

Will get back to you if i have any doubts in this... 🙂

Thanks a lot for the help it helped me lot