Hi Buz

Correct, OUTPUT parameters work also. As I wrote before, if you want to use it directly in your IF-clause consider to use a user defined function.

Greets

Flo

Hi

As you implemented you have to use a temporary table to get the result into:

DECLARE @Ret TABLE (Value INT)

INSERT INTO @Ret

EXECUTE IsActiveUser

IF (1 = (SELECT TOP(1) Value...

Hi

It seems to be a authentication problem. I'm not sure if PHP supports impersonation. I think your appache service account needs rights on your SQL Server or use SQL Server...

Hi Chris

Sounds like a classic data-warehouse scenario. You should consider to simplify the data structure on your read-only database for better reporting performance. Most times there are many information in...

Hi

I have no experiences with this but maybe it is possible with your IP or dyndns.com account. Only ideas...

Good luck!

Flo

@bob-2

Did you receive my message?

Greets

Flo

Hi mister.magoo

mister.magoo (4/24/2009)

---

In these cases, you can normally increase the speed of the query by adding a TOP clause, however you will not see the speed increase for just any...

Hi

New information from splitter front... 🙂

As first I have to apologize for all those "great" CLR test results... Since I tried to reduce the test results to the real split...

Jay Green (4/24/2009)

---

so the first X number of rows in my results set would be records belonging to typeC and then when all the typeC are listed the result set...

Hi

And another solution:

DECLARE @sql NVARCHAR(MAX)

SELECT @sql = (SELECT 'SELECT ' + QUOTENAME(Name, '''') + ' AS DbName, * ' +

...

Hi

You have to specify the required @url in your path expression:

co1.value('role[@url][1]/@url','varchar(100)') AS URL,

Greets

Flo

No thanks, no "can you please...". I thought it might be a problem with English but this kind of answers is unacceptable!

I'm still not sure if your BCP call is correct.

If you want to connect to your server with windows authentication use "-T" (no user name and password):

bcp "SELECT your query"...

declare @appro_xml xml ;

set @appro_xml='

1020

210

11

12

14

15

'

select

x.col.value('../../SolicitationID[1]','INT')AS request_id ,

x.col.value('../../DeclineReasonCode[1]','varchar(500)')AS DeclineReasonCode,

x.col.value('(./text())[1]', 'varchar(100)') AS DeclineReasonCode

FROM @appro_xml.nodes('//ScoreAndDataRetrievalRequest/DeclineReasonCode/DeclineReasonCode') x(col)

--CROSS APPLY col.nodes('DeclineReasonCode') d(dec)

By the way: What's the question?