He's trying to build a select statement, Lynn. Just not communicating it as clearly as we'd like, but that happens.

Bru Medishetty (10/29/2009)

---

Thanks SSCertifiable for you suggestion. Full points to you. It worked. Also I hope for those who don't understand what I'm doing they need to work on their...

Take a look in the trace for what commands were being run by the same SPID (if that's in the trace). That should tell you what proc or script...

If I understand correctly that you are trying to test the inputs, then you'd do it this way:

SET @P_RISKID = 'CAD+CSW'

Then do the same with each individually.

Not sure what you mean by "clearance level", but glad I could help out.

It's pretty standard, when working with dynamic SQL, to have a print command so you can review...

Where are you seeing the exec command on it? In a trace?

There is a solution to go beyond 65k rows, which is use Excel 2007, which can go MUCH larger than that.

Looks like you have a temporary proc there. Kind of like a temp table, but it's a proc instead.

Change your exec command to a print command. You're telling it to execute something that isn't an SQL command.

I'd talk to the police and/or a lawyer, and go from there if they advise you to.

There's no reason to not ask the police about it. Just don't call...

jcrawf02 (10/29/2009)

---

GSquared (10/29/2009)

---

jcrawf02 (10/29/2009)

---

GSquared (10/29/2009)

---

I've seen one good implementation of Sharepoint, which ignored the workflow aspects entirely but made it very easy to keep project data in one place and...

You can define columns as fixed width for OpenRowset. If you use that, it's pretty easy to bulk import fixed-width text.

jcrawf02 (10/29/2009)

---

GSquared (10/29/2009)

---

I've seen one good implementation of Sharepoint, which ignored the workflow aspects entirely but made it very easy to keep project data in one place and share it...

jcrawf02 (10/29/2009)

---

Roy Ernest (10/29/2009)

---

Maybe...

What you're running into there is exactly precision exceeding accuracy.

The first number, 5244.11, has 5 "significant digits". The final 1 could be rounded or could be exact, there's no...