SQLRNNR (3/21/2012)

---

Possible causes:

AV has the file locked

The data file is not associated with the database that you detached.

You don't have modify permissions with your user account to the location where...

it depends on what type of partition. a hard drive partition with no data from the database? thats no problem. now you will loose every thing else...

from the OP's question it seems like he is very new to sql

here are 2 articles on joins, inner and outer.

Inner Joins - http://msdn.microsoft.com/en-us/library/ms190014.aspx

Outer Joins - http://msdn.microsoft.com/en-us/library/ms187518.aspx

my question is why uninstall the framework. if there is a space issue there are other places you...

Could you post your solution.I have a similar problem and attacked it with cross tabs. I don't like pivot but have used it. Cross tabs seam simpler to...

ColdCoffee (3/20/2012)

---

CELKO (3/20/2012)

---

This guy is trying to get us to do his job interview. Let's hunt him down and keep him from hurting his employer by letting them know what...

why not show off a little. maby some newbie will search the forum (LOL) and find this reply and go wow thats cool, did not...

http://blog.sqlauthority.com/2009/02/02/sql-server-t-sql-script-for-fizzbuzz-logic/

after i coded it and people said its a common problem i googled it. found that first result. sometimes a google search is better than asking...

CELKO (3/20/2012)

---

SQL Programming Style

im currently reading it and its preaty good. gives a good base to work off of. my shop uses a sligltly different naming conventions and...

roryp 96873 (3/20/2012)

---

I figured as much as well, but if they...

homework or interview??

i have the answer just want to know why

EDIT well since its posted here is mine

with E1(N) as (Select 1 UNION ALL Select 1 UNION ALL Select...

Matthew Cushing (3/20/2012)

---

Oh, don't get me wrong. I would never set it up like that. It was a question that someone came to me with to see if...

There is no problem with the alias however you need to use the actual column name I'm the group by and not the column alias. That's where your error...

Brian.cs (3/19/2012)

---

Finnlake (4/1/2010)

---

In our case we cannot batch requests ie messages since we then would have to keep the messages in memory and if the power goes all messages are...

thats exactly what we needed. Thanks

This may work but will break (kinda) if there is more than 1 entry in each column for each contact.

SELECT m.Contact, MAX(m.History), MAX(m.URL1), MAX(m.URL2),...