Back to the original topic of this thread... And well, maybe it is this time: Do posters think we're answering bots instead of real people? http://www.sqlservercentral.com/Forums/Topic619172-1291-1.aspx. It seems he's going...

david.c.holley (12/16/2008)

---

Been busy...

For the record, the discussion groups that I have been apart of do not have stringent rules as to what needs to be included and what does not....

larsosman56 (12/16/2008)

---

Hi there.

Curious why the design may be bad. I have the items in one table along with their attributes, and the way they interact with one another (hierarchies) in...

I never used TRY/CATCH in SQL, but your suggestion solution makes the TRY/CATCH kinda useless to me. So yes, I think you're hacking your code there. But where did the...

larsosman56 (12/16/2008)

---

Hi there,

I can use some SQL advice with what I suspect is easy problem.

I need to insert rows of two items as a pair into a table (e.g. parent,...

From my point of view, this might mean that your function always presented wrong data: the day and month are switched. Perhaps you should inform your team about this... If...

That table is still relatively small, but showing 200000 records on a screen is of course useless. Is there a better way of decreasing the number of rows presented? Do...

Lynn Pettis (12/15/2008)

---

Although I thought I'd not bother with this either, I decided to at least provide you with one solution.

I have also taken the time to create the scripts...

I like your solution, Sunfei... I wish I could read it 🙂

david.c.holley (12/14/2008)

---

If I could write the T-SQL then I'd post it. I am presented the data as it exists in the tables and as I need it displayed. Either help...

Philip Horan (12/11/2008)

---

We have an ERP system. I have been asked to extract (for migration purposes) Products & Structures where the Parent ProductId begins with 'DME_'

So........

1) I have been...

Tip: add next time...

After you opened the database, you do see the .ldb file in that folder though? If you open the ldb in Word (Notepad doesn't show readable text), you should see...

Thanks for the table desc, but I didn't quite understand what you meant with your question. I guess Pr_RealEstateAgent_Id is the agent, and Pr_Id is the property? How is the...

I took from what you wrote that if the user either have the input with or without the dash, it should give the desired result. If you want something else,...