Viewing 15 posts - 13,591 through 13,605 (of 13,876 total)
Using getdate() as an example date:
select cast(floor(cast(getdate() as float)) as datetime)
January 2, 2005 at 11:21 pm
Hmmm ... one way would be to create a calculated field on your table - call it 'concat', say, which is the concatenation of all twelve fields, replacing all nulls...
December 30, 2004 at 7:08 pm
Not that I know of. A UDF will do this fairly easily - something like this:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create function dbo.ascii_big (@string varchar(1000))
returns int
as
begin
declare @position int,...
December 30, 2004 at 2:42 pm
I cannot schedule anything more frequently than every minute - is that good enough?
December 30, 2004 at 2:15 pm
Conditioning the DELETE is possible, but I'm not sure what condition you want. Can you be a bit more specific? Also, when you say that it doesn't work...
December 30, 2004 at 2:09 pm
Hi Travis, this must be turning into a real pain in the you-know-what
Just had a quick read through your code and...
December 29, 2004 at 9:02 pm
If you perform a truncate on the temporary table every week before you perform the import (assuming that you do not wish to keep a history of what has been...
December 29, 2004 at 4:46 pm
One way of approaching this is to import the files into a new intermediate table (which has no constraints) and to use standard SQL on this table to perform validation...
December 29, 2004 at 5:41 am
As far as I can see, you have solved your own problem:
SELECT
d.company, d.address1, d.address2, d.city_id, d.state_id, d.country_id, d.zip, dr.directory_roletype_id, x.eng_itemdesc
FROM
T_MTSTM_DIRECTORY d INNER JOIN
T_MTSTM_DIRECTORY_ROLE dr ON...
December 23, 2004 at 4:20 pm
Never seen the error.
Maybe it's worth reinstalling the client tools on your PC and see whether that resolves it.
December 23, 2004 at 4:10 am
Does this happen for all databases, or just specific ones?
Do other users experience the same error?
Regards
Phil
December 23, 2004 at 3:42 am
Thanks Kemp ... yet another requirement that I didn't quite understand ![]()
Here's another version of your query that does not require wildcards:
SELECT * FROM...
December 23, 2004 at 12:09 am
Hi Jim
As far as I know, there is no 'date last updated' property for a database, so there is no straightforward solution to your question.
The following thread may be of...
December 22, 2004 at 6:27 pm
If you are inserting a date into a table, why are you not using a datetime field to store it?
If you want to select just the date part of getdate(),...
December 22, 2004 at 6:17 pm
Try this:
SELECT * FROM dbo.AGSVC_Idx_Res
WHERE neighborhood = 'MM_neighborhood' AND city = 'MM_city' AND PRICE BETWEEN 'MM_price_start' AND 'MM_price_finish' AND BEDROOMS >= 'MM_bed_start' AND (HIGH_SCHOOL LIKE 'MM_school' or...
December 22, 2004 at 6:08 pm
Viewing 15 posts - 13,591 through 13,605 (of 13,876 total)