Here...

Forgetting about the table issues, here is a way to convert minutes to hh:mm format:

declare @time numeric(10,2)

set @time = 97.10

select convert(char(5),dateadd(minute,@time,0),8)

Of course, dateadd takes an integer for the increment, so...

Is this what you are looking for?

You may need to tweak the EXISTS statement to handle InventoryIDs that have more than 1 digit...

;with data(DrugID, InventoryID)

as

(

select 'MAGN2IVPB','FLR-4N' union all

select 'MAGN2IVPB','FLR-5N' union...

This brought back memories of a thread...

My latest submission is based on the string manipulation, but simplified... on my QUAD core PC I like the results, but let's see how it does on yours.

I borrowed the...

Wow! that shows how slow my isnull/nullif/apply method is!

Bulk logged with select into will make a difference, yes - don't use insert into.

You have to remember though that with that setup, you are going to thrash the disk...

Does the target database have pre-allocated storage large enough to store the data?

Are the databases stored on different hardware or the same?

What is the maximum throughput of the storage system?

Have...

Where are you transferring the data to? Same database, different database, same server, different server?

What is the table definition?

mikes84 (7/6/2011)

---

I have a situation where I'm querying two tables, each that has up to two hobbies listed. The first table has hobby1 and hobby2, and the second table has...

pbyrum (7/7/2011)

---

It appears the code will take the whole file and place it into a column in the table.

I am looking for is taking the data in the XML file...

SQLkiwi (7/7/2011)

---

mister.magoo (7/7/2011)

---

With the PRIMARY KEY defined, the query plan shows a SORT DISTINCT which results in 1 row from the join of the two tables, and seemingly this result...

I don't know if anyone has actually answered the question about why the two results are different...

With the PRIMARY KEY defined, the query plan shows a SORT DISTINCT which results...

tommyh (7/7/2011)

---

Using your excellent testdata i came up with

select

SubString(s, 1, 20),

SubString(s, 21, 20),

SubString(s, 41, 20),

SubString(s, 61, 20)

from...

Is this what you are after?

SELECT AA.AgencyName,AA.AgencyID

FROM (

SELECT CA.AgencyName, CA.AgencyID, COUNT(*) OVER(PARTITION BY CA.AgencyName) AS AgencyIDCount

FROM ContactAction AS CA

GROUP BY CA.AgencyName, CA.AgencyID

) AS AA

WHERE AA.AgencyIDCount>1

ORDER BY AA.AgencyName