Viewing 15 posts - 511 through 525 (of 541 total)
OK, if this data is REALLY completely duplicated, then the articles will help you get rid of them. And like geomon said, make sure this doesn't happen in the...
July 24, 2003 at 11:16 pm
AS400 --> SQL? That's great, I should set that up here. Do you have any links that could help me out?
(sorry to answer a question with a question...
July 23, 2003 at 12:13 pm
try this...DTS gets funny with return codes and setting output variables.
DECLARE @rc int
DECLARE @partition varchar(10)
DECLARE @nextid int
DECLARE @id int
set nocount on
-- Set parameter values
EXEC @rc =...
July 23, 2003 at 11:58 am
selecting a range of bits? Wow, great stuff.
snootchie bootchies
July 23, 2003 at 11:56 am
Very cool; I'll try it out later today and let you know how it works for me.
July 23, 2003 at 11:49 am
achowe, Why won't Npeeters query work for you? That's a nice little piece of code, deletes all records except the one with the maximum date value.
DELETE t1
FROM...
July 18, 2003 at 12:47 pm
Try a more modern syntax:
select t1.Varchar1, t2.Varchar2
from table1 t1
JOIN database2.dbo.table2 t2 on t1.Varchar1=t2.Varchar2
July 18, 2003 at 12:25 pm
It's woefully complex, but here's the easiest way I could get a time out of SQL in the format '06:00:00 PM'.
select
Case
When cast(cast(convert(varchar, getdate(), 108) as char(2)) as int)...
July 18, 2003 at 12:23 pm
Well, the software we're using (eCRM) was developed to run against either an oracle or tSQL db, so I guess they figured using queries that requested unicode values would be...
July 11, 2003 at 11:55 am
How are you going to "take it from here"? I have the same problem with our software and it's KILLING the performance on the search. I can't modify...
July 10, 2003 at 7:07 pm
Good call, la4rha. In the past I've had the same problem in the DTS Execute SQL task that returns a dataset...."invalid pointer error" was the error. This was a...
July 9, 2003 at 1:19 pm
This is a really interesting question!
Here's how to do it without the cursor, but it still uses 1 temp table (will need 2 if Table 2 doesn't have an identity...
July 8, 2003 at 3:50 pm
Quote:
Calvin, You might want to check why you are submitting duplicate responses. This happened in another topic as well.
Yeah, sorry about that...our ISP's been ridiculously slow today and I clicked...
July 8, 2003 at 3:14 pm
I think cheongww actually means he wants all records from the 2nd query regardless of whether they fit the criteria of the 1st (has a matching record in all tables).
If...
July 8, 2003 at 1:35 pm
I think cheongww actually means he wants all records from the 2nd query regardless of whether they fit the criteria of the 1st (has a matching record in all tables).
If...
July 8, 2003 at 1:35 pm
Viewing 15 posts - 511 through 525 (of 541 total)