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

Hopefully this helps someone else...

I got Itzik Ben-Gan's book Inside MS SQL Server 2008 T-SQL Querying, and basically modified one of his SQL queries to suit my problem. ...

Answered my own question... ("Re-search. It means 'look again', don't it?") After a few minutes of surfing, I found this: http://stackoverflow.com/questions/2120544/how-to-get-cumulative-sum, which I basically tweaked for my own...

You could always have Reporting Services do the pivot... just drop a matrix onto your report...

I'm needing to get the most recent AP_Ex.Ap_Expt_Date for each AP_Ex.Student_ID

SELECT Max(AP_Ex.Ap_Expt_Date) As LatestDate, AP_Ex.Student_ID

FROM...

GROUP BY AP_Ex.Student_ID;

Do you really mean Modals? Or do you really mean Models? From the context, it would appear you mean "Models".