select *

from dept d

left join empp e on e.dept = d.dname

where e.dept is null

Why do you the name of the department in your employee table. You should have the...

You're welcome. Glad that got you going.

Take a look at the link in my signature about dynamic cross tabs. It will walk you through how to do dynamic versions of this type of thing.

carl.meads (7/15/2013)

---

I'm sorry but I do not have those things you are asking, I basically have a sql query that gives me;

Period

AssetCategory

Spend

No Jobs

Average (£)

I have 8 periods worth of data,...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

If you can't connect to the sql box from your machine you won't be able to connect to it through an application either. The application you want to run MUST...

You have a few issues going on here. First as previously pointed out what you posted is basically unusable because we can't read it. I ran this through a formatter...

Thanks for the correction. I did not realize you could drop a user remotely like that.

Grant Fritchey (7/15/2013)

---

Brandie Tarvin (7/15/2013)

---

hvermaak (7/15/2013)

---

Brandie Tarvin (7/15/2013)

---

GilaMonster (7/15/2013)

---

One of the worries I have when travelling is that I have my passport, ID book and driver's licence with me all...

Erland Sommarskog (7/14/2013)

---

Sean Lange (7/12/2013)

---

No, SSMS 2005 SP3 can connect to SQL...

It does seem to be something with connectivity. Can you setup a link server to...

Googling your error message it sounds like LOTS of people have had this issue. It seems to be predominantly happening with broadcom NICs. The solution in those cases seems to...

I have not experienced that. I would love to see an example of it....

mmartin1 (7/12/2013)

---

Create a date variable , assign the value of CONVERT(DATE, DateAdd(yy, - 5, GetDate())) to the variable and use the variable instead in your query. This may be...

webtekkie (7/12/2013)

---

Hi all,

I will keep this as simple as I can despite the complexities. I'm looking for a strategy rather than specifics - what have I missed?

I have a...