Well I have given my suggestions about the approach you are taking. I still think your approach is not the best but I guess we will have to agree to...

Another to consider with the multiple table approach, how will you find out where a stock item is at? The stock record will have a locationtypeid? This means then you...

river1 (2/10/2012)

---

Hi,

I was thinking... in a situation where I want that a database column can only have data that is already on one of other three tables (like a FK),...

You are going to have to provide some level of detail in order for anybody to have a chance here. There just simply isn't enough information in your post. Take...

You might look into replication. It is designed to keep databases in sync (and they don't all have to be sql server). Otherwise I think you may be stuck with...

Don't group by date.

group by a.Itemkey, a.trandate, b.shortdesc, c.ItemId

djustice 20821 (2/9/2012)

---

Hello everyone. With the code below I am trying to return ItemKey, shortdesc, ItemID and the last date (trandate) that there is an entry for.

Example: there could...

My guess is you have something else in your code that is running slow. I have used his parsing function in all sorts of ways and places and have never...

Looks like the syntax is correct. Are you getting any error messages?

Also, an inline UDF like is prone to horrible performance if your resultset is anything more than a few...

peter 82125 (2/9/2012)

---

Without the use of triggers, is there a way to execute a stored procedure any time data change in user tables? The stored procedure is always the same...

Anything in your trigger is also part of the transaction so it will be commited/rollback as well.

The best thing for you on questions like these is to throw some...

I can also suggest which hints you want to...

SQLback (2/8/2012)

---

Yes. You can do that and if Product_Number column is int/bigint you dont need to put it in quotes

SELECT Customer_Number FROM Table

WHERE Product_Number = 1

AND ...

Well you changed your parameter to be optional.

@Address Varchar(163) =...

If you don't provide the parameter and you have the default of null your query will only return those where FullAddress is null.