Check out this thread

😎

Quick suggestion, check out this one, The Data Warehouse Toolkit

😎

Quick note, it is better to use the Point method.

😎

UPDATE Z set Coordinates = geography::Point(Latitude,Longitude ,4326)

FROM dbo.ZipCodes Z;

The spatial data types are implemented in SQL Server as CLR, which...

In this case you have to use the ALTER statement, here is a quick example

😎

USE tempdb;

GO

SET NOCOUNT ON;

/* Drop the table if it already exists */

IF OBJECT_ID(N'dbo.TBL_CHANGE') IS NOT NULL...

Quick note, the modify method only applies to the XML data type, to update a value in a table use the UPDATE statement The following example updates the value of...

Quick solution, should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE

(

SNAME VARCHAR(15) NOT NULL

,A1 CHAR(1) ...

Tom, must say that I find this comment totally inappropriate

😎

Slightly amusing, not even an implicit conversion here, just a Constant Scan of a Scalar string ($0.0000), guess it works for the most common ISO-4217 currencies' single symbol codes, would...

Lynn Pettis (2/7/2015)

---

Eirikur Eiriksson (2/7/2015)

---

Lynn Pettis (2/7/2015)

---

Eirikur Eiriksson (2/7/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (12/12/2014)

---

Should have started this a while ago!

(To the...

You are very welcome, if you have any problems just let us know.

😎

A quick thought on the remainder of the problem, what is missing (from my point of view)...

Lynn Pettis (2/7/2015)

---

Eirikur Eiriksson (2/7/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (12/12/2014)

---

Should have started this a while ago!

(To the tune 100 Bottles of...

Quick thought, add a case for the zero length message entries, otherwise you solution is fine.

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @Files table (ID int identity(1,1) primary key,Filename varchar(50),Date_Created datetime)

insert into @Files...

Here is a quick possible solution which uses the ROW_NUMER function to enumerate the values in Table B in order to create an iterator for linking with the EventRefSeq from...

Quick thought, each statement will execute regardless of the success of other statements in the dynamic code, hence errors and transactions must be explicitly handled, consider this example

😎

USE tempdb;

GO

IF OBJECT_ID(N'dbo.TBL_TRAN_TEST')...

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (12/12/2014)

---

Should have started this a while ago!

(To the tune 100 Bottles of Beer on the Wall)

......