See the following help topic in Books Online:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/7604161a-a958-446d-b102-7dee432979d0.htm

It might help you see how this works.. What you CANNOT do is just specifiy the structure via the selected values....

Okay... consistency is usually a good thing, but you still haven't really said anything about the files themselves, and how they are used. Are we talking about...

One open question your query leaves open is whether or not there's any other join condition needed to pick a specific record from the staging table to insert into the...

Lynn Pettis (12/4/2012)

---

Compare:

DECLARE @date DATE = '20121202';

SELECT

CASE WHEN datename(dw,@date) <> 'Sunday' THEN CONVERT(varchar(10), DATEADD(WK, DATEDIFF(WK, 0, @date), 0),

103) ELSE CONVERT(varchar(10), DATEADD(WK, DATEDIFF(WK, 0, @date), - 7), 103) END

go

DECLARE...

What happens when the main table contains BS1234 as well as BS12345 ?

As ugly as it might perform, you may need to join like this:

SELECT fld1, fld2, fld3

FROM VISITS AS...

How about:

CASE

WHEN DATEPART(dw, THE_DATE) = 1 THEN DATEADD(dd, -6, THE_DATE)

ELSE DATEADD(dd, 0 - (DATEPART(dw, THE_DATE) - 2), THE_DATE)

END

where THE_DATE is assumed to be the date field...

Well...

You could use a linked server from each of the source SQL 2000 instances.... all pointing to the same place. Of course, that's not a...

There are an awful lot of ways to take data from a table and store it in a file, but the critical question is why as opposed to how. ...

While I agree that having a single query to accomplish this remains a convenient thing, it may not be quite sufficient from a reliability perspective. Having 6...

Interesting concept, but as the article didn't present it with much in the way of specifics, it's too risky for me to hope to get it right. As...

I've searched the internet high and low for a 32-bit JET driver, but can't find one, unless I'm just using the wrong search terms... Do you have a...

The gremlins are everywhere....

Sadly, the problem is fixed because somebody fat-fingered a table name in existing code and after OBFUSCATING it for publication here, I could no longer tell the...

Here's the portion of the output that has the problem:

Key1 Key2 Key3 Key4 ITEMID VOL_CEQ VOL_UNIT ITEMID_COUNT MIN_VOL_CEQ MAX_VOL_CEQ MIN_VOL_UNIT MAX_VOL_UNIT

TN...

Sounds to me like a solid approach, with a bit of the old 80-20 rule in play, in that you use string functions for the "easy stuff" (or at least,...

Got what I needed... found the ADD_MONTHS function, which worked like a charm.

I used the rough equivalent of:

SELECT STUFF, STUFF_2, AND_MORE_STUFF

FROM TABLENAME

WHERE DayDt >= ADD_MONTHS(DATE - EXTRACT(DAY FROM...