If I understand you right, yes. My understanding of severity levels on errors isn't what it should be- I don't know if they error you are getting actually fails the batch/sp. Using string executes I would think it wouldn't matter though. Give it a shot unless someone more knowledgable gives a better solution.. fetch... begin […]
2003-11-21
1 reads
We buyed 'per seat' licenses, but this server was installed before that buy... Thanks four your help!
2003-08-25
1 reads
Sounds like the backup routine can't read pages form the DB. Like Allen said, I'd check your disks first. Run a consistency check or a CHKDSK. Also, run a DBCC CHECKDB to make sure you don't have any corruptions.
2003-08-06
Hi Martin, quote: I've been set the task of converting an app that uses DOS B-Tree style databases to SQL. One thing I'm finding is that the existing databases make heavy use of arrays. i.e. 12 individual records of a customers monthly spend are not stored in 12 seperate fields but are just blatted into […]
2003-07-29
1 reads
Stop. Desist. No! please, please don't. I've seen too many similar designs (including those by me) that have been created with the same good intentions. It just doesn't work well within a relational DBMS. Cheers, - Mark
2003-07-29
1 reads
Thanks for that. I was mulling over the idea of including a text field into the record that contains the data in a comma delimited format. My class can then stream the data in and out, and cope with variable lengths of arrays. I'm hoping (because I'm no expert), that this will have less of […]
2003-07-29
1 reads
Martin, There's no array type structure in SQL. It sort of violates relational concepts. If I were you I'd resign myself to to the slightly more difficult task of creating child tables for the repeating data. However, in the long run you'll find you'll be able to process that data (updating or querying) quite easily. […]
2003-07-29
2 reads
How about something like this as an example? declare @hival int select @hival = max(id) from mytable dbcc checkident(mytable, reseed, @hival) HTH, Steve Armistead, Database Administration Panther Systems Northwest, Inc. Vancouver, WA
2003-07-21
I realize that, as this uses a cursor, it's the ultimate evil; however: SELECT Timecard.EmpID, SUM(Timecard.WrkHrs) AS WrkHrs, WrkEmp.FName AS EmpFName, WrkEmp.LName AS EmpLName, MgrEmp.EmpID AS MgrID, MgrEmp.FName AS MgrFName, MgrEmp.LName AS MgrLName INTO #EmpHoursByProject FROM Timecard INNER JOIN Project ON Timecard.ProjNum = Project.ProjNum INNER JOIN Employees MgrEmp ON Project.mbillaty = MgrEmp.EmpID INNER JOIN Employees […]
2003-06-05
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
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