Very good explanations. I would compare as follows

where convert(char(10),hire_date,120) between '2002-12-01' and '2003-12-31'

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...

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...

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...

Isn't this a duplicate of

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=9068&FORUM_ID=8&CAT_ID=1&Topic_Title=query+help&Forum_Title=T%2DSQL

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...

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

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...

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...

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...

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...

How about

replace(rtrim(replace(column,'0',' ')),' ','0')

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....

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...

SQL7 BOL states that variables are not allowed for search conditions. If you have a lot of these then I suggest you build a sql string and use executesql. Try

declare...