I tweaked your code a little bit more. I removed the in because it was checking for a single value and removed the statusid check at the end. I think...

Actually, when i was looking again at your code the case statement has only 1 valid path. You are filtering out every value for StatusID except what is in @status

Can you post the create scripts, some sample data and the desired output? That way we are on the same page. It sounds like the case is exactly what you...

Are you just trying to select this info? If so then just take the alias of the columns.

Try this.

CASE (a.statusdetail)

WHEN NULL THEN 9

ELSE 11

END as StatusID

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