Viewing 15 posts - 61 through 75 (of 89 total)
This looks a little messy and can probably be tidied up alot but it will hopefully get you started.
declare @start datetime, @end datetime
declare @i...
July 23, 2003 at 3:11 am
We were experiencing a very similar problem not so long ago, it was very intermittent but would generate hundreds to thousands of errors in a very short space of time....
July 22, 2003 at 9:49 am
I take it you mean in the USA ? I can't tell you that because i'm in the UK, but i'd imagine it will also depend on your location,...
July 22, 2003 at 3:05 am
I'm running Standard Edition on a Win 2003 server and all appears ok. Didn't experience any problems in the setup. I also feel there has been a performance...
July 22, 2003 at 3:02 am
We run SQL Server, Oracle, DB2 and MySQL....not too much of a headache! I believe DB2 is being phased out though.
July 21, 2003 at 3:24 am
Just try
Delete From QSpace.dbo.Prod_XRef Where SSN = @SSN
a) i believe you need the From clause and b) if the SSN Column in your table is defined as Char(9) you...
July 17, 2003 at 2:19 am
It should mean AND. I've been trying this and it appears to work ok. Just try it on a test table first.
July 9, 2003 at 3:47 am
Something like this might work.
Insert Into TableA
Select TableB.Col1, TableB.Col2
From TableB
Where TableB.Col1 Not In
(Select TableA.Col1 From TableA)
HTH.
July 9, 2003 at 3:40 am
try www.intelliview.com, also ActiveReports at http://www.datadynamics.com/arnet/default.htm, which is very good, and from what i recall pretty cheap as well.
July 7, 2003 at 4:02 am
Inteliview is pretty good. Not quite as many features but then it doesn't cost quite as much as CR!
July 7, 2003 at 2:39 am
I'd agree, you're probably going to have to use VBA behind the scenes in Excel to go off and do any Updates or Inserts.
July 4, 2003 at 1:39 am
Quote: if you have a developer that screws up production data more that a couple of times because they're cutting corners or something, lock that person out...
Why risk the chance...
June 26, 2003 at 8:23 am
Steve.
IR35 did close the loop hole for one man limited companies. But going through a company such as this you can still be paid a low salary but then get...
June 19, 2003 at 6:21 am
hanslindgren:
It is good i agree. I can give you the link for the company i use, i don't know if they operate outside the UK but it might point...
June 19, 2003 at 6:00 am
Well in the UK there are two ways of doing it. Either you set up a limited company, and pay accountants etc do all the paperwork for you, or...
June 19, 2003 at 5:45 am
Viewing 15 posts - 61 through 75 (of 89 total)