No. We're hitting issues with the tool that generates our geographic shapes not properly closing all the polygons it generates (and occasionally generating polygons with lines that cross...). We can't...

I'm sorry, I'm still stuck on what it is that you're trying to do.

Also, because I'm just not going to try to type your code into my system, if...

P Jones (10/15/2009)

---

It isn't the badly phrased, minimal information questions which make me see red but the posters who, given a line of research or something to try, just say...

More excellent answers.

And yes, Darwin had a heck of a beard. Maybe it's time to grow mine again.

Bob Hovious 24601 (10/14/2009)

---

What next?

"You'll have to get the rest of your question answered by someone else... they're about to close the casket, and nobody bothered to put extra batteries...

jcrawf02 (10/14/2009)

---

Grant Fritchey (10/14/2009)

---

GilaMonster (10/14/2009)

---

I haz two tables and no question

http://www.sqlservercentral.com/Forums/Topic803081-338-1.aspx

Some else can have the pleasure of this one. I'm going to spend an hour trying to conquer the galaxy,...

forum member (10/14/2009)

---

If i understood correctly, i need to specify 5 state variables and carry insert on them,please calrify and please suggest on how to carry update on this,some...

This PDF has an article called The Questions. If I understand what you're trying to do, I show three different ways to solve that problem.

GilaMonster (10/14/2009)

---

I haz two tables and no question

http://www.sqlservercentral.com/Forums/Topic803081-338-1.aspx

Some else can have the pleasure of this one. I'm going to spend an hour trying to conquer the galaxy, then going to...

forum member (10/14/2009)

---

Hi,

I need help with sql query

I have bookings in one table and bookingstates in another table which contains states related to booking

Booking Table Schema ...

Yeah, what Gail said.

Seriously though, she's right. There was missing index information in the execution plan, it was moving scads of data around to retrieve 600 rows, you're getting a...

Slick84 (10/14/2009)

---

Grant,

Thank you for the information. Can you possibly point me to the right direction for updating stats on the tables as well as more information for "Full Scans". I...

You're getting a scan on the tblProductSizeWidthColor table, from the name alone, I think you've violated some design principals, which is reading, if I counted the digits correctly 332 million...

Sorry. It sounds like to do what you want, you need to make a change to the code.

Yeah. This is untested psuedo-code, but it illustrates what you do:

CREATE PROCEDURE A

(@p1 int)

AS

EXEC B @p2 = @p1 OUTPUT;

SELECT @p1;

GO

CREATE PROCEDURE B

(@p2 int OUTPUT)

SET @p2 = 42;

GO

You can look up...