Search results for query: *

MLS_ID

Really what I need to do is check against the SQL table "property". That's where the error will occur. If I try to add the same data currently in the database from a textfile.

I get the following when I run that query: (0 row(s) affected) (21 row(s) affected) Msg 2627, Level 14, State 1, Line 10 Violation of PRIMARY KEY constraint 'PK_Property_1'. Cannot insert duplicate key in object 'dbo.Property'. The statement has been terminated.

I could use a temp table but don't know how. Could you give me some syntax? Also, what is this doing? SELECT * INTO #Test FROM Property WHERE 1 = 0

I have a table that has a unique primary key. When I do a BULK INSERT from a text file if an identical row/primary key is found the INSERT errors out and nothing gets added. I need to just skip that row from the text file and keep on trucking. Does anyone have an idea? BULK INSERT Property...

I was hoping that I could do an Excel Data Import utilizing vbscript. Does anyone know if this is possible? Anyone have a sample?

Horrible right now but this did it: Const ForReading = 1 Const ForWriting = 2 Dim info Dim MLS Dim editMLS Dim Remainder Dim final Dim writeit Dim strText Dim price Dim editPrice 'Create a File System Object Dim fso Set fso =...

I was actually able to do that part. I decided to go with pike characters so that I could differentiate the price comma from the others. I want to import this into excel. In VB.Net I can do things like substrings. Is there anyway to pinpoint a specific character? I was thinking RIGHT() but...

But wouldn't I need to iterate through each line of the text file?

I am having difficulties in trying to add a comma behind a 6 digit number at the front of every line in a text file. Does anyone know of a good way to do it? 394923 3517 Redman Hall Rd, Pinson, AL Photo Added $28,900 394212 828 49th St, Birmingham, AL Price Changed $17,610 395814 818 85th...