paul 17028 (5/6/2015)

---

Thanks for your help.

So to normalise the table do I need to remove the commas? What about spaces? and is it possible for instance to have ...

GG_BI_GG (5/6/2015)

---

Im trying to select leveling;

I have table like this;

FACC_WID FACC_BKEY ...

john.yori 32529 (5/6/2015)

---

Hi we have a legacy application running on sql2005. We suspect part of our performance issues is from the table triggers being fired so Development wants me...

paul 17028 (5/6/2015)

---

Hi

Thanks for replies. removing the wildcards was the first thing I tried but this resulted in "no records found" which is strange because i have other statements without...

minimay (5/5/2015)

---

nevermind i figured it out

Declare @Julycount int

Set @Julycount= (Select Count(*) From orders Where MONTH(OrderDate) = 7)

print 'The total orders for july is ' +...

minimay (5/5/2015)

---

nevermind i figured it out

Declare @Julycount int

Set @Julycount= (Select Count(*) From orders Where MONTH(OrderDate) = 7)

print 'The total orders for july is ' +...

minimay (5/5/2015)

---

I am trying to create a script file that will get me the total number of orders in july. How exactly would i say july because i know my...

faberDB (5/5/2015)

---

I try to explain better.

When I have to make the product I have to have all the needed quantity in my warehouse, ok?

So, in the sample data I can't...

paul 17028 (5/3/2015)

---

Thank you Eirikur for your reply, but your request for more information is way over my head. I am using an access database as a gallery...

I don't fully understand your question. There is something missing in the details that I can't wrap my head around. That being said it seems that you need a running...

To add to what pietlinden stated and perhaps explain the concern is that looping in t-sql is horrible from a performance perspective. When you have nested cursors you also have...

Grant Fritchey (5/4/2015)

---

Sean Lange (5/4/2015)

---

Lynn Pettis (5/4/2015)

---

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something...

Lynn Pettis (5/4/2015)

---

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix...

Grant Fritchey (5/4/2015)

---

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix...

All triggers are...