Sean Lange (4/6/2012)

---

So given the error message what do YOU think the problem is? This is not some voodoo uber awesome sql thing hidden away. It should take anybody with...

You do realize that it may be better to look at the queries and the tables to determine if the queries and/or indexes can be improved before you look at...

OP wants to track by user, by ip address the search word(s) a visitor to his website uses.

Obviously, the search page will need to write this information to a search...

You can use Database Mail to send the emails.

njdevils39 (4/6/2012)

---

LutzM (4/6/2012)

---

I have no idea.

It would make sense to place it...

jitendra.padhiyar (4/6/2012)

---

Thanks a lot Pettis and Paul !

Now i m cleared about primary key concept. I also tried to insert a column using Alter command with not null, but it...

jewel.sacred (4/6/2012)

---

---

so its legacy that you are stuck doing it this way. its this way now so it has to be this way when we move to the new system?

in...

jewel.sacred (4/6/2012)

---

capn.hector (4/6/2012)

---

jewel.sacred (4/6/2012)

---

capn.hector (4/6/2012)

---

to lynn's point. if 6 months after you start using this you have to change the pieces per pack you have to make sure to...

What does this mean:

I am slightly confused.

den_sidr (4/6/2012)

---

Lynn Pettis (4/6/2012)

---

GilaMonster (4/6/2012)

---

Yes, absolutely sure.

All nonclustered indexes contain the clustered index key as...

jewel.sacred (4/6/2012)

---

capn.hector (4/6/2012)

---

ok first thing is i would move your conversion factor to your unit table, makes for easier changes with out haveing to make sure you update every conversion...

sivag (4/6/2012)

---

here i joined seven table for this i used your split function only there i nothing wrong in that execpt one thing if i exec the store proc means...

GilaMonster (4/6/2012)

---

Yes, absolutely sure.

All nonclustered indexes contain the clustered index key as a row locator....

Revenant (4/5/2012)

---

Lynn Pettis (4/5/2012)

---

No idea, wasn't close enough to see the package. But whoever left it...

No idea, wasn't close enough to see the package. But whoever left it in the lobby...