Lynn Pettis (5/10/2012)

---

Jan Van der Eecken (5/10/2012)

---

Nah, he's not going to come back. I'm sure he'll start another thread very soon and get some other victims attracted.

Liked Eugene's dbo.p_ShowMeWhenICanGoHome though....

Don't say you start behaving like these hysterical women...

Nah, he's not going to come back. I'm sure he'll start another thread very soon and get some other victims attracted.

Liked Eugene's dbo.p_ShowMeWhenICanGoHome though. Yeah, it was a pile-on, but...

Darryl, did this help at all? If not, please come back and ask, we're all happy to assist.

Yet another reason never to do a SELECT *.

Great question, Wayne! And although I found the reference that Koen supplied, I still got the answer wrong. Anyhow, I learned something....

Here is an example:

DECLARE @ReturnValue int

DECLARE @SqlStmt nvarchar ( 1024 )

DECLARE @MyParams nvarchar ( 1024 )

SET @SqlStmt = N'SELECT @CountOfRows =...

Oops, Drew beat me by a few milliseconds 😛

Have a look at sp_executesql in BOL.

GilaMonster (5/9/2012)

---

Because they only show...

Why are you saying that, Gail?

Doens't have to be managed C++ BTW, C# or VB.NET that thunks "down" should do just fine 😀

Edit: Thought I'd better put quotes around "down". My fellow C programmers might...

Revenant (5/7/2012)

The only way around it -- don't quote me on that <g> --, would be to run a managed C++ assembly that would call an unmanaged assembly. It...

GilaMonster (5/7/2012)

---

Revenant (5/7/2012)

---

Jan Van der Eecken (5/7/2012)

---

Would certainly be great fun writing writing a CLR UDF in C. Maybe with a bit of embedded ASM inside? I'm sure it can...

Wow, Rich, your two threads are certainly not of the kind one would expect on a Newbies thread. Seems you have all the right questions and the accompanying answers already...

CELKO (5/6/2012)

---

What you did post was not normalized. Jobgs are entities, personnel are entities and they have a relationship. Here is a skeleton that you can use to do...