Additional info from a duplicate post:

knakka 14475 (3/29/2013)

---

This current table has to be converted to the @temp_out

Order would be like this Proc --> Type --> Individual task for that type

the...

Duplicate post, please post responses here.

There are a few people here with Oracle experience that may be able to help but you might get better (or faster) answers on a dedicated Oracle forum rather than...

The query associated...

Nope. Not much here to work with, anything you get will be simple shots in the dark.

Can you post the code you are working with along with the any...

Lowell (3/29/2013)

---

Joe you'll most likely use a procedure like this, this is just a model, but you can see how the proc might use CROSS APPLY (or a left join?...

Try this:

SELECT

VW_ChildrenCurrentStatus.FosterChildID,

FosterChild.LegacyChildID,

Person.FirstName,

Person.LastName,

Person.MiddleInitial,

...

Sounds like a poison pill. After so many tries of processing the message, SB disables the queue. Are you able to manually send messages to the queues that...

jbalbo (3/29/2013)

---

Hi

First time doing this and not sure how(Even if its the proper way)

I created the function Getforperiod

ALTER FUNCTION [dbo].[GetForPeriod]

( @StartDate datetime, @EndDate datetime)

RETURNS TABLE...

Once again, please show us how you are using this. I use this method to build executable dynamic sql so I know it works.

Harry Drenth (3/28/2013)

---

Unfortunately it doesn't

It looks like this:

(6 row(s) affected)

-------------------------------------------------------------------

ONE&#x0D ;

TWO&#x0D ;

THREE&#x0D ;

FOUR&#x0D ;

FIVE&#x0D ;

SIX&#x0D ;

(1 row(s) affected)

The output is delivered to a VB.Net app which is saving the output...

Post the code you are running. When I use what I posted...

Or, replace SELECT @OUTPUT with PRINT @OUTPUT

Once again, do not display to a GRID, display to TEXT. It works.

Does anybody know who has the silver spoon, I can't seem to find it.