Hi

Data is getting imported, when i remove few contents from the file. Is there any problem in the data. if it is a problem then how to find it.....

I recommend you to check the user rights....

I have an query regarding index.....

ex

idx1 (emp,depid) non clustered index

an covering index was created in the combination of empid and depid. whether i need to use...

could you provide me the links?????

ok

if i have two non clustered index and trying to use the column in where clause i.e

ex:

ind1 empid (nonclustered)

ind2 ...

Thanks.

in my example if the index is created as

ind1 empid (non clustered)

ind2 empid and...

Hi,

why joins should be in the from clause not in where clause?

could you pls explain it...

Hi,

i recommend you to provide the code, so that presice solution can be provided.

select s1.account, s1.date

from @sample s1

where s1.date in (select TOP 3 s2.date from @sample s2

where s1.account = s2.account

order by s2.date desc)

group by s1.account, s1.date

order by s1.account, s1.date desc

I...

thanks peter

Thanks Peter!!!

Thanks peter!!!!!!!!

Itz really useful for me. Now the above query will return latest 2 invoices for that account. if i need to return latest 10 or 12 invoices for that...

i used cursors for the above result.... but i need to avoid the cusrsor????

YES, I NEED ONLY LATEST 2 INVOICE FOR THAT ACCOUNT....DO YOU HAVE THE QUERY?????

i need to select only the latest 2 invoices for that account so inv4 should not be retrieved.