You could use the bcp utility through xp_cmdshell.

Check the links for information on those.

You might want to change your table definition to prevent truncation errors.

CREATE TABLE dbo.TraceResults(

TextData nvarchar(max) NULL,

ApplicationName nvarchar(256) NULL,

NTUserName nvarchar(256) NULL,

LoginName nvarchar(256) NULL,

CPU int NULL,

Reads bigint NULL,

Writes bigint NULL,

Duration bigint NULL,

ClientProcessID...

Please tell me that you're not creating a scalar function for this. That'll cause performance problems.

Are you using a format file? How would you handle invalid dates?

A staging table is a good idea for any data load process. That way you don't mess with already...

Quick thought, but I'm not an SSIS expert.

You could assign the value to your variable through a Script task instead of an expression. That way, you'll keep the same value...

batgirl (9/4/2014)

---

Lynn Pettis (9/4/2014)

---

Yes, I actually threw one of Mr. Celko's own arguments back at him in a post talking about dates.

I liked the COBOL reference since he likes to...

Why? You don't need to format a datetime, it's not a string. You can...

Why are you converting a datetime (GETDATE()) into a string that will need to be converted again into a datetime data type?

Could you post your table definition with sample data?

I wonder if people would be surprised by the error in the following query.

SELECT 1/0 as Result

WITH cte

AS

(

SELECT 'Result' AS Result

)

SELECT *

FROM cte

The reason is...

Sowbhari (9/4/2014)

---

Hi Luis C., could you please explain a...

jcrawf02 (9/4/2014)

---

Koen Verbeeck (9/4/2014)

---

jcrawf02 (9/4/2014)

---

You mean the show about the conceited narcissistic prick who is unable to properly interact with other humans because he's convinced of his superiority, and constantly...

Can you support this statement with something that is not in your books?

3. Some operations apply to the...

I'm not sure if YYYY-MM-DD is the only display format, but I wouldn't care less about display formats, that's what the front-end is for. We must care to store values...

Someone call the Relational Protection Agency, we have an offender...oh, wait. 😀

Someone call the normalization police, we have an offender in here.

That Rents table is not normalized. What will happen when there's more concepts needed? Will you just add columns? What...