Hi

Your problem is not the different database. The problem is the "GO". It finishes the complete batch and starts a new one. GO within scripts is equal to using two...

Nothing to apologize :-). I just intended to ensure that the OP...

I have no experiences with any object oriented database. Since now I was able to handle every thing in simple RDBs ;-).

As you wrote it sounds like a school project....

WILLIAM MITCHELL (6/7/2009)

---

If the dates are sequential you could use this

-- these would be your input parameters

DECLARE

@empno int,

@start_date datetime,

@end_date datetime,

@project nvarchar(50)

-- set them to some values for testing

SELECT

@empno = 1,

@start_date...

I suggest to use a GROUP BY instead of a sub-query in your SELECT clause. It performs better for many data:

SELECT

A.id,

...

I don't think this is possible with SQL. You can try to parse the RTF syntax and insert your data at the right position but I don't think SQL is...

You can use a Tally table for this:

DECLARE @t TABLE (EmpNo INT, FromDate DATETIME, ToDate DATETIME, Project VARCHAR(30))

INSERT INTO @t

SELECT 1, '2009-10-01', '2009-10-04', 'abc'

SELECT

...

Hi Lynn

Lynn Pettis (6/7/2009)

---

Obviously you have already decided that you must have an object oriented database. SQL Server, Oracle, Informix, PostgreSQL, MySQL, are relational database management systems. They...

For sure you can create a object oriented application with a relational database back end. I think this is the most common way to make larger software.

Very simplified look from...

Hi dave

This solution using PATINDEX should work.

; WITH

cte ([domain], [rid], [zone], [moddate], [type]) AS

(

SELECT

domain,

...

Okay, which criteria are assured?

* "01 ; Serial" after your date?

* " ; Serial" after your date?

* Line 3 for your date?

* Serial at the end of the...

Hi Tara

In SQL Server 2005 the most simple way to handle this would be EXCEPT:

DECLARE @a TABLE (Col1 VARCHAR(10), Col2 VARCHAR(10), Col3 VARCHAR(10))

DECLARE @b-2 TABLE (Col1 VARCHAR(10), Col2 VARCHAR(10), Col3...

Hi Clarie

"EXEC" does not support variables within your sql, you have to work with "sp_executesql". Change your SQL variables from VARCHAR(MAX) to NVARCHAR(MAX) (required for sp_executesql) and try this:

--Generate a...

Hi dave

If your zone text has always the same syntax you can use this.

I used the spaces in your Serial line to replace the date part and "mdocmx." + domain...

Hi

Just another possible solution

DECLARE @t TABLE (Attr INT, Lib VARCHAR(10))

INSERT INTO @t

SELECT 1, 'row01'

UNION...