Without more information, I can't tell you why it would work in one environment and not the other... But what I can tell you is that apparently you can't specify...

I was trying to come up with something exactly like this before, but couldn't ever quite get it, so thanks!

What I had been doing (translated to this example) was essentially...

Agreed on both parts that it'd probably be better in the long run to store files outside of the DB, and that if you HAVE to store in the DB...

I think it kind of depends on how the data is used.

I would think that if you were entering individual events and each even had its own location, then you...

The reason I had wanted to keep the values in sync was so I could get a list of values for a dropdown or other list by referencing the parent_id...

Thanks for your help guys! Using the COUNT(*) seems to work. I went with getting the count from the joining of the model/series list and the skill list. That seemed...

That seems to work. I'll have to wait till tomorrow to be able to fully test it.

A couple things to add into the twist, I only listed model_id to make...

Ok... This is my first attempt to provide a working example of something on a forum, so I apologize in advance if I make this more confusing that what it...

Sadly, the first code block I posted was my vast improvement over the code that was there. Like I said, the original code created strings put together to make a...

The reason there are 2 seperate tables is because initially, someone else set up the IPR_equipment table as (equipment_id INT, user_id INT, model_id INT, ratingsmap NVARCHAR(MAX)) where "ratingsmap" would contain...