How to do this from DTS?
me_at_privacy.net
Date: 05/06/04
- Next message: John Michl: "Customer Rank Query"
- Previous message: Gregory A. Larsen: "Re: Checking if a table exists, so that it may be dropped before recreating it"
- Next in thread: Allan Mitchell: "Re: How to do this from DTS?"
- Reply: Allan Mitchell: "Re: How to do this from DTS?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 6 May 2004 17:08:41 -0400
I have some sql code that I'm working on that I need to create a text file
as it's output. I'm creating a text file that's more or less just a flat
file, that has 01, 02 and 05 level records in it.
The 01 level is a header, with a dollar amount in a field on it. Haven't
figured out how to do this one yet.
The next records are a soldto and a shipto records. For each row on my
source table, I'll create 2 02 records, one with soldto info on it, one with
shipto info on it.
Next are the 05 records, with items on it. I can create 1+ of these.
The sql as it is now (in query analyzer) is a bunch of select & formatting
statements to get the info out on the record. I have a variable where I set
the time when it loads, in order to pass the same date & time stamp to each
of the records (because the 02's are created in a different place than the
05's, they could have a different timestamp). The variable is @curtime and
it's datetime and set to getdate(). I then format it as I need to.
The 05 records are built from a second table, where I do similar formatting
on the record, and then do an inner join on an orderid field that's in the
main table.
The fields are like this:
date, time, orderid, reclevel.... misc data....
So when if I need to sort it, the orderid would force the 01's, 02's and
05's for customer X together, as apposed to putting customer Y's data
intermingled with it (the orderno has a timestamp & other info in it).
Question is - since this is really 3+ queries, how can I do this in DTS? I
need to pass on the same date & time variable into each of the 3 selects,
but DTS will only process the first select statement.
Any help appreciated.
Thanks,
SC
- Next message: John Michl: "Customer Rank Query"
- Previous message: Gregory A. Larsen: "Re: Checking if a table exists, so that it may be dropped before recreating it"
- Next in thread: Allan Mitchell: "Re: How to do this from DTS?"
- Reply: Allan Mitchell: "Re: How to do this from DTS?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
