if it is ALWAYS 2 decimals just multiply by 100

otherwise cast it to a varchar and then replace '.' with ''

😛

This is a 2 part question -

1st - the field b.DOCAMNT returns with decimals (164.23 example - and usually there are 50 - 100 results returned for different check...

Try this as a great starting point. It has all the code for you in vb.net. 😛

http://www.vbdotnetheaven.com/UploadFile/scottlysle/ImageToSqlServer11242006025136AM/ImageToSqlServer.aspx

I too am having some troubles getting this update to work. There are definitely issues with your cursor but when I reworked it I discovered that the image datatype is...

If you can post at least the create scripts for your tables i will play with it and see what I can come up with. 😛

I figured you could just the dreaded cursor for the one time import since you already have figured out the path to the current file.

If you want to do this...

something similair to this should let you insert them without much issue:

INSERT INTO myTable(Image)

SELECT * FROM

OPENROWSET(BULK N'FullPathHere', SINGLE_BLOB)

That would depend on what reporting system you are using and the rules about generating an image in their reports.

That leads to my other question. do you really need the intermediate table? One candidate can have multiple positions AND one position can have multiple candidates.

This would be many times...

If you use int (or bigint if you expect LOTS of rows) columns set as identity instead of GUIDs it would be a lot easier. The you can just use...

something like this do what you need?

SELECT top 1 *

FROM MyTable

WHERE MyDataType = 'A'

AND MyTimeStamp <= '1pm'

order by MyTimeStamp

There seems to be something missing in your description unless you just want to insert a new record to the Position table with no PositionName when you insert a candidate.

From the original post it looks as though he wants the values concatenated with a ',' instead of just a sum. Otherwise it would be too easy. 😉

You have 87 unique values, not 87...

I know nothing about iBase but this would be enough to tell me...