You can , but only when u have a JOIN clause on the JobTitle table..

Look up on Books Online (free 'Help' that comes with the SQL Server) for OPENROWSET.. that will help you resolve this issue..

Look, your City.txt file is a comma-separated file. Thus a delimiter of "\t" ( = Tab) will not do any good for you.. so i edited the format file to...

try this:

; with numbered_dupes_cte as

(

select rn = row_Number() over (partition by c1, c2),

c1, c2

from table

)

select...

Are u using the correct path of the txt file? is your txt file well-formed? can u attach your input file?

Harag, you seem to be very new to the forum, so i recommend you going through this following Jeff Moden's article first ; this article will help you present your...

I definitely agree with Ron here ; you have not tried anything, then why would people consider working for you when u haven't even tried, or atleast that's what u...

1. Create a format file using the command mentioned in the following step:

bcp Scratch.dbo.Names format nul -T -c -f Client.Fmt

Things to note here is, i have used -c switch, which...

Thanks for understanding,...

The only values for User are Bob Jones , Tim Ralph , Rob Tims ?

rothj (9/24/2010)

---

Yeah, I realized it looked like crap and I was just reviewing the Forum Ettiquettes to correct it. Sorry

I thought it would be a quick an easy select for...

Ok, with my frustration apart, here is one of the solution for this:

First lest prepare a temp table and sample data:

DECLARE @Tab TABLE

(

INAME VARCHAR(20),

[DATE]...

693 visits, 246 points and still you are not clear on how to ask a question.. Hmm.. without ready-to-use sample data, its hard to spend time on checking this.. lets...

DECLARE @XML XML;

SELECT @XML = '<r>'+REPLACE(@Code_String, ',', '</r><r>')+'</r>';

This

1. removes any comma ( , ) character in the input string

2. Replces </r><r> tags for the commas; the first </r>...

Use BCP/BULK INSET using "FORMAT FILE" or as u said, using OPENROWSET..