Is this a homework assignment?

WHERE SomeColumn IS NULL

OR SomeColumn IN (1,2);

is how I would do it, but then I never tried putting NULL in a list as if it...

If you cannot add an IDENTITY (increment) to the destination table, then I do not think it can be done. Data in a table is inherently UNordered, unless you...

Create the table and add the identity column before inserting any records. If you have to create a linked server and create and run an insert to your new...

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...