This should work but you have a couple issues. You said you want to load in batches of 10. You select top 10 but limit it to 5 rows with...

Well it is very unclear what you are trying to do here. Do you have these tables designed already? Can you post the ddl, sample data and desired results? I...

Mohammed Yousuf (7/18/2012)

---

I want to apply a range ( @fromvalue to @tovalue) to a column of type varchar.

lets say the column is ItemNumber

The ItemNumber can have both numeric and...

tacy.highland (7/18/2012)

---

Ok. So that kind of works.

I'm trying to build it as a matrix, with the route number as a row, and each 15 min increment (for the whole day)...

I am not sure how substring would help in this case but...

dtopicdragovic (7/18/2012)

---

One thing I forgot to mention is that when user login to web site we select his data and we display it to the user. After he updates...

XMLSQLNinja (7/18/2012)

---

Good Grief! First and foremost - NEVER do that. As a...

tacy.highland (7/18/2012)

---

Thanks so much.

However, I ran into issues recreating your cteTally table. I took a look at the link you provided for creating the tally table but...

nvm misread the original question.

You're welcome. Not sure how I never found that one before....

Actually if you read the article it is really quite simple.

tacy.highland (7/18/2012)

---

The table this query would be pulling from is literally just 3 columns: Route INT, Starttime SMALLDATETIME, Endtime SMALLDATETIME. The start/end time could be in some other format...

You...

Without ddl, sample data and desired output nobody can do much to help. At best we can take a shot in the dark and see if it might work. If...

This request is WAY beyond the scope of an online forum. You are asking somebody to design your entire application and database. If you are truly stuck at the starting...