meilenb (5/27/2015)

---

Alan.B (5/27/2015)

---

Lynn Pettis (5/27/2015)

---

meilenb (5/27/2015)

---

Alan.B (5/27/2015)

---

Emph. mine

How is the science clear on climate change when the scientists can't agree? Plus,...

meilenb (5/23/2015)

---

I'm in -- except I wouldn't want everybody doing these tests to prove something that has already been proved.

I would be more inclined to have a mix of best...

This link below gave me some ideas when I was putting together a query.

http://stackoverflow.com/questions/407671/query-ad-from-sql-server-2005

This is a query I actually got to work at my place, what I found interesting is...

I actually meant that I would use the update statement, the other inserts were just setting up a test to see if the update works. From your comments, I get...

I apologise for not understanding the question if thats the case, but if you just want the geography value for each latitude and longitude, you could try the "point" function...

Your nesting confused the heck out of me LOL, also afraid I can't help you troubleshoot xml, I'm pretty slow at that. Anyways...

-- is this what you're trying to do?...

some pretty good discussion here:

http://stackoverflow.com/questions/10269172/quickest-easiest-way-to-use-search-replace-through-all-stored-procedures

Grant Fritchey (4/16/2015)

---

patrickmcginnis59 10839 (4/16/2015)

---

The hash key is computed as (object_id * database_id) mod (hash table size). For plans that are associated with adhoc or prepared plans, the object_id is...

The hash key is computed as (object_id * database_id) mod (hash table size). For plans that are associated with adhoc or prepared plans, the object_id is an internal hash of...

Here's my insert version for completeness!

create table EmployeeCountry

(

EmployeeID int,

CountryID int

)

create table Employee

(

EmployeeID int,

Country1ID int,

Country2ID int,

Country3ID int

);

insert into EmployeeCountry select 10001,20001;

insert into EmployeeCountry select 10001,20002;

insert into EmployeeCountry select 10001,20003;

insert into EmployeeCountry...

Sean Lange (4/14/2015)

---

And to further my point, the cross tab approach would work for a whole slew of employees in one pass. The insert and multiple update approach you would...

Sean Lange (4/14/2015)

---

patrickmcginnis59 10839 (4/14/2015)

---

Sean Lange (4/14/2015)

---

liamdemasi (4/14/2015)

---

I am not splitting it back into 2 tables. I am trying to get the CountryIds associated with an EmployeeId in the EmployeeCountry...

Sean Lange (4/14/2015)

---

liamdemasi (4/14/2015)

---

I am not splitting it back into 2 tables. I am trying to get the CountryIds associated with an EmployeeId in the EmployeeCountry table, then I am...

Eirikur Eiriksson (3/17/2015)

---

First thought is that fixing the ageing OS/SQL Version should be a higher...

The reason for using BIGINT probably...