Viewing 15 posts - 3,196 through 3,210 (of 3,543 total)
If your importing you are checking DTSSource ;)]
Why not use ActiveX for the column in question, ie
Function Main()
If DTSSource("x") = True Then
DTSDestination("x") = null
eElseIf DTSSource("x")...
July 2, 2003 at 7:09 am
I'm using SQL7 SP4 and don't have any trouble defining or importing fixed length text files with or without trailing spaces in the first record. Are you sure your records...
July 2, 2003 at 6:57 am
Don't know why you get timeout either but I agree with planet115's answer. Another alternative is to bcp out, create new table and bcp back in. I have done copies...
July 2, 2003 at 6:27 am
What you are attempting to do is not possible or logical. To work, each address stored will have to have an adOwnerID & adOwnerTable matching in both crmTestORg and PersonDetails...
July 2, 2003 at 6:16 am
Don't have a fixed time anymore, tend to boot on fail.
FYI one server rebooted 5 days ago the other 10 days.
July 1, 2003 at 8:33 am
At the moment I only have one table with search facility. I tried a query with the table joined to itself (using id) and with multple CONTAINS statement. It worked...
July 1, 2003 at 7:19 am
Hi Greg,
Can't say that I can identify my problem with yours.
I have two Win2000 servers with SQL7 SP4 and different memory (512MB & 1GB). The following symtoms occur at random...
July 1, 2003 at 6:40 am
Len,
In addition I only did it this way due to the use of BETWEEN. I don't use BETWEEN personally, I always code the above as follows
July 1, 2003 at 2:31 am
Sorry ilan,
The line should be
WHERE (fld1 BETWEEN @fromdate AND @todate) AND (fld2 = 12)
Len,
Your right, good idea. Never too old to learn.
July 1, 2003 at 2:16 am
If the contents of the single field is unique (eg contains date and time) then I would use a third table to hold extracted data, parse from, and join to...
June 30, 2003 at 7:12 am
Personally I would do the following
declare @fromdate datetime
declare @todate datetime
set @fromdate = CAST(CONVERT(varchar(8),getdate(),120)+'01' AS datetime)
set @todate = DATEADD(second,-1,@fromdate)
set @fromdate = DATEADD(month,-1,@fromdate)
SELECT id, Fname, fld2, fld1
FROM...
June 30, 2003 at 6:51 am
The syntax of the CASE statement looks OK.
I would write the statement like this
CASE WHEN BIV < 100 THEN 'M' ELSE 'A' END AS BivType,
Pendantic I...
June 30, 2003 at 6:22 am
SQL7 SP4 xp_sendmail with Outlook 2000. Could not use cdosys and SMTP as the email has to be sent externally and our Exchange server does not act as a relay...
June 30, 2003 at 5:49 am
set @cmd = "SELECT @aom_rate = gccy.HCR_BMIDDLE, @aom_ccy_cts = gccy.HCR_CCY_CTS FROM [" + @current_user + "].[AO_InqCst_TEMPCCY] AS gccy WHERE gccy.HCR_CODE = '" + @aom_ccy +...
June 27, 2003 at 7:04 am
Viewing 15 posts - 3,196 through 3,210 (of 3,543 total)