Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

web part showing wrong output

  Asked By: Chelsea    Date: Nov 16    Category: Sharepoint    Views: 808

Actually this might be simple SQL Query related issue. I am displaying couple of
records in a webpart in a coloum using Select UNION Query. Like:

Tender NO
-------------------------
23
26
30

For the above I have used three select queires using UNION. My problem is I was
to display records exactly as it is stored physically on the DB Tables and not
ascending or Decending order


Tender No
----------------
30
23
26

Any help will be hightly appreciated. What would be the approprate query for the
same.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Christop Mcfadden     Answered On: Nov 16

Adding to the line below:

I am using this query:
select tn as Tender No from <Table1>
UNION
Select tn01 as Tender No from <Table 2>
Union
Select tn02 as Tender No from <Table 3>

the result set displays the records  in Ascending order. I want to avoid that and
need to show the recrods as it is stored  in the DB Table.

 
Didn't find what you were looking for? Find more on web part showing wrong output Or get search suggestion and latest updates.




Tagged: