Jeff Moden (1/15/2008)

---

GSquared (1/15/2008)

---

Jeff Moden (1/14/2008)

---

Heh... Keep in mind that the BETWEEN examples are rarely correct because they don't allow all times of the day to be included or...

Well - assuming you REALLY want to do this (I mean - they were entered in as negative values for a reason, weren't they?), look into the Books online for...

Actually - let me correct myself - other than it being a typical flat file (meaning - OODLES of blank fields for all of the denormalized data it's carrying) -...

All right - next question - what problem are you having with it?

Just finished importing it into a table it built. total time: 3:20 (as in 200...

Jeff Moden (1/12/2008)

---

Ok... you certainly shouldn't post that data... it contains private information and understood about the source code.

Here's the real key... you're using an application to insert 2.2 million...

Table names shouldn't start with a number. They fall into the category of identifiers which , per Books Online, must conform to the following:

The rules for the format of regular...

Wayne - insert Char(13)+char(10) ahead of the RTRIM if you want to have the line feeds...They'll show up when you inspect it outside of QA or SSMS.

It's one of the option in Query analyzer or SSMS.

In QA - Ctrl+K

in SSMS - Ctrl-M

That will do the ACTUAL execution plan, so you then have to...

Oh - don't be silly. SELL him to Microsoft, so that you can pay for...

You can do something with the help of a temp table:

--now for the new stuff

create table #runningcomments(keyno int,line_no smallint,comment varchar(70),runComments varchar(8000))

create unique clustered index UC_runncomments on #runningcomments(keyno,line_no)

insert #runningcomments(keyno,line_no,comment)

select sptd_keyno,sptd_lineno,sptd_text from...

Well - considering you haven't provided any details of what you're trying to do - it will be hard to make any assessment as to performance.

I'd be worried about trying...

I guess it's a matter of definition, and may well be where Steve Pitt was...

While you're at it - might as well use the same logic to look for any fields sporting double-quotes in their contents too. That one will cause some trouble...

For the last year or so - I've been using Database projects in Visual Studio to store my code. The projects then get stored in Visual Source Safe for...

Well - I would tend to say the trigger IS in fact the right way to do it. Are you sure you don't want to try to figure out...