SQL Server union all

I have a DW that was converted from PB 6.5 to PB 12 classic
using MSSQL Server 2008 running Win XP SP 3.  Prior to
conventions I have a dw report that runs a union-ed SQL
without any issue.  After conversion, I started having
report that still report information but it's the same
format as before.  What it does is that it started to return
rows of records based on which SQL it came from, not as a
union sql, but seems like each SQL in the UNION is returning
rows of records individually and not keep them together as
one row.  Anyone having issue like these?  Any
recommendations?  tnx.
0
Teric
1/14/2011 8:34:10 PM
sybase.powerbuilder.datawindow 28057 articles. 4 followers. Follow

1 Replies
1057 Views

Similar Articles

[PageSpeed] 4

<Teric> wrote in message news:4d30b342.3f93.1681692777@sybase.com...
>I have a DW that was converted from PB 6.5 to PB 12 classic
> using MSSQL Server 2008 running Win XP SP 3.  Prior to
> conventions I have a dw report that runs a union-ed SQL
> without any issue.  After conversion, I started having
> report that still report information but it's the same
> format as before.  What it does is that it started to return
> rows of records based on which SQL it came from, not as a
> union sql, but seems like each SQL in the UNION is returning
> rows of records individually and not keep them together as
> one row.  Anyone having issue like these?  Any
> recommendations?  tnx.

Trace the connection or use the MS Profiler to see the actual query that is 
executed.  Could it be that your upgrade (which was probably rather 
extensive) change the logic surrounding the population of the datawindow or 
datawindow itself? In addition, was your PB6 application running against sql 
server 2008 - or perhaps an earlier version? Does this happen within the IDE 
during preview, in your application at runtime, or both?  Have you tried 
running the actual sql statement that is executed by your application in 
SSMS? 


0
Scott
1/14/2011 8:54:10 PM
Reply:

Similar Artilces:

SQL Server 2000 and SQL Server 2005 in the same server
Can enyone please send me a link to a white paper explaining how to run both SQL Server 2000 and 2005 in the same machine?Thanks. I don't know about the white paper but I had both running on my machine for a while by making the SQL 2000 a named instance. So for SQL 2005 connection strings my server name was (local) while for SQL 200 using the named instance it was (local)\joesql where joesql was the instance nameHope it helps,Joe http://www.joeaudette.comhttp://www.mojoportal.com...

This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers
When I connect SQL Server 2005 to a remote database i get the error: "This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers". Can I confirm it is because: the remote db is of SQL Server 2008? There is a soln mentioned in http://forums.asp.net/t/1324047.aspx Did anybody try this (installing 2008 express: http://www.microsoft.com/express/sql/download/)? I am just checking again, whether it will disturb my existing SQL Server installation, in any means...? Though it is mentioned that it will g...

SQL Server 2005 Installation problems with SQL Server Express & SQL Server 2000
Hi Guys, I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well.  (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!) Everything went fine except that nothing seemed to be installed.  I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing. A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005. So after a number o...

sql server and sql server express
ok i am puzzled right now....i have a web application connecting to a sql server database....i uninstalled sql server express and installed sql server 2005 full version...i changed the connection string in my application to be Data Source=SKYBANDR62;Initial Catalog=aspnetdb;Integrated Security=True and through the explorer bar i can access my database freely but when i run my application i get this error Server Error in '/' Application. -------------------------------------------------------------------------------- An error has occurred while establishing a...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi,Basically i built a webpage with Login and it's working well from my local machine.Right now, i'm using Database Publishing Wizard. the problem is how do i convert.MDF files to .SQL 2005 to get my database publish in the internet? thanks  Place your .MDF file in the App_Data directory, change the connection string accordingly and then publish your web site. ----------------------------------------------------------Please click Mark As Answer if this helped in solving your problem.  Please click "Mark As Answer" if this hepled in solving your problem. ...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf files ...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf file...

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Hello All, I'm Getting the following error when calling a dll from my vb.net application. [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. The dll was written in vb6 and accesses a sql db using the following connection string. Public Const GLOBAL_DNS As String = "DSN=TransSrvFinal;UID=sa;PWD=admin;" This DLL works fine when called from other Windows Apps. However I'm now trying to call this dll from with in an asp.net application. I'm using vb.net as the codebehind. I'm a...

MS SQL Server and SQL Anywhere Server
Hi! I would like to get information about differences in database's for MS SQL Server and SQL Anywhere Server. I have project in S-Designor - database for ASA Sybase. I would like to change ASA database project to fix MS SQL Server (I would like to minimalize costs). One difference I know: table name in MS SQL Server must be shorter than in ASA (I don't remember how long). Does anyone know more differences ? Thank in advance Joanna ...

SQL SERVER EXPRESS versus SQL SERVER
Would anyone really use ASPNET2 Membership Services with its built in Sql Server Express database for a major, heavy traffic website? How well would sql server express handle 1 million members? Can anyone point me to an article comparing performance of full blow Sql Server with (watered down?) Sql Server Express? Seems to me you already know the answer to this question in the way you ask the question.  SQL Server express is just for normal web applications for learning/teaching and small time deployment.  Obviously by logic heavy traffic ( esp in the 1 million range even in t...

SQL Server Express and SQL Server 2005
can any one tell me what the main differences are in the two editions? also can you use and express 2005 edition database on sql 2005? if not how would you do that? Tuppers Look here for a detailed comparison between the two.Yes, you can use Express databases on SQL Server 2005. Just attach it to an instance of SQL Server 2005.Is this enough information?DonDon Kiely, MCP, MCSDIn the Last Frontier, Interior AlaskaPlease post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem! cheers i was told by my host t...

sql server 2005 to sql server 2000
Due to certain unavoidable reasons we have to move an application from sql server 2005 to sql server 2000 (yes from 2005 to 2000).  would changing the connection string be sufficient or are there other issues involved. How hard is it going to be to get it to work? Any tips or suggestions are greatly appreciated. Yes you will need to change the connection string!However you must look very carefully at the database structure. Do two script exports of every object in the database - one for SQL2000 compatibility and one without. Compare these two scripts, if they are significantly differe...

sql server and sql server express conflict
hey all please help me ....i have been working on this issue for 2 days i created a web application with a automatically generated security database and added tables to it and it was working fine...i had to a linked server the linked server cannot be added from sql server express so i installed the full version...it was working fine until suddenly i got this error "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed" so i searched and searched then i found out that i cannot have the two ver...

SQL Server Express file to Sql Server
I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take?   Thanks for any helpTinyPond TinyPond:I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take? If you have Express Management Studio, you back backup your database, and them import it to SQL Server (or attach and reattach).Justs open SQL Server Express Management Studio, connect to your Express instanc...

Web resources about - SQL Server union all - sybase.powerbuilder.datawindow

Server farm - Wikipedia, the free encyclopedia
A server farm or server cluster is a collection of computer servers usually maintained by an enterprise to accomplish server needs far beyond ...

CRTC Issues First-Ever Warrant To Take Down Toronto-Based Malware Server 4
TORONTO — The CRTC has issued its first warrant under the federal government's anti-spam legislation to take down a Toronto-based malware server ...

Windows Server 2016 moving to per core, not per socket, licensing
Windows Server 2016, not likely to arrive until the second half of next year, is going to shake up the way Microsoft licenses its server operating ...

Server shipments, vendor revenue go up in Q3 2015
In the third quarter of 2015, worldwide server shipments grew 9.2 percent from the third quarter of 2014, while vendor revenue increased 7.5 ...

Bloodborne servers taken down for 'emergency maintenance'
An exploit and other "serious issues" have been detected.

Microsoft to change Windows Server 2016 licensing rules, will use per-core metric
Microsoft last week announced it will switch the licensing for next year's Windows Server 2016 to a per-processor-core basis, a move analysts ...

Senator Wonders If Hillary Is Covering Legal Expenses For Tech Firm That Managed Her Email Server
Senator Wonders If Hillary Is Covering Legal Expenses For Tech Firm That Managed Her Email Server

Samsung starts mass production of 128GB DDR4 modules for enterprise servers
Samsung Electronics has announced that it is mass producing the industry's first TSV DDR4 memory in 128GB modules for enterprise servers and ...

Server Files Sexual Harassment Complaint Against Pigalle Restaurant
... restaurant Pigalle is being accused of sexual harassment by a waitress , who says that management implied her jeans were "too much." The server ...

HPE, Dell Stay Atop Growing Global Server Market
Demand for rack systems and growth of hyperscale data centers help drive growth of x86-based systems, according to IDC and Gartner analysts. ...

Resources last updated: 12/9/2015 2:29:24 PM