cast your column as unicode

Agreed about the lack of ORDER BY.

However, luck would have it that it returns data for me, as long as I run it in a database that returns data for...

jamey8420 (4/5/2013)

---

That link works; thanks.

One related question. My SSRS report is in a window that doesn't have the URL displayed. So when I click on my link, nothing...

Something like this will produce Unicode output.

bcp "select N'test' as test" queryout test.txt -w -T

You can check the format of...

Oh yeah, sorry - that's the problem with typing code into this forum ! :w00t:

Try this (replace the á with a regular a):

=iif(Fields!budgetid.Value>1,"jávascript:void(window.open('http://system/forms/Summary.aspx?BudgetId=" & Fields!budgetid.Value & "','_blank'))","")

jamey8420 (4/5/2013)

---

I have a conditional hyperlink set up in my SSRS 2008 report.

=iif(Fields!budgetid.Value>1,"http://system/forms/Summary.aspx?BudgetId="&Fields!budgetid.Value,"")

This works fine. However, it is opening over my report and I don't want that....

Have you tried the "-w" switch?

Try using a dummy select, something like this inside your SP to allow the application to grok the table definition it is expecting

CREATE PROCEDURE [dbo].[Get_Ques_id_for_can]

(@candidate_id varchar(max),@Exam_id varchar(max),@sec_id bigint,@Q_id varchar(max) OUTPUT)

AS

--...

Based on the little information you have provided, no.

How do you produce the ANSI file? SSIS? BCP? Copy and paste?

I wonder how much data we are talking about and whether a message queue is worth investigating?

opc.three (4/1/2013)

---

Lynn's numbers seem off to me. I got ~10s for your method and ~50ms for Lynns. But Lynn's numbers make it...

Lynn, Nope that pretty much sucks too! :hehe:

Lynn Pettis (4/1/2013)

---

Yea, but I think I'll stick with the FOR XML Version, the following was done against a database with 5147 tables in sys.tables:

---------- opc.three verison ----------

Beginning execution loop

CPU(ms):...

I will lay my cards on the table: I am in agreement with Jeff Moden.

On a properly secured server, disabling xp_cmdshell provides so little security gain (as it can be...

I quite like the idea of having a permanent tables (not in tempdb) with a process to remove them, but not automatically...

I would have a system whereby you write an...