Query Produces Jumbled output / output not in sequence

Glenn

Hi!

Server info -
Win2K3 Server +SP1 with 1 GB Memory and 1.5 GB Virtual Memory
SQL Server 2000 Enterprise Edition + SP3 running on this.

Required result -

Create a SQL Script that will contain a set of create, update, insert
& delete statements (about 17500 lines including blank lines) that
can be run on different databases seperately

How we do this -

We have a SP - that creates a temporary table and then calls another
SP that actually populates the temporary table created by the first SP

*Samples of both SPs are below -

PROBLEM

The result is directed to a file -
However when the query is run it runs through the entire script but
'Jumbles' the output
Running the same scripts on a copy of the database on other machines
work fine and the size of the outfiles is exactly the same

I have increased the page size to 2.5 GB and restarted the server.
Running the sp now generated the correct output a few times but got
jumbled as before after a few more users logged in and activity on the
server increased.
Another interesting point is that the output is jumbled exactly the
same way each time. It seems the sql executes correctly and writes
the output in chunks only writting the chunks out of sequence - but
in the same sequence each time.
e.g. of expected result

Insert into Table1
Values x, y, z, 1, 2

Insert into Table1
Values q, s, g, 3, 4

Insert into Table1
Values c, d, e, 21, 12
....

Insert into Table2
Values ...

Insert into Table3
Values ....

...
...
...
...

Update RefGen
Set Last = 1234
Where RefGenRef = 1

JUMBLED OUTPUT

Insert into Table1
Values x, y, z, 1, 2

Insert into Table1
Values q, s, g, 3, 4

Insert into Table1
Values c, d, e, 21, 12
....

Insert into Table2
Values ...
Insert into Table2
Values ...
Values ...

Update RefGen
Set Last = 1234
Where RefGenRef = 1
Insert into Table3
Values ....

...
...
...
...

Insert into Table1
Values c, d, e, 21, 12
....
Insert into Table2

----------------------------------------

Sample of First Script - STATDATA_RSLT
*************** *************** ********

SET QUOTED_IDENTIFI ER ON
GO
SET ANSI_NULLS ON
GO
SET NOCOUNT ON
GO

CREATE PROCEDURE StatData_rslt
AS

CREATE TABLE #tbl_Script(
ScriptText varchar(4000)
)

EXEC TestStatData_in t

SELECT t.ScriptText
FROM #tbl_Script t

GO
SET QUOTED_IDENTIFI ER OFF
GO
SET ANSI_NULLS ON
GO

*************** *************** *************

Sample of CALLED SP - TestStatData_in t
*************** *************** *************

SET QUOTED_IDENTIFI ER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE TestStatData_in t
AS

DECLARE @AttrRef int,
@TestID int,
@PrtTestRef int,
@AttrType tinyint,
@EdtblSw tinyint,
@NmValRef int,
@SrtTypeRef int,
@AttrStr varchar(20),
@TestStr varchar(20),
@PrtTestStr varchar(20),
@AttrTypeStr varchar(20),
@EdtblStr varchar(20),
@NmValStr varchar(20),
@SrtTypeStr varchar(20),
@TestRef int,
@Seq int,
@PrtRef int,
@Value varchar(255),
@TermDate datetime,
@AttrID int,
@DefSw tinyint,
@WantSw tinyint,
@TestRefStr varchar(20),
@SeqStr varchar(20),
@PrtStr varchar(20),
@TermDateStr varchar(255),
@AttrIDStr varchar(20),
@DefStr varchar(20),
@WantStr varchar(20),
@LanRef int,
@LanStr varchar(20),
@Code varchar(20),
@Desc varchar(255),
@MultiCode varchar(20),
@MultiDesc varchar(255),
@InhSw tinyint,
@InhStr varchar(20),
@InhFrom int,
@InhFromStr varchar(20),
@Lan_TestRef int,
@ActSw tinyint,
@ActSwStr varchar(20)

SELECT @Lan_TestRef = dbo.fn_GetTestR ef('Lan')

INSERT INTO #tbl_Script
VALUES('')

