No it is clear...

Thanks for the clarification 🙂

I am not able to understand this one

I run this query

if 'BLONP' < Any (select customerid from customers)

select '1'

else

select '0'

But it returns 1 only ?

I am using SQL 2005 🙂

Thanks for the Quick Explanation Jhon.

Bear in mind that these queries aren't schema-sensitive(owner-sensitive in SQL 2000 and below). So if tables called MyTable exist in any schema other than...

Can you please explain the steps.

Thnks Oana 🙂

I faced the same file for problem.For that i wrote that format.If you try to insert using that format , that problem will be rectified. Try that.

You have to convert the Date_OF_Birth to ISO date.Because the date format inserted sql server 2005 changes according to Regional Setttins.Try converting your date format as given below

Private Function getISODate(ByVal...

Thanks Steve,

It worked well. But How can I set the value of the FileID ,...

Thanks for the Reply Gila,

I want to insert the Transaction_ID values from FILE_ID value.How can I