Here is your query rewritten using ANSI-92 JOINS:

SELECT t1.id,

t1.col1,

t1.col2,

...

I strongly second that forsqlserver!

Cool, happy you got it sorted 🙂

Nice, 530,000 files. Robocopy could handle the volume but it most likely does a simple stat on the source and destination files to decide if it needs to replace the...

Rounding is an intrinsic property of the DATETIME data type and FLOAT is an approximate data type so no guarantees. See "Accuracy" in this article: http://technet.microsoft.com/en-us/library/ms187819.aspx

Which FILEGROUP is the PRIMARY?

Not a SQL Agent proxy, the xp_CmdShell proxy.

-- remove proxy

EXEC sys.sp_xp_cmdshell_proxy_account NULL

GO

-- create proxy (shows up...

rayh 98086 (6/29/2011)

---

Hi,

Thank you, the export is working.

Two more questions about the formatting.

1. Is there a way to have the column names appear as the first row?...

If sorting were a requirement then the dbo.GROUP_CONCAT_S UDA would be...

I love it when that happens 🙂

No need (or way) to mark anything resolved, it's really just banter anyway, right? Happy you got it sorted!

Gianluca Sartori (6/29/2011)

---

I don't expect it to...

Which data type are you using in Sybase? Which version of Sybase?

See if you're happier with one of the approximate data types in MS SQL Server:

select isnull(convert(float,(convert(float,333) / convert(float,nullif(11,0)))),1)

Peter1971 (6/29/2011)

---

This is the original code:

declare @tekst as nvarchar(1600)

set @tekst = 'test'

INSERT into

openquery(rl_smd01, 'select in_kr_nr, in_record_code, in_kr_key, in_tekst_tabel from info

...

I'll assume that means that's the actual query...what do we see from this?

INSERT INTO OPENQUERY(linkedserver, 'select a,b,c from remote_table')

VALUES ( 10, 20, '30')

No.

What...