Joins can connect as many tables as you like (up to about 32,000 if I remember correctly). The connections can be as simple or complex as you like. ...

See if this will do what you need:

SELECT

1 AS ID,

1 AS clientID,

CAST('2008-11-05 00:00:00' AS DATETIME) AS enrolldate,

...

Try using XQuery instead of the older methods.

DECLARE @doc XML;

SET @doc ='<NewsDTO>

<NewsId>A4C13A4A-2350-4D21-AB06-9E2946182D39</NewsId>

<NewsId>A3613580-99C3-489D-9988-92E5F24BC8F7</NewsId>

<NewsId>F934D9F9-A73F-4ACF-B225-8A0ED7BAF8C4</NewsId>

</NewsDTO>';

SELECT Doc.Nodes.query('.').value('(/NewsId/text())[1]','varchar(100)')

INTO #temp

FROM @doc.nodes('/NewsDTO/NewsId') Doc(Nodes);

Makes sense, and you're welcome.

Expand the numeric to 6,4. Have the front end...

Bad idea!

First, you won't be able to query it mathematically. Second, formatting...

Something I just thought of: Triggers don't usually fire for bulk inserts. Can you test importing from a text file using a bulk import method? Might seem silly...

Jeff Moden (10/24/2010)

---

Wow... thanks for the insight on SSIS, folks. I've mostly resisted spending any decent amount of time on it because of what I've seen. Thanks to...

SQL just sees a LUN as a drive, so the only limits are the same ones as for a drive of any sort. So, you pretty much have a...

Would it be easier to back up the databases, and then generate a restore script that puts the files where you want them?

Jinx! 🙂

Float is more likely to keep it in the format that Excel uses, but that also has some issues.

Yeah, that's totally within the capabilities of SQL. It's pretty usual, in fact, since it's the basic structure of many-to-many joins.

Are you familiar with writing join statements connecting two...

Does it cascade? If, for example, you had an enroll date that was within 8 weeks of a prior enroll date, which was within 8 weeks of an even...

If I understand you correctly, you'll have to shred the XML and then use that to generate a delete statement. That's pretty straightforward.

Which version of SQL Server are you...