Database

Rob Philpott wrote:

Does this mean I have to use some iterative approach to do this?

declare @counter int
set @counter = 1
while (@counter <= 3)
begin
   update #temp 
   set myXml.modify('replace value of (/document/value[sql:variable("@counter")]/text())[1] with "somevalue"')  
   set @counter = @counter + 1
end

urbane.tiger wrote:

However SQLite looks good, I like the idea of a using library rather than a separate process

urbane.tiger wrote:

Wonder if anyone's used in a Mono/C# app

Mika Wendelius wrote:

If you don't need a "byrocratic" installation, SQLite is most propably a good choice

CREATE PROC AllocateInstructor
 @numStudents INT,
 @InstructorId INT
AS
INSERT INTO Allocation (InstructorId, StudentId)
SELECT TOP @numStudents
   @instructorId,
   studentId
FROM Students
WHERE studentId NOT IN(SELECT studentId FROM Allocation)

SELECT Firms.dbo.FirmNames.id, Firms.dbo.FirmNames.FirmName
FROM Firms.dbo.FirmNames 
WHERE Firms.dbo.FirmNames.id NOT IN
   (SELECT FirmsInFamily.FirmID 
   FROM   FirmsInFamily 
   INNER JOIN Families      
   ON FirmsInFamily.FamilyID = Families.FamilyID
   WHERE Families.FamilyID = @FamilyID)

Sunset Towers wrote:

I really need to take an indepth class on it.