jcbally (9/12/2010)

---

All the date formats in the varchar column are the same

Format '04/05/2010' mm/dd/yyyy

I need to compare of greater then the other colum of those dates against another column that...

Paul White NZ (9/12/2010)

---

3. You can assign the string values 'true' and 'false' to a bit data type. 'True' will be stored as 1, and 'False' will be...

emdadgar2 (9/8/2010)

---

Dear all

I created a table with this fields:

ID bigint not null

fname varchar(50) not null

lname varchar(50) not null

and with this indexes:

clustered index on ID with fill factor...

jcbally (9/10/2010)

---

I Need to compare two columns [PROP_FL_DT] < [PROP_MT_DT]

One Column is Varchar Data Type, the other is Date

the varchar data Type is mixed with Null, Date structure like '04/05/2010'...

vani_r14 (9/9/2010)

---

Hi all

Thanks for all your help in the Forum 🙂

I got it figured out and its working now... If any one needs it in case here is what...

bhoverman (9/10/2010)

---

I'm working with the example , no success yet.

This is what I need to do.

There is a column that is 60 characters long. I need to create two 30...

A variation using CROSS APPLY

;WITH cteTally (N) AS

(

SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0))

FROM master..syscolumns

)

SELECT P.ID,...

The issue you have here is that you are trying to carry out a 4 column PIVOT with the conventional single PIVOT statement. One way to overcome this...

springrider (9/9/2010)

---

Thanks Steve,

Just tried your code in my VB.Net application:

cnSQL.ConnectionString = "Data Source=TETAUTAI;Initial Catalog=TUNA_DBS;UID=user;PWD=pwd;"

...

A variation using CROSS APPLY

SELECT #table1.ID, #table1.Description, Z.Services

FROM #table1

CROSS APPLY

(

SELECT

STUFF((SELECT ',' + Service

...

It depends how you're using it. For instance in the format file it manifests itself as "\7"

SELECT * FROM OPENROWSET (BULK 'C:\BellDelimitedFile.txt', FORMATFILE = 'C:\Bell.fmt', FIRSTROW = 2) AS Z

Bell.fmt

7.0

3

1...

The idea of using the BELL character as a separator is to minimise the risk of a clash with any real characters in the file. The BELL character won't appear...

I have modified your file to use CHAR(7) delimiters which seems to solve the problem. You can then BULK INSERT this file into a table as illustrated in...

e1785 (9/9/2010)

---

Hey, I have run into one more issue, which is the question of escaping. Since the pipe is the only character that is guaranteed to be a field separator...

I have come up with a SQL version using OPENROWSET BULK which seems to work OK. You could also use BULK INSERT via a staging table if you don't want...