Viewing 15 posts - 3,466 through 3,480 (of 3,544 total)
In QA goto Query/Current Connection Options Advanced Tab and change 'Maximum characters per column' the default is 256.
Far away is close at hand in the images of elsewhere.
Anon.
January 9, 2003 at 11:11 am
Very good explanations. I would compare as follows
where convert(char(10),hire_date,120) between '2002-12-01' and '2003-12-31'
Far away is close at hand in the images of elsewhere.
Anon.
January 9, 2003 at 5:09 am
Since my last reply, I have updated my SQL7 to SP4 and MDAC 2.7 RTM (2.70.9001.0) (5 Jan 03). Only got this error once due to me force closing sql...
Far away is close at hand in the images of elsewhere.
Anon.
January 9, 2003 at 4:59 am
Most of the time I have dates with no times so the problem is minimal. However on the odd occasion where I have times as well I have used both...
Far away is close at hand in the images of elsewhere.
Anon.
January 9, 2003 at 4:47 am
If both tables are already populated with the data then
update b
set b.AMT = (CASE
WHEN b.QTR = 'Q1' THEN a.Q1
WHEN b.QTR = 'Q2' THEN a.Q2
WHEN b.QTR = 'Q3' THEN a.Q3
WHEN...
Far away is close at hand in the images of elsewhere.
Anon.
January 9, 2003 at 4:27 am
Isn't this a duplicate of
Far away is close at hand in the images of elsewhere.
Anon.
January 6, 2003 at 11:03 am
If I remember right level 16 errors stop further processing of the proc and therefore I don't think you can replace the message.
In my procs I check for duplicates (SELECT...
Far away is close at hand in the images of elsewhere.
Anon.
January 6, 2003 at 10:53 am
select a.product_Code,a.Order_Num,a.Begin_date,b.End_Date
from a
inner join b on b.product_Code = a.product_Code
and b.Order_Num = a.Order_Num
and b.Begin_date = a.End_Date
Edited by - davidburrows on 01/03/2003 03:38:12 AM
Far away is close at hand in the images of elsewhere.
Anon.
January 3, 2003 at 3:37 am
I have used Crystal Reports via VB to do reporting and once u get used to interface found it easy (just boring having to create and postion fields). Also have...
Far away is close at hand in the images of elsewhere.
Anon.
January 3, 2003 at 3:24 am
More info. One of my DTS today got 'Unspecified error' and was due to the file missing and then the file was in use (being created). Once the file had...
Far away is close at hand in the images of elsewhere.
Anon.
January 3, 2003 at 3:05 am
I agree with Scorpion's 1st para, that is what I use this forum for. By supplying sql snippets you get other peoples ideas and can write better sql.
As for your...
Far away is close at hand in the images of elsewhere.
Anon.
January 3, 2003 at 2:31 am
create table #mth (year int,month int)
declare @d datetime
set @d = getdate()
insert into #mth values(year(@d),month(@d))
set @d = dateadd(m,-1,@d)
insert into #mth values(year(@d),month(@d))
set @d = dateadd(m,-1,@d)
insert into #mth values(year(@d),month(@d))
set @d = dateadd(m,-1,@d)
insert into...
Far away is close at hand in the images of elsewhere.
Anon.
January 2, 2003 at 11:09 am
How about
replace(rtrim(replace(column,'0',' ')),' ','0')
Far away is close at hand in the images of elsewhere.
Anon.
January 2, 2003 at 6:29 am
I use SQL7 and found this sometimes as I import data from 3rd party DB via ODBC and normally I find it's due to data conversion, e.g. date overflow etc....
Far away is close at hand in the images of elsewhere.
Anon.
January 2, 2003 at 3:52 am
Sorry but we do not have subscription systems so I cannot really help there. Whether you keep table3 separate is a matter of choice I suppose (I have a database...
Far away is close at hand in the images of elsewhere.
Anon.
December 18, 2002 at 2:32 am
Viewing 15 posts - 3,466 through 3,480 (of 3,544 total)