I find it mildly ironic that you posted no new ideas or code

Hello Paul,

When there is no idea about the solution to the given problem i consider it right...

Hi Grant..

Thanks a lot buddy and thanx to those who got involved in this discussion...

Thanks,

Amit

Hi Gail

It was nice of you to correct me with the proper explaination...

Appreciated.

Thanks,

Amit

Hi Pat,

may this can be useful....

Create proc GetResult(

@p1 int = null,

@p2 int = null)

As

Begin

if @p1 is null and @p2 is null

begin

select * from temp

end

else if @p1 is...

The only conclusion to all this discussion is that Strored Procedures should be used to call functions...

And in no way your desired result is far.....

Thanks,

Amit

Allen really gave a very precise and to the point solution.

But Newbie as u seem to be new this can be helpful to you to certain extent.....

Delete from dbo.tblAlarmMaster

where intFactoryID...

Your suggestions are always welcomed

Hi Grant,

As admitted by you its the hard way, so this is not preferrable and also it can result in loss of data....

Thanks,

Amit

Hi Gail,

I do agree with you that it completly depends on the scenerio of what are u standing in. With my comment to "Both work equally fast" i meant with...

Thanx for your instant reply buddy,

I dont have any problem with sp_rename syntax,

bt i would like to know for the sake of my knowledge, if there is any other...

Thnx for that, even i had the same question....

Thanks,

Amit

Hi Coby,

I agree with what chirag says, may be u need to check whether the case sensitivity is the reason for ur misinterpretation (if any).

If its not so and condition...

Hi gyessql,

Basically two or more tables should be joined only if the collective information from both the tables or on the basis of the criteria that involves fields from the...

Hi KB,

Performance of Count(*) and Count(ID) completly depends on the records table has.

Both work equally fast, just that Count(ID) will evaluate the result considering the IDs whether or not...

I think this hard code insertion wont do if something like dynamic columns are to be retrieved... There must be some other effecient way to acheive the same...

Can you suggest...