Skip to Content
author's profile photo Former Member
Former Member

UDF's in excel not showing - empty columns (SQL native client query)

Hi All,

I am doing excel queries but other than date and hours UDF are empty in SQL native client/excel.... and I need to work on all of them in excel and I can't.

Does anyone know if there is any solution to this SQL/excel problem ?

I already tried giving the UDF a name in query but it didn't help.

Please help, thank you in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2011 at 04:32 PM

    Hi,

    Could you post your query here and mention the type of the UDF?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2011 at 10:50 AM

    example:

    SELECT ORDR.DocNum AS 'dok.nr', RDR1.ItemCode AS 'indeks', RDR1.Dscription AS 'opis', 
    RDR1.SlpCode AS 'kod.sp', RDR1.Quantity AS 'il.', RDR1.VatPrcnt AS 'VAT', 
    RDR1.U_p15 AS 'c.z.n', RDR1.Price AS 'c.s.n', ORDR.U_z2 AS 'trans'
    
    FROM DB01.dbo.ORDR ORDR, DB01.dbo.RDR1 RDR1
    
    WHERE ORDR.DocEntry = RDR1.DocEntry AND ((ORDR.DocNum=?) 
    AND (RDR1.ItemCode Not Like '02.P%'))
    

    UDF's > Marketing Documents:

    Title: z2

    Alphanumeric (10)

    Structure: Regular

    Title: awizacja_data (this one is displayed properly in excel)

    Type: Date/Time

    Structure: Date

    Rows (this one is displayed properly in excel):

    Title: p15

    Type: Units and Totals

    Structure: Price

    Another example is Row UDF Alphanumeric (10) linked to a table that doesn't fetch (or display) anything also.

    So it might be that data from alphanumeric UDF's is not fetched (or displayed) to excel..

    Edited by: Tomasz Bolesta on Dec 23, 2011 11:51 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 14, 2012 at 02:12 PM

    Hi,

    try casting the UDF: CAST(T0.U_z2 As nvarchar(10)) AS 'trans'

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.