Citiinvestor (6/29/2011)

---

Hi Phil Parkin Thanks for Ur response , I was also thinking something like this , but how will naming convention help me ?

lets suppose if...

glen.wass (6/29/2011)

---

That error sounds like somting your calculating has a null value so you need to find out what and eliminate the null.

Do you have any representative data we can...

If the source data is in SQL, a simple query will do this.

I don't think you'll get any better, in terms of the number of digits returned to the right of the decimal point, than FLOAT. I am interested to know why...

How do you know that Excel file 1 and FTP file 1 belong together? Is there some sort of file-naming convention?

You could try returning the columns from a stored proc and using that as the source for your data.

You'll need to include a dummy select as the first line of...

Would be useful. But a quick look at your query suggests that this

Select RandomCol from TableA where UserID = @user-id...

Then the CAST solution is probably the best for you, eg:

DECLARE @Int1 INT

SET @int1 = 454638

SELECT @Int1, LEFT(CAST(@int1 AS VARCHAR(20)),3)

You have stated your problem and received a solution - if the solution is not what you require, please describe why, so that the next solution can give you what...

Although you may have solved this problem in the short term, you may be storing up problems for yourself in the medium term. If two or three more code/description pairs...

Do you have a question?

Haha, no problem. SSCrazy would frequently be a better name for me than Phil...

It is not. Your method would allow invalid ranges to be inserted, mine would not.

But...

Jayanth_Kurup (6/27/2011)

---

Hi

This would remove scope for inserting a range between 1 and...

Something like this:

declare @MaxToPoint Int

select @MaxToPoint = max(ToPoint) from PLevel

If @frmPoint <= @MaxToPoint then --> error