is there a reason you need to? Just write 3 different queries, one for each table. Or have 3 dataflows in SSIS.

add an incrementing identity column to the destination table before running inserts?

Are you using SQL Server Security or Integrated Security?

What happens if you log into the computer as local admin? If that works, its most likely a security issue in...

Okay, sorry about all the noise. 😀

Problem solved!! Really this time! The map ROCKS!

Here's the update query that worked to fix/populate the Geography data type...

-- you can use...

Mystery SOLVED!!! Here's the cheat code I found:

DECLARE @g geography = geography::STGeomFromText('POINT(' + CAST(@lng as Varchar(50)) + ' ' + CAST(@lat as varchar(50)) + ')', 4326)

which is here:...

use SSIS or bcp. If you play with SSIS at all, you can preview the contents of the text file before running the import.

I can get the individual Longitude and Latitude values for the addresses in my table using this SQL:

UPDATE h

SET h.hLongitude = pa.Longitude,

h.hLatitude = pa.Latitude

FROM House h

CROSS APPLY ProcessAddress(...

sandeep4testing (3/8/2012)

---

Hi Friends,

I'm trying to adding the primarey key on table column. table having 7 numbers of rows,

Any one can tell me how to primarey key on table.

EX:

create table index1...

Just for fun, I'll post the create table and insert statements that I used to figure this out... no doubt I should have done more (to see how slow the...

Okay, got the new one to work too... took a little while, so maybe I learned something in the process... (To test on larger datasets???)

ALTER PROCEDURE [dbo].[uspNormalizeData3]

AS

-- Jeff Moden's new...

Just for fun (and a little learning), I made it work with your example:

SELECT lw.SomeCode, lw.Seq, lw.LWType, lw.Age,lw.Race,lw.Sex,

SUBSTRING(','+lw.Crimes+',',N+1,CHARINDEX(',',','+lw.Crimes+',',N+1)-N-1) AS Value

FROM SCRIDB.dbo.Tally t

CROSS JOIN lwNames lw

WHERE N < LEN(','+lw.Crimes+',')

...

Create two tables with the same basic structure, one for each design. then run the same INSERT script against each one and do performance testing. The only way...

Is there a need to shrink the file? Do you know all the ugly things that shrinkfile does to your indexing etc? Unless you absolutely must do it,...

This was interesting... Ran this

CREATE PROC uspHouseRepairs

AS

SELECT pa.Longitude, pa.Latitude, geography::Point(pa.Longitude, pa.Latitude, 4326) As MyPoint, h.Location, h.StreetAddress, h.City, h.HState, RepairList.RepairName, RepairList.RequiresLicense, HouseRepairs.StartDate,

...

HappyCat,

Thanks for answering, but mission failed! Your SQL ran, but nothing got updated.

It would appear that for some reason, I cannot use CROSS APPLY in an update query.... If...