Thanks Micheal and Gsquared for the replies. i really appreciate it.

GSquared,

You are right. But the maintenance will be really difficult right. Any change in the table, everybody forgets...

Thanks Raleigh. I dont want to assign the result of the select to a variable but i want to use the variable(which has the field name) in the select list...

I know it can be done by dynamic sql but is there any way to do it without dynamic sql?

Thanks,

kayal

Thanks Tomm and Grant :). That makes sense. I appreciate your replies.

Hi Mahesh,

I am using, If update(column name) as it is one of the best way to find out whther the column is being updated. But...

Hi Grant,

Can a foreign key be a composite key even if the primary key of the table it references is not a composite key. For eg. If Part#...

Thanks Peso for the info.

I always use this to get the date part

@Today = dateadd(dd,0, datediff(dd,0,getdate()))

Thanks,

Kayal

Thanks BarryYoung and Lynn. It makes sense why people prefer joins as its simpler, preferred and has more features. But when it comes to performance, I guess not much of...

RBarryYoung,

I have a Question,

Is 1 better or 2 better(Join).

1.

FROM Product, ProductType

WHERE ProductType.ProductTypeID = @ProductTypeID AND

...

RBarryYoung,

Wow..This is really simple.. Thanks a lot... I really appreciate your help.

Thanks for your time,

Kayal

Thanks Gsquared and steve for the replies... That answers all my questions 🙂 . I appreciate your help.

Sorry guys, I guess this editor doesnot display xml tags .. So I have attached the code above.

Thanks for your time,

Kayal

Grant,

Yep, i I appreciate your view on this. Thanks 🙂

Kayal

Thanks Jack :). This really helps.. I appreciate it.

-kayal

GSquared,

This seems to be good solution. Is it possible to have a check constraint like that for 3 columns? .. Let me research more on that

I appreciate your...