I am using SQL Srver Express edition if that helps

Its running..I am able to connect to the Sql server in Network drive..just not on my local..

BTW, I can register and connect to other servers on the network..Just the local server is having problem.

I thought I explained it in detail (atleast I thought I did). Here you go again....

We have AS400 ERP system. From the ERP to the stage tables in SQL Server...

Any other suggestions/advise please?

How about Dormant status? What does it mean?

I am still not getting it...

Here is my XML..Can somebody tell me how to get the layout from it using sql?

-

...

This one just loads the entire file into one line. I need to be able to extract the exact columns so that I can give the file layout to...

This is what I did guys...Sorry I din't post my query earlier...

IF OBJECT_ID('tempdb..#proj') IS NOT NULL DROP TABLE #proj

SELECT DISTINCT T1.ProjID

into #proj FROM ProjectComments t1

join proj t2 on t1.projid...

Outer APPLY worked guys. Thats a bunch for your help.

No..still not getting what i wanted to...

This again goes back to listing only 5 records. What I want is last 5 comments for every projectid in the table. Three are about 10,000 records in ProjectComments table.

The problem is I need this for every project ID...When I do top 5 only the 5 columns for one projID shows up

Christopher,

That hit right on the money.

Thanks guys so much for your help.

Appreciate it.

Converting to deciman(12,7)