What's wrong with the suggestions made here

http://www.sqlservercentral.com/Forums/Topic507555-145-1.aspx#bm507909

http://www.sqlservercentral.com/Forums/Topic507555-145-1.aspx

In case you need the numbers concatenated

DECLARE@Sample TABLE (AgentID INT, FromNumber INT, ToNumber INT)

INSERT@Sample

SELECT1, 11, 16 UNION ALL

SELECT2, 20, 24 UNION ALL

SELECT1, 20, 22

;WITH Yak (AgentID, FromNumber, ToNumber)

AS (

SELECTAgentID,

FromNumber,

ToNumber

FROM@Sample

UNION ALL

SELECTAgentID,

FromNumber...

In table A, the column UPC is the clustered primary key.

If you want to JOIN on ID column, both table A and table B should have an index over ID...

Yes, I posted one solution 5/22/2008 1:50 PM but that depends on unique values. Duplicate values will be removed, but that might not be a problem due to business rules?

Also...

Yes you could.

I just thought of a way to include the result as a correlated subquery or even in a view.

Sergiy (5/27/2008)

---

You expect a desired result from a plumber, but if you'll tell him which screws to use or how to fix the pipes - he'll in best case will...

Try this for fun factorials (Number has to be a positive non-zero value)

SELECTEXP(SUM(LOG(Number)))

FROMTally

WHERENumber BETWEEN 1 AND 170

I am their business partner that solves their problem in a manner that they themself later can administrate, understand, maintain and...

No truncate (which is only minimal logged)?

Any open transactions rolled back?

You're not much of a team player, are you?

In which reality/world did you make those changes you write about?

Everquest?...

Try this undocumented stored procedure

master..sp_msforeachdb 'ALTER TABLE [?]..CUST ADD ADDRESS_2 VARCHAR(50)'

if the table does not exist in current database, you will get an error for that database instead of creating...

Also asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=103571

To get all records dated on the last day only.

If you do not specify time part, 00:00:00.000 is used.

BETWEEN '20080516' AND '20080517' would get you all records betweeen

20080516 00:00:00.000

20080516 00:00:00.003

...

20080516...

No Ryan, it wasn't an attack against you. You know that. We have known each other a long time now. You have improved my queries and I have improved your...