Thank you Grant. I guess I'l need to figure out a way to get delta(changed) data rather than the entire set

Thanks Again !!

Hi Grant,

I agree with you. But as per the requirement I have I am supposed to take up all the active = 1 rows and migrate it to the other...

Hi Sergiy,

I did remove those computations. And added option(recomplie) in the end. This is because everytime I run the query the data and the indexes would have for sure gone...

Hi,

Thanks again for the great response.

I am using this query to build a small datawarehouse. And this query is supposed to run 3 times a day.

The active flag has...

Sorry about the same question being posted twice, the page did not refresh and I accidentally posted again.

I now get it.

Thanks a lot for the great help GilaMonster 🙂

Regards

Rathi

Okay

But some places on the internet suggest that only the required columns must be taken and then joined to other tables. Say I require 5 columns from a 50 column...

Okay.

But, many a places on the internet suggest that only the required columns from a table must be retrieved and not all of them. If the select requires only 5...

The OPTION RECOMPILE with CASE still generates a sub optimal plan. So I guess I need to consider writing into 2 separate queries

Also, under what conditions would I use ...

Ahhh.. apologies, posted in a hurry and didn't see the forum version. I am using sql server 2012

I have posted the query in previous reply.

The removal of case statement...

Hi,

The query is

select dp.FarmerCropId,

am.ActivityId,

am.ActivityName,

cfm.customformid,

getutcdate() talendate,

aadt.AttributeDataTypeId,

aadt.DataTypeId,

aadt.SequenaceNo,

aadt.groupid,

datatypename,

AttributeId,

AttributeName,

fcaa.reading

from dbo.ActivityMaster am

join (select activityid,

isactive,

AttributID,

AttributeDataTypeId,

DataTypeId,

SequenaceNo,

groupid from dbo.activityattributedatatype) aadt

on aadt.activityid = am.activityid

join dbo.CustomFormMapping cfm

on cfm.activityid=am.activityid

AND 1=(Case when @parm_Active = 0 then 1 When @parm_Active...

Hi,

I am using SQL Server 2012.

I have multiple inserts and updates in my procedure. I have 'set nocount ON' in the beginning of the procedure. But, everytime I execute...

Hi,

Apologies for not being clear.

I executed the query this way.

select * from [linkytomysql][talendshouse][mytable];

This does not work.

And with regard to the connection to mysql. The steps you mentioned for creating...

Hi,

Thanks again for the quick response.

I tried with 4 part query. And it keeps throwing an error.

It says 'Invalid use of schema or catalog for OLE DB provider "MSDASQL"...

Amazing !! Thank you , it worked.

Now, is it possible to query mysql without openquery?

The 4 part name convention did not work

Conceptually schema and database name in mysql is the...