i want to read specific record form a table for example (tb1)
that consist of 3 field and each field contain of 100 record
i want to read record from 80 to 90 but with out using ID field
View Complete Post
If I use Microsoft.Jet.OLEDB.4.0 to retreive for example named range or sheet from Excel and use it as data source for some server control on the ASP page, everything works fine. But when I try to get table from Excel like this: "select * from [Table1]", debugger complains that database engine could not find object Table1. So how should I reference Table1 in Excel file so that the database engine could find it?
I have a single select query with multiple table joins in it.
I want to retrieve the Most Recent records from one of the table among the tables in multiple joins.
(select t1.col1, t2.col2 , t3.col3, t4.col4, t4.Add_Date,t5.col5,
from dbo.table1 t1
left outer join dbo.table2 t2 on t1.col1=t2.col2
left outer join
(select col3 from dbo.table3 where condition1="expr") as t3
left outer join dbo.table4 t4 on t1.col1=t4.col4 order by t4.Add_Date
left outer join dbo.table5 t5 on t1.col1=t5.col5 )
Problem is that, I am not able to use the "Order by" for a particular table.