Viewing 15 posts - 61 through 75 (of 90 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...
Growing old is mandatory, growing up is optional
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....
Growing old is mandatory, growing up is optional
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,...
Growing old is mandatory, growing up is optional
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...
Growing old is mandatory, growing up is optional
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.
Growing old is mandatory, growing up is optional
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...
Growing old is mandatory, growing up is optional
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.
Growing old is mandatory, growing up is optional
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.
Growing old is mandatory, growing up is optional
July 9, 2003 at 3:40 am
try http://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.
Growing old is mandatory, growing up is optional
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!
Growing old is mandatory, growing up is optional
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.
Growing old is mandatory, growing up is optional
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...
Growing old is mandatory, growing up is optional
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...
Growing old is mandatory, growing up is optional
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...
Growing old is mandatory, growing up is optional
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...
Growing old is mandatory, growing up is optional
June 19, 2003 at 5:45 am
Viewing 15 posts - 61 through 75 (of 90 total)