jim.powers (7/8/2008)

---

To understand this, you need to understand the order in which the statement is processed. The FROM clause is processed first. SQL Server (or any RDBMS for that matter)...

orrego.cesar (7/8/2008)

---

I have a big question (I guess that is big only for me), but... 'what is the real advantage of INNER JOIN??? why not to use WHERE condition to...

I don't have that kind of luck...

Is there a method I can use to have a query recompute the estimated query plan when I'm querying it?

The reason I ask...

My path to DBA hood is convoluted.

I started out providing Net admin/support for a .com in the 90's and continued on that path for a couple years. During that...

nadiyal (6/25/2008)

---

hi,

being a DBA, a data analyst, a sharepoint developer, VB develop and what ever we are trying to do right now, I have got a question for you:

how to...

Tom Garth (6/25/2008)

---

Steven Cameron (6/25/2008)

---

How much is SQL Server Developer Edition? $150.00? Something like that. Doesn't have to run on a server either. If they don't have it, then they...

Are you using stored procedures?

Try something like this if you are

create procedure showdate

@inputdate datetime = '01/01/9999'

as

if @inputdate = '01/01/9999' set @inputdate = getdate()

select @inputdate

Thanks! 🙂

What Steve has said there is the sum of it... DISTINCT operates on all of the fields you list, not just...

Jason Selburg (6/19/2008)

---

Or you could take advantage of the fact that an IP address just happens to have four parts just like a fully qualified SQL object name and use...

Also check that the service that is trying to send the file has access to both the folder and file.

Also... remember that the path and file name have to exist on the SQL server... so if you're creating them on your local machine they aren't on the SQL server's...

The structure of these tables isn't exactly the best... either fk_phonetypeid should be in customerphone, or there should be a master customer table. Otherwise you have to operate...

Iggy (6/22/2008)

---

I think you misread the answer. The answer according to the...

Jeff Moden (6/13/2008)

---

Now, I agree with THAT! That's my favorite format because it puts all of the aliases in the same position horizontally speaking AND it's the same format...