I came across this http://www.reddybrek.com/post/Return-Top-Row-from-Left-Join-using-SQL-Server-2005.aspx

But I notice the database is SQL 2000 compatibility mode still.

I sort of don't want to do a top 1 columna, columnb.

Guess I'll have to...

I got better information...They want just the first account number.

select name, table2.account, table3.city

from table1

left join table2 on table1.userid = table2.userid

left join (select top 1 account from table3)

as tab3 on table2.account...

I'm not sure why you're joining to

This assumes that there is only one city per account. If you have multiple cities, then you have a problem. You...

Rob Schripsema (1/27/2011)

---

What results are you expecting to get?

It looks like your first output window is giving you what you are asking for -- did that come from your...

It's supposed to insert the job history into a new table, but I only get nulls inserted. The query works ok as is:

select server, left( name,50), substring(str(run_date),5,2) + '/'+...

I am getting this error:

(3 row(s) affected)

Msg 1038, Level 15, State 5, Line 1

An object or column name is missing or empty. For SELECT INTO statements, verify each column has...

I found one MS KB related to this, but we have the latest version of that ActiveDS.dll which is 5.2.3790.3959 (srv03_sp2_rtm.070216-1710). It's from 2007, they were talking about...

Very detailed. I am going through a server consolidation this Sunday with some 70 databases and two machines. (We need a stressed icon.)

Also we have web site...

Yes it must of grown beyond 5 mb.

Thanks!

Mohit (3/26/2009)

---

2 Tim 3:16 (3/26/2009)

---

DBCC Memorystatus may help. It will at least show you how much AWE is currently being used. It's not unusual at all for the...

Yep, I have SQL memory set 0 minimum to 14000 maximum

Yes, I had sorted by memory in task manager. The largest memory consumer was SQL with around 127 meg...

Yes, that ip is the local machine. I was trying to load security in MS, but it took forever. I just rdp'd to it to view it. ...

How many years have you been using SQL Server?

Check out amazon.com reviews of SQL books. Some of them give you an idea what level the book is for like...

I got married a few years ago. My wife and I are both middle aged. She wanted to move from the city out to the suburbs where I...

I was told it has 8 drives.

Disk time on all servers is pretty low. Only one of them has any sort of activity which around 10% average.

Disk...