Hi,

I saw you have got only 2 parameter in the query. Here are the steps I would follow to avoid confusion.

Remove the "Parameter field" from the query so that the...

OMG !! .. Are you running it on a super computer !! .. just kiddin...

Hi,

You can use the Alias "l" in the main query. not in the the subquery. just replace the "l." from the inner query. It will be okay.

Hope this helps.

-Swaroop

Yes,I can create a non clustered index. But this is the surrogate key in my Fact table. So I needed a clustered index. I think I dont have any options...

Thanks Gail. I think I need to add some space.

I think you are right.. I never realized this because this is the first time I am facing the issue. So is there any workaround.

Hi,

From SQL Server:

You can do xp_cmdshell 'telnet 10.xxx.xxx.xxx 1433'. SQL server uses 1433 port in general.

From SSIS:

You can use WMI Data Reader Task.

Hope this helps.

Thanks,

Swaroop