Sailor (11/29/2012)

---

Given example format file:

8.0

85

1 SQLCHAR 0 1 ...

That would work. Just a FYI, something like this would also work:

INSERT INTO dbo.PROVIDER_TO_TRUSTED_PROVIDER_COLLECTION (OID, OID_LINK)

VALUES

('002771F071C541F4B5478D246381E7E7','CB30DF919B0F468AB203FFD848D11463')

,('003A19E3D3B040958EFA16EB2585B0DC','CB30DF919B0F468AB203FFD848D11463')

,('00CD83EC6F9E4CCDAA22D8D7C6B8C59E','CB30DF919B0F468AB203FFD848D11463')

,('00DE552BB51A490B91E87E6E1236CBD8','CB30DF919B0F468AB203FFD848D11463')

It sounds like you're having a conversion issue. Can you paste more of the top of the procedure? (Like where the procedure and the variables are declared)

Depending on what exactly is happening, there are a couple of ways to do it. If @PolicyId is an int like you state, the following should work

--check if PolicyId...

How many characters do you need it to take? (or really, its a numeric length)

It's also possible that I don't understand exactly what you're looking for. Are you trying...

hoseam (11/21/2012)

---

Hi

I want to validate my input parameter, which is policy Id (int)

So I have:

declare @Valid_PolicyId int

select @Valid_PolicyId = count(*)

from Selestia_BI_Staging_Source.dbo.PR_REB_SNAPSHOT rs WITH (NOLOCK)

where rs.POLICY_ID = @PolicyId

--check if PolicyId...

Edited after re-reading..

I'm actually not sure what you're looking for either. You appear to be attempting to insert values from a table back into the same table. Some...

Oh, I neglected to mention that the data files I import don't have decimals (the decimal is implied based off of the field precision\scale) so.... it might not work if...

I have some code that will build an import script for a fixed width table based on the table description. I find that it generally works (and does Unix...

Our company creates data sets as a product. In QM we have a production database and part of the company production process is running all the data through a...