xeops (2/28/2011)

---

Here is how the two tables are setup:

Table1 (master)

ID

Location

LocationID

Lat

Long

Map

Table2(child)

ID

LocationID

Map

SQL query

SELECT

Table1.ID,

Table1.LocationID,

Table1.Lat,

Table1.Long,

Table2.[Map]

FROM Table1

LEFT OUTER JOIN Table2 ON Table1.LocationID = Table2.LocationID

i know this querry is worng, but what...

jcrawf02 (2/28/2011)

---

Stefan Krzywicki (2/28/2011)

---

jcrawf02 (2/28/2011)

---

I'm just growing tired of having to explain Microsoft's commercials to my wife. Some idiot on the screen says "To the Cloud..." and I have to...

Brandie Tarvin (2/24/2011)

---

That's a good point, Tom. But is "enemy" a good word choice...

Good point. I was only focused on the technical "how do you...

richard.kirby (2/23/2011)

---

Hi

I need to concatenate the following (which executes a function to select the financial year from a DateTime field):

SELECT *,

dbo.Fn_FinMonth (DatePart(MM,[Graded Date])) FinMth,

e.g. Month 04 = Financial Month...

adam spencer (2/23/2011)

---

Hi,

If I convert the data types like below will this the data types stick in the selected into temp #5407?

select convert(varchar(50),HIC) as HIC,convert(varchar(10),ICD9)as ICD9,HCC, DOS

into #5407

from...

Thanks to everyone involved in writing this one. Great article!

Very useful article. Thanks very much for writing it.

PSB (2/16/2011)

---

I a using the following in the where clause

DATEPART(m, ALLPOINT.dateloaded) = DATEPART(m, GetDate()) AND DATEPART(yyyy, ALLPOINT.dateloaded) = DATEPART(yyyy, GetDate())

but it is not pulling records which are only in...

Not sure what version of SQL you are on, so I'm assuming SQL 2008.

This is only one possible option - there are certainly others, but hopefully this will get you...

I don't think you are.

I've seen plenty of "introduction to indexing" articles that are...

GilaMonster (2/15/2011)

---

The academic nature of the article, along with the presentation as absolute fact were the two things that worried me. I do a lot of writing about indexes and...

Yeah, that's probably the most dangerous statement in the article. There are some excellent tests that show that heaps don't perform better for inserts. And they certainly don't for deletes...

I disagree with this statement. I...