-- Create tables
INSERT INTO #tbl_Script
VALUES ('CREATE TABLE #tbl_Test (AttrRef int, TestID int , PrtTestRef
int, AttrType tinyint, EdtblSw tinyint, NmValRef int, SrtTypeRef
int)')

INSERT INTO #tbl_Script
VALUES ('')

INSERT INTO #tbl_Script
VALUES('CREATE TABLE #tbl_TestAttr(A ttrRef int, TestRef int, Seq int,
PrtRef int, AttrType tinyint, Value varchar(255), TermDate datetime,
AttrID int, DefSw tinyint, WantSw tinyint, ActSw tinyint)')

INSERT INTO #tbl_Script
VALUES ('')

INSERT INTO #tbl_Script
VALUES ('CREATE TABLE #tbl_AttrName(A ttrRef int, LanRef int, Code
varchar(20), [Desc] varchar(255), MultiCode varchar(20), MultiDesc
varchar(255), InhSw tinyint, InhFrom int)')

INSERT INTO #tbl_Script
VALUES ('')

-- insert Test values
DECLARE Test_cursor CURSOR FOR
SELECT l.AttrRef, l.TestID, l.PrtTestRef, l.AttrType, l.EdtblSw,
l.NmValRef, l.SrtTypeRef
FROM Test l

OPEN Test_cursor

FETCH NEXT FROM Test_cursor
INTO @AttrRef, @TestID, @PrtTestRef, @AttrType, @EdtblSw, @NmValRef,
@SrtTypeRef

WHILE @@FETCH_STATUS = 0
BEGIN

SELECT @AttrStr = ISNULL(CAST(@At trRef as varchar), 'NULL'),
@TestStr = ISNULL(CAST(@Te stID as varchar), 'NULL'),
@PrtTestStr = ISNULL(CAST(@Pr tTestRef as varchar), 'NULL'),
@AttrTypeStr = ISNULL(CAST(@At trType as varchar), 'NULL'),
@EdtblStr = ISNULL(CAST(@Ed tblSw as varchar), 'NULL'),
@NmValStr = ISNULL(CAST(@Nm ValRef as varchar), 'NULL'),
@SrtTypeStr = ISNULL(CAST(@Sr tTypeRef as varchar), 'NULL')

INSERT INTO #tbl_Script
VALUES ('INSERT INTO #tbl_Test(AttrR ef, TestID, PrtTestRef,
AttrType,
EdtblSw, NmValRef, SrtTypeRef)')

INSERT INTO #tbl_Script
VALUES ('VALUES ( ' + @AttrStr + ', ' + @TestStr + ', ' +
@PrtTestStr
+ ', ' + @AttrTypeStr + ', ' + @EdtblStr + ', ' + @NmValStr + ', ' +
@SrtTypeStr + ')')

INSERT INTO #tbl_Script
VALUES ('')

FETCH NEXT FROM Test_cursor
INTO @AttrRef, @TestID, @PrtTestRef, @AttrType, @EdtblSw, @NmValRef,
@SrtTypeRef

END

CLOSE Test_cursor
DEALLOCATE Test_cursor

DECLARE TestAttr_cursor CURSOR FOR
SELECT le.AttrRef, le.TestRef, le.Seq, le.PrtRef, le.AttrType,
le.Value,
le.TermDate, le.AttrID, le.DefSw, le.WantSw, le.ActSw
FROM TestAttr le
WHERE le.WantSw = 1
AND le.ActSw = 1

OPEN TestAttr_cursor

FETCH NEXT FROM TestAttr_cursor
INTO @AttrRef, @TestRef, @Seq, @PrtRef, @AttrType, @Value,
@TermDate, @AttrID, @DefSw, @WantSw, @ActSw

WHILE @@FETCH_STATUS = 0
BEGIN

SELECT @AttrStr = ISNULL(CAST(@At trRef as varchar), 'NULL'),
@TestRefStr = ISNULL(CAST(@Te stRef as varchar), 'NULL'),
@SeqStr = ISNULL(CAST(@Se q as varchar), 'NULL'),
@PrtStr = ISNULL(CAST(@Pr tRef as varchar), 'NULL'),
@AttrTypeStr = ISNULL(CAST(@At trType as varchar), 'NULL'),
@Value = ISNULL(@Value, 'NULL'),
@TermDateStr = ISNULL(CAST(@Te rmDate as varchar), 'NULL'),
@AttrIDStr = ISNULL(CAST(@At trID as varchar), 'NULL'),
@DefStr = ISNULL(CAST(@De fSw as varchar), 'NULL'),
@WantStr = ISNULL(CAST(@Wa ntSw as varchar), 'NULL'),
@ActSwStr = ISNULL(CAST(@Ac tSw as varchar), '1')

SELECT @Value = '''' + @Value + ''''
WHERE @Value <> 'NULL'

INSERT INTO #tbl_Script
VALUES ('INSERT INTO #tbl_TestAttr(A ttrRef, TestRef, Seq, PrtRef,
AttrType, Value, TermDate, AttrID, DefSw, WantSw, ActSw)')

INSERT INTO #tbl_Script
VALUES ('VALUES (' + @AttrStr + ', ' + @TestRefStr + ', ' +
@SeqStr
+ ', ' + @PrtStr + ', ' + @AttrTypeStr + ', ' + @Value + ', ' +
@TermDateStr + ', ' + @AttrIDStr + ', ' + @DefStr + ', ' + @WantStr
+
', '+ @ActSwStr + ')')

INSERT INTO #tbl_Script
VALUES ('')

FETCH NEXT FROM TestAttr_cursor
INTO @AttrRef, @TestRef, @Seq, @PrtRef, @AttrType, @Value,
@TermDate, @AttrID, @DefSw, @WantSw, @ActSw

END

CLOSE TestAttr_cursor
DEALLOCATE TestAttr_cursor

DECLARE AttrName_cursor CURSOR FOR
SELECT e.AttrRef, e.LanRef, e.Code, e.[Desc], e.MultiCode,
e.MultiDesc, e.InhSw, e.InhFrom
FROM AttrName e, TestAttr le
WHERE e.LanRef = 0
AND e.AttrRef = le.AttrRef
AND le.WantSw = 1
AND le.ActSw = 1

OPEN AttrName_cursor

FETCH NEXT FROM AttrName_cursor
INTO @AttrRef, @LanRef, @Code, @Desc, @MultiCode,
@MultiDesc, @InhSw, @InhFrom

WHILE @@FETCH_STATUS = 0
BEGIN

SELECT @AttrStr = ISNULL(CAST(@At trRef as varchar), 'NULL'),
@LanStr = ISNULL(CAST(@La nRef as varchar), 'NULL'),
@Code = ISNULL(@Code, 'NULL'),
@Desc = ISNULL(@Desc, 'NULL'),
@MultiCode = ISNULL(@MultiCo de, 'NULL'),
@MultiDesc = ISNULL(@MultiDe sc, 'NULL'),
@InhStr = ISNULL(CAST(@In hSw as varchar), 'NULL'),
@InhFromStr = ISNULL(CAST(@In hFrom as varchar), 'NULL')

SELECT @Code = REPLACE(@Code, '''',''''''),
@Desc = REPLACE(@Desc, '''','''''') ,
@MultiCode = REPLACE(@MultiC ode, '''','''''') ,
@MultiDesc = REPLACE(@MultiD esc, '''','''''')

INSERT INTO #tbl_Script
VALUES ('INSERT INTO #tbl_AttrName(A ttrRef, LanRef, Code, [Desc],
MultiCode, MultiDesc, InhSw, InhFrom)')

INSERT INTO #tbl_Script
VALUES ('VALUES (' + @AttrStr + ', ' + @LanStr + ', ''' + @Code +
''', ''' + @Desc + ''', ''' + @MultiCode + ''', ''' + @MultiDesc +
''',
' + @InhStr + ', ' + @InhFromStr + ')')

INSERT INTO #tbl_Script
VALUES ('')

FETCH NEXT FROM AttrName_cursor
INTO @AttrRef, @LanRef, @Code, @Desc, @MultiCode,
@MultiDesc, @InhSw, @InhFrom
END

CLOSE AttrName_cursor
DEALLOCATE AttrName_cursor

-- Do update TestAttr data

INSERT INTO #tbl_Script
VALUES ('UPDATE le')

INSERT INTO #tbl_Script
VALUES ('SET')

INSERT INTO #tbl_Script
VALUES (' le.TestRef = t.TestRef,')

INSERT INTO #tbl_Script
VALUES (' le.PrtRef = t.PrtRef,')

INSERT INTO #tbl_Script
VALUES (' le.AttrType = t.AttrType,')

INSERT INTO #tbl_Script
VALUES (' le.Value = t.Value,')

INSERT INTO #tbl_Script
VALUES (' le.TermDate = t.TermDate,')

INSERT INTO #tbl_Script
VALUES (' le.AttrID = t.AttrID,')

INSERT INTO #tbl_Script
VALUES (' le.DefSw = t.DefSw,')

INSERT INTO #tbl_Script
VALUES (' le.WantSw = t.WantSw,')

INSERT INTO #tbl_Script
VALUES (' le.ActSw = t.ActSw')

INSERT INTO #tbl_Script
VALUES ('FROM TestAttr le, #tbl_TestAttr t')

INSERT INTO #tbl_Script
VALUES ('WHERE le.AttrRef = t.AttrRef')

INSERT INTO #tbl_Script
VALUES ('')

-- Update AttrName

INSERT INTO #tbl_Script
VALUES ('UPDATE en')

INSERT INTO #tbl_Script
VALUES ('SET')

INSERT INTO #tbl_Script
VALUES (' en.Code = te.Code,')

INSERT INTO #tbl_Script
VALUES (' en.[Desc] = te.[Desc],')

INSERT INTO #tbl_Script
VALUES (' en.MultiCode = te.MultiCode,')

INSERT INTO #tbl_Script
VALUES (' en.MultiDesc = te.MultiDesc,')

INSERT INTO #tbl_Script
VALUES (' en.InhSw = te.InhSw,')

INSERT INTO #tbl_Script
VALUES (' en.InhFrom = te.InhFrom')

INSERT INTO #tbl_Script
VALUES ('FROM AttrName en, #tbl_AttrName te')

INSERT INTO #tbl_Script
VALUES ('WHERE en.AttrRef = te.AttrRef')

INSERT INTO #tbl_Script
VALUES (' AND en.LanRef = te.LanRef')

INSERT INTO #tbl_Script
VALUES (' AND te.LanRef = 0')

-- Do update Test the data

INSERT INTO #tbl_Script
VALUES ('UPDATE l')

INSERT INTO #tbl_Script
VALUES ('SET')

INSERT INTO #tbl_Script
VALUES (' l.TestID = t.TestID,')

INSERT INTO #tbl_Script
VALUES (' l.PrtTestRef = t.PrtTestRef,')

INSERT INTO #tbl_Script
VALUES (' l.AttrType = t.AttrType,')

INSERT INTO #tbl_Script
VALUES (' l.EdtblSw = t.EdtblSw,')

INSERT INTO #tbl_Script
VALUES (' l.NmValRef = t.NmValRef')

INSERT INTO #tbl_Script
VALUES ('FROM Test l, #tbl_Test t')

INSERT INTO #tbl_Script
VALUES ('WHERE l.AttrRef = t.AttrRef')

INSERT INTO #tbl_Script
VALUES ('')

--DELETE where just updated

INSERT INTO #tbl_Script
VALUES ('DELETE FROM t')

INSERT INTO #tbl_Script
VALUES ('FROM #tbl_Test t, Test l')

INSERT INTO #tbl_Script
VALUES ('WHERE t.AttrRef = l.AttrRef')

INSERT INTO #tbl_Script
VALUES ('')

INSERT INTO #tbl_Script
VALUES ('DELETE FROM t')

INSERT INTO #tbl_Script
VALUES ('FROM #tbl_TestAttr t, TestAttr le')

INSERT INTO #tbl_Script
VALUES ('WHERE t.AttrRef = le.AttrRef')

INSERT INTO #tbl_Script
VALUES ('')

INSERT INTO #tbl_Script
VALUES ('DELETE FROM te')

INSERT INTO #tbl_Script
VALUES ('FROM #tbl_AttrName te, TestAttr le')

INSERT INTO #tbl_Script
VALUES ('WHERE te.AttrRef = le.AttrRef')

INSERT INTO #tbl_Script
VALUES ('')

-- Insert TestAttr

INSERT INTO #tbl_Script
VALUES ('INSERT INTO TestAttr (AttrRef, TestRef, Seq, PrtRef,
AttrType,
Value, TermDate, AttrID, DefSw, WantSw, ActSw)')

INSERT INTO #tbl_Script
VALUES ('SELECT t.AttrRef, t.TestRef, t.Seq, t.PrtRef, t.AttrType,
t.Value, t.TermDate, t.AttrID, t.DefSw, t.WantSw, t.ActSw')

INSERT INTO #tbl_Script
VALUES ('FROM #tbl_TestAttr t')

INSERT INTO #tbl_Script
VALUES ('')

-- AttrName

INSERT INTO #tbl_Script
VALUES ('INSERT INTO AttrName(AttrRe f, LanRef, Code, [Desc],
MultiCode,
MultiDesc, InhSw, InhFrom)')

INSERT INTO #tbl_Script
VALUES ('SELECT te.AttrRef, le.AttrRef, te.Code, te.[Desc],
te.MultiCode, te.MultiDesc, ')

INSERT INTO #tbl_Script
VALUES (' CASE le.AttrRef ')

INSERT INTO #tbl_Script
VALUES (' WHEN 0 THEN 0')

INSERT INTO #tbl_Script
VALUES (' ELSE 1 END,')

INSERT INTO #tbl_Script
VALUES (' CASE le.AttrRef ')

INSERT INTO #tbl_Script
VALUES (' WHEN 0 THEN NULL')

INSERT INTO #tbl_Script
VALUES (' ELSE 0 END')

INSERT INTO #tbl_Script
VALUES ('FROM #tbl_AttrName te, TestAttr le')

INSERT INTO #tbl_Script
VALUES ('WHERE le.TestRef = ' + CAST(@Lan_TestR ef as varchar))

INSERT INTO #tbl_Script
VALUES ('')

-- Insert new rows

INSERT INTO #tbl_Script
VALUES ('INSERT INTO Test(AttrRef, TestID, PrtTestRef, AttrType,
EdtblSw, NmValRef, SrtTypeRef)')

INSERT INTO #tbl_Script
VALUES ('SELECT t.AttrRef, t.TestID, t.PrtTestRef, t.AttrType,
t.EdtblSw, t.NmValRef, t.SrtTypeRef')

INSERT INTO #tbl_Script
VALUES ('FROM #tbl_Test t')

INSERT INTO #tbl_Script
VALUES ('')

INSERT INTO #tbl_Script
VALUES ('DROP TABLE #tbl_Test')

INSERT INTO #tbl_Script
VALUES ('DROP TABLE #tbl_TestAttr')

INSERT INTO #tbl_Script
VALUES ('DROP TABLE #tbl_AttrName')

-- Update RefGen

DECLARE @RefGenReflast int,
@RefGenRefStr varchar(10)

SELECT @RefGenReflast = last
FROM RefGen
WHERE RefGenRef = 1

SELECT @RefGenRefStr = ISNULL(CAST(@Re fGenReflast as varchar), 'NULL')

INSERT INTO #tbl_Script
VALUES('')

INSERT INTO #tbl_Script
VALUES('UPDATE RefGen')

INSERT INTO #tbl_Script
VALUES ('SET Last = ' + @RefGenRefStr)

INSERT INTO #tbl_Script
VALUES ('WHERE RefGenRef = 1')

INSERT INTO #tbl_Script
VALUES ('')

GO
SET QUOTED_IDENTIFI ER OFF
GO
SET ANSI_NULLS ON
GO

*************** *************** *
Regards

Glenn

Jul 23 '05 #1

Subscribe Reply

2341

David Portas

Since you haven't specified ORDER BY anywhere the ordering is undefined and
will be determined by the server at execution. You need to specify ORDER BY
whenever you want to return data in sequence. A table doesn't preserve any
inherent order and cursors are also unordered unless the cursor declaration
specifies ORDER BY.

For scripting INSERTS, have you seen:
http://vyaskn.tripod.com/code.htm#inserts

--
David Portas
SQL Server MVP
--

Jul 23 '05 #2

Glenn

Hi David,

Thanks for your reply. However, I seem to have been unclear with my
problem . Unfortunately, the order by is not the problem here as
I am generating a set of sql statments using the multiple cursors.

Each cursor generating a set of insert statements from one table at a
time. So I expect an output such as

INSERT INTO tbl_1(Ref, LID)
VALUES ( 1, 1)

INSERT INTO tbl_1(Ref, LID)
VALUES ( 2, 2)

INSERT INTO tbl_1(Ref, LID)
VALUES ( 3, 3)
......

INSERT INTO tbl_11(Ref, ERef, Seq)
VALUES (0, 2, 1)

INSERT INTO tbl_11(Ref, ERef, Seq)
VALUES (1, 1, 1)

INSERT INTO tbl_11(Ref, ERef, Seq)
VALUES (2, 1, 50)
.........

INSERT INTO tbl_22(Ref, LRef, Code, [Description])
VALUES (0, 0, 'Default', 'Default')

INSERT INTO tbl_22(Ref, LRef, Code, [Description])
VALUES (1, 0, 'Code', 'Codes')

INSERT INTO tbl_22(Ref, LRef, Code, [Description])
VALUES (2, 0, 'Lang', 'Language')
..........

However, I do not expect a result such as :

INSERT INTO tbl_1(Ref, LID)
VALUES ( 1, 1)

INSERT INTO tbl_1(Ref, LID)
VALUES ( 2, 2)
VALUES (1, 0, 'Code', 'Codes')

INSERT INTO tbl_22(Ref, LRef, Code, [Description])
VALUES (2, 0, 'Lang', 'Language')

INSERT INTO tbl_1(Ref, LID)
VALUES ( 3, 3)
......

INSERT INTO tbl_11(Ref, ERef, Seq)
VALUES (0, 2, 1)

INSERT INTO tbl_11(Ref, ERef, Seq)
VALUES (1, 1, 1)

.........

INSERT INTO tbl_22(Ref, LRef, Code, [Description])
VALUES (0, 0, 'Default', 'Default')

INSERT INTO tbl_22(Ref, LRef, Code, [Description])
INSERT INTO tbl_11(Ref, ERef, Seq)
VALUES (2, 1, 50)
..........

Also, when I reboot the server and start afresh, I get the expected
output, but as a few more users connect to the server something seems
to cause the problem ..

Regards

Glenn

Jul 23 '05 #3

David Portas

Re-read what I said before. Now look at your code:

<snip>

INSERT INTO #tbl_Script
VALUES ('INSERT INTO #tbl_TestAttr(A ttrRef, TestRef, Seq, PrtRef,
AttrType, Value, TermDate, AttrID, DefSw, WantSw, ActSw)')

INSERT INTO #tbl_Script
VALUES ('VALUES (' + @AttrStr + ', ' + @TestRefStr + ', ' +
@SeqStr
+ ', ' + @PrtStr + ', ' + @AttrTypeStr + ', ' + @Value + ', ' +
@TermDateStr + ', ' + @AttrIDStr + ', ' + @DefStr + ', ' + @WantStr
+
', '+ @ActSwStr + ')')

</snip>

The "INSERT" and "VALUES" parts are in separate rows, but when you query the
table:

SELECT t.ScriptText
FROM #tbl_Script t

You have no ORDER BY clause! So you can't expect to see the result in the
same order you inserted the data.

--
David Portas
SQL Server MVP
--

Jul 23 '05 #4

Glenn

Hi David,

Thanks for the message. Have now understood what you are saying. Will
investigate this and find a way to fix this.

Cheers

Glenn

Jul 23 '05 #5

Glenn

Hi David,

Thanks for the advice. I now get results as expected, after I made
the changes described below.

I modified my SP and added an Identity column to the #tbl_script &
added the ORDER BY to the select.

CREATE PROCEDURE StatData_rslt
AS

CREATE TABLE #tbl_Script(
ScriptLine int IDENTITY (1, 1) NOT NULL ,
ScriptText varchar(4000)
)

EXEC TestStatData_in t

SELECT t.ScriptText
FROM #tbl_Script t
ORDER BY t.ScriptLine
Thanks once again.
Regards

Glenn

Jul 23 '05 #6

Similar topics

2735

Strange inconsistences when repeating a query more than twice in a row

by: Wescotte | last post by:

Here is a small sample program I wrote in PHP (running off Apache 1.3.31 w/ PHP 5.0.1) to help illustrates problem I'm having. The data base is using DB2 V5R3M0. The client is WinXP machine using the iSeries Client Access Driver ver 10.00.04.00 to connect to the database. The problem is that executing the exact same SQL select statement more than twice int a row stops produces results. The first two instances will always produce the...

PHP

1807

ds.writexmlschema produces file with xs: tags

by: MSSQLServerDeveloper | last post by:

I have a simple vb.net program that creates an xmlschema using the dataset method writexmlschema (see #1). It creates a file (see #2), but I would like a file that looks like #3 - #3 is DIFFERENT from #2 inthat it has a sql:relation, where #2 does not. Why is my code producing this when others produce #3? ==================== #1 - My Code ==================== Dim ds As New DataSet()

.NET Framework

3118

Control Center - current query opt error

by: Sean C. | last post by:

Helpful folks, I have recently migrated our test server, which runs Win NT 4, from V7.2 FP11 to V8.1.3. Just about everything works wondefully, except I am having major problems getting the previously defined federated servers/nicknames to work. But I will start a different thread about that problem. I thought I'd ask about the less critical problem first. It deals with the Control Center and the following error: SQL0713N The...

DB2 Database

2858

Access 2003: Request help on pivot table query

by: Alan Lane | last post by:

Hello world: I'm including both code and examples of query output. I appologize if that makes this message longer than it should be. Anyway, I need to change the query below into a pivot table query. I'm having trouble doing it. Help! Here is my code so far: Sub OldRegionQuery()

Microsoft Access / VBA

1953

Counting total records in select query

by: geronimo_me | last post by:

Hi, I have a query that has the following fields: Business: ID Number: LastName: EmpNo: Hours1: Hours2:

Microsoft Access / VBA

23712

query string encoding/decoding

by: Mark | last post by:

I've run a few simple tests looking at how query string encoding/decoding gets handled in asp.net, and it seems like the situation is even messier than it was in asp... Can't say I think much of the "improvements", but maybe someone here can point me in the right direction... First, it looks like asp.net will automatically read and recognize query strings encoded in utf8 and 16-bit unicode, only the latter is some mutant, non-standard...

ASP.NET

3022

Query Limit in Access

by: rachelannie | last post by:

Hi, I was wondering if anyone out there could help me. I've developed a database in Access which pretty much consists of a bunch of queries which churns data from linked tables and then produces a bunch of output tables whcih I then use to base my forms on...which in turn are used to generate a report (subforms etc)! I know there is a limit or a point you can hit in MS Access where if wont run any more queries but I thought I got rid of that...

Microsoft Access / VBA

2218

Query to reduce a 1-to-n relationship to 1-to-1

by: bugs2bugs | last post by:

My problem is as follows: I have a customer table and an address table. A customer can have 0, 1 or many addresses. The query result I'm trying to get produces 1 and only 1 row for each customer, with either 1 address or null's for the appropriate address fields. Here's some simple sql to demonstrate: create table test_customer (custid char(10), custname char(20)) create table test_address (custid char(10), addrid char(10), city char(20)) ...

Microsoft SQL Server

1490

Finding sequences in a query‏

by: Bartus | last post by:

I'm am making a small programm for seat reservations. But I have a problem to find the sequence in the available seats. I will explain it with the following sample: Row / Seat / Total Seats In Sequence / Sequence number / Available 1 / 1 / 3 / 1 / 3 1 / 2 / 3 / 2 / 2 1 / 3 / 3 / 3 / 1 1 / 6 / ...

Microsoft Access / VBA

9645

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9481

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10341

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10155

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7502

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6741

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5383

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3656

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2881

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General