I would change your UNION to a UNION ALL. It is better for performance and in your case you probably want to get both result sets even if they are...

mamzy10 (6/27/2013)

---

Hi cadavre still having prolems its still spitting out ALL of the data and not just those ones with 21 and something else. im getting learners who dont even...

Depending on the requirements you might be able to use UNION ALL instead of UNION which is certainly a performance improvement.

Alan have you looked at islands and gaps. I am pretty sure this is exactly what you need here.

http://www.sqlservercentral.com/articles/T-SQL/71550/%5B/url%5D

RedBirdOBX (6/26/2013)

---

I'm starting to think the way I call my routines and functions could be refined. Maybe something like?....

Sub btnSubmit_OnClick()

Try

...

RedBirdOBX (6/26/2013)

---

.to add...I suppose I could query the Max value of the PK. Say record 101 was the last one to be inserted. Then after the Insert takes...

RedBirdOBX (6/26/2013)

---

Thanks Sean (and everyone else). I am catching on the .NET side by using Try / Catch. I've simply developed a habit to write the...

Hi and welcome to the forums. It looks like you have a pretty complicated requirement here. I will be happy to help if provide a few things:

1. Sample DDL in...

sdhamani1020 (6/26/2013)

---

Designing the ERD ..

I am trying to create a lookup entity for my Header(Entity) which has Producttype as one of the attributes.

Header_---- Tablename(Entity)

----

----

producttype ---- columnname(attribute)

----

-----

ProductLookup------Tablename(Entity)

Producttype PK (Varchar)columnname(attribute)

Is this...

brendan woulfe (6/26/2013)

---

I'm with you...the last sentence ("all you really need to do...") threw me off. I thought you were implying just add a try/catch in .Net and be...

Steven Willis (6/26/2013)

---

Here's the article that I saw lately. I've only skimmed through it but it looks to do the sort of ordering we've been talking about. Looks interesting.

SQL2012 Varchar...

Dunno for sure. That is exactly why I said...

I can't seem to find in this thread now but iirc you said that the returns was data from an outside source? How do you validate that the returns they...

I agree with Brendan to a point. If you want to catch something on the sql side you would use try-catch. Everything he said is accurate. The big difference here...

Glad you got it working. The important is, do you understand why changing the code will work?