quote: You've probably got a record in table XXX with a value in the ATC_LVL_4_CD column that's not in the RDM_ATC_LVL_4_LKUP.ATC_LVL_4_CD column. use this query to find out if this is true: select xxx.* from xxx left outer join RDM_ATC_LVL_4_LKUP on xxx.ATC_LVL_4_CD = RDM_ATC_LVL_4_LKUP.ATC_LVL_4_CD where RDM_ATC_LVL_4_LKUP.ATC_LVL_4_CD is null This will identify any records in the […]
2003-06-24
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 you in the right direction. Basically these umbrella companies were setup because of new tax laws in the UK relating to one person becoming a […]
2003-06-19
I agree with eletuw, I discounted the option because as eletuw pointed out the user doesn't have Enterprise Edition.
2003-06-19
I've noticed this error, when trying to copy multiple objects at once. In most case, but not always, it works to copy object by object. Not satisfying, though BTW, SQL2k, SP3. Cheers, Frank
2003-06-17
It took some time to get an accurate results from the CASE test. It took twice as long with the CASE. Phil
2003-06-16
2003-06-13
1 reads
The ability to quote Monty Python, Douglas Adams, etc at a moment's notice. The ability to drink and still look as if you are solving a very difficult puzzle. The ability to curse a machine. More points if you use more than one language. The ability to have impromptu discussions on technical pieces at a […]
2003-06-11
I would consider maybe looking at converting the logic in the VB app to a stored procedure so that it runs inside SQL Server and can be a job. If you need help post the code here.
2003-06-05
1 reads
If you're a VB.NET programmer who wants to learn database programming with ADO.NET, here's a new book that presents all the skills you need in a logical progression from the simple to the complex. Along the way, you'll learn how to use the classes, properties, methods, events, and techniques that have made this subject so hard to master. And when you're done, you'll have a reference that you'll use on the job every day. (Publisher Provided Description, not reviewed)
2003-06-05
2,151 reads
After asking around I was told that you can't attach a DB to a file. Sorry about that 🙂 Did you get it right? Cheers, Crispin
2003-06-03
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers