I have same problem and i tried by setting my table field as varchar and excel sheet field as text but still have null values. So i am running differents files...

Thanks for reply

Yes i have done that. I have changed smalldatetime field to char but out put i got is '0007-05-27' so thinking...

Oops Done...

Thanks a lot Jan it's done working fine

It happened because of zero when i replaced that from my num table it's working fine.

Thanks a lot

Kind Regards

Vandy

Sorry Jan to be pain...

Everything is ok but showing more lines

eg quantityinvoiced =2 it showing me three lines ...

Regards

Sorry Still not working may be doing something wrong

It showing fully duplicate lines but i need quantity invoiced always one ..

if quantity invoiced=6

it showing every time 6 but i...

This is the query

SELECT     NBillingF.OrderNumber, NBillingF.Customerorderreference, AccountOwner.company, NewCARORDER.Orderaddressline5,                       Jcustomers.company AS Expr1, NewCARORDER.Orderaddressname, Product.[Manufacturer Part Number],  Product.[Product Description], NBillingF.QuantityInvoiced, NewCARORDER.SystemOrderDate, NBillingF.DateInvoiced, NBillingF.Unitprice,              NBillingF.InvoicedValueBase

FROM         NBillingF INNER JOIN

                      AccountOwner ON NBillingF.Customer = AccountOwner.account...

This is the query

SELECT     NBillingF.OrderNumber, NBillingF.Customerorderreference, AccountOwner.company, NewCARORDER.Orderaddressline5,                       Jcustomers.company AS Expr1, NewCARORDER.Orderaddressname, Product.[Manufacturer Part Number],  Product.[Product Description], NBillingF.QuantityInvoiced, NewCARORDER.SystemOrderDate, NBillingF.DateInvoiced, NBillingF.Unitprice,              NBillingF.InvoicedValueBase

FROM         NBillingF INNER JOIN

                      AccountOwner ON NBillingF.Customer = AccountOwner.account...

Thanks Ian

Realy Helpful..........

Hi All

Thanks for your help.

Apologies for my ignorance actually first time i am working on sql server so need more help. I have around 10,000 lines for one day and...

Thanks Ian Yates It's working

I am working on OpenQuery First time so could you please let me know how to pass parameter to OpenQuery?

Regards

You can use like that:-

SELECT DISTINCT dbo.tblVENDOR.VendorName, dbo.tblVENDOR.VendorShortName, dbo.tblRAIL.RailDescr, dbo.tblSPIKE.SpikeDescr, dbo.tblRAIL.ScreenValue,            dbo.tlkpSID.SId, dbo.tblConVendtoSuperClient.VendorID

FROM dbo.tlkpSID INNER JOIN dbo.tblSPIKE ON dbo.tlkpSID.SidID = dbo.tblSPIKE.SidId INNER JOIN dbo.tblRAIL INNER JOIN            dbo.tblVENDOR...

Thanks a Lot Guys

It's working i am using Jason's method

Thanks

Hi

I updated my service pack 1 to 4 but still i have problem.

MMc stucked after some time and when i click close buttom it's giving me above error having...

Don't know how to freeze pane but yoou can count and show only 10 or 20 rows in that case report will show you one page with 10 or whatever...

Report work with store procedure justcheck your datasource which command type you have text or store procedure......... if you have store procedure type then can post more information about your...