After looking at the posts this is what i think the op is after with the second set of provided input (notice there are 2 record numbers)

DECLARE @data...

If you need to compare the data sql compare is a good choice...

Bobby Glover (11/9/2012)

---

Praise the lord for this post. I have the same issue 1000 tables 750 are heaps, the wierd thing is they have NON-CLUSTERED PKs in all the tables....

kwoznica (11/9/2012)

---

Something that looks like the below result set. Where we have an aggregate average on the day of the week

DayOfWeek Sunday Monday...

do you only need one text file per insert? ie. If you insert bob, jim, and sally in one batch and bob and sally are unique (new) ...

jasona.work (11/9/2012)

---

The cake...

ScottPletcher (11/8/2012)

---

It depends. Often it's faster just to keep the desired rows rather than delete all the undesired. That is, copy the good rows to another table, trunc...

apple built self aware robots

well i missed it damn

BMI

ill second this if you have never worked with bcp. of the 2 i found...

sqlizer (11/7/2012)

---

I am trying to run this query but getting following error:

Query:

insert into TB_HOSP_CORE (MON) SELECT AMONTH FROM hosp_core WHERE TB_HOSP_CORE.PATIENT_ID = hosp_core."KEY"

Error:

Msg 4104, Level 16, State 1, Line 1

The...

if your just looking for a report of backups you can query msdb.dbo.backupset which contains allot of information

select top 10 b.database_name, b.backup_start_date, b.backup_finish_date

from msdb.dbo.backupset b

with a join to...

when we moved servers we had a scheduled down time and did a backup and restore on to the new server. main benefit we found is that if for...

so its looking that on by dual core box i did not hit any parallelism (ill have to look at the query plans tomorrow) and if i had cross...