I think the answer is, wait for it....

It depends. What are you doing in the report? Is it concatenating First Name + Last Name in to Full Name...

No, he's saying you have to figure out what the user searched using, the english or the french letter and then make your sort ASC or DESC as appropriate. ...

Don't think you can do it without dropping all the FK's and then dropping and recreating the PK and then re-adding the FK's

You can't. You need to keep a copy of the code unencrypted somewhere.

There are tools that you can get that will decrypt encrypted procedures, but I'm not gonna be...

Ouch. Here are my questions:

1. Have you checked the windows logs for the specific failure mentioned? If so, can you post it?

2. Can you connect to...

Just made my first "real" forum post in awhile. Had to pick a thread where Mr. Celko has already weighed in. http://www.sqlservercentral.com/Forums/Topic963903-391-1.aspx

While I'm not going to argue with Joe, I don't think that DRI can handle this particular situation.

I would agree that I don't really understand why you would...

GilaMonster (8/4/2010)

---

Jack Corbett (8/4/2010)

---

Probably the most complex SQL I've had to write. Too many OUTER JOINs (business requires this design), and then parameters that could turn the OUTER JOINs...

Lynn Pettis (8/4/2010)

---

Alvin Ramard (8/4/2010)

---

skcadavre (8/4/2010)

---

Jack Corbett (8/4/2010)

---

So you know the search procedure you are working on is complex when you can't write up a question about it for the...

Brandie Tarvin (8/4/2010)

---

Jack Corbett (8/4/2010)

---

Probably the most complex SQL I've had to write. Too many OUTER JOINs (business requires this design), and then parameters that could turn the...

Alvin Ramard (8/4/2010)

---

Jack Corbett (8/4/2010)

---

So you know the search procedure you are working on is complex when you can't write up a question about it for the forums because it...

So you know the search procedure you are working on is complex when you can't write up a question about it for the forums because it takes so long to...

Grant Fritchey (8/3/2010)

---

Steve Jones - Editor (8/3/2010)

---

Jack Corbett (8/3/2010)

---

WayneS (8/3/2010)

---

Well, since Steve asked for opinions on one topic, let me broach another topic.

What do you'll think about this[/url]? Is there...

WayneS (8/3/2010)

---

Well, since Steve asked for opinions on one topic, let me broach another topic.

What do you'll think about this[/url]? Is there a valid point? Are the people screaming about...

Brandie Tarvin (8/3/2010)

---

.

Jack, I don't recommend consulting right now. The job market's too wobbly. You could get burned and find yourself without options (and jobs) if a employer decides they...