Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 1st August 2016, 13:59
sasank sasank is offline
Junior Member
 
Join Date: Apr 2012
Posts: 12
sasank is on a distinguished road
Baan: FP2 - DB: sql 2008 - OS: Windows 2008
SQL query range

A new blog entry has been added:

SQL query range

Quote:
Hi,
Can any body help me how to set the range for the fields while wring the select query in SQL queries?
Regards
Sasank N 
Reply With Quote
  #2  
Old 1st August 2016, 18:26
vamsi_gujjula's Avatar
vamsi_gujjula vamsi_gujjula is offline
Senior Member
 
Join Date: Nov 2011
Location: hyderabad ; india
Posts: 240
vamsi_gujjula is on a distinguished road
Baan: ERPLN fp3 and 10.4 - DB: oracle - OS: Aix , Redhat linux 6
on SQL

select
tcibd001.item | Item
from
tcibd001 | Items - General
where
tcibd001.item >= tcibd001.item.f and
tcibd001.item <= tcibd001.item.t


using session

In the attachment.
Attached Images
File Type: png Capture.PNG (2.9 KB, 15 views)
__________________
Regards,
Vamsi
Reply With Quote
Sponsored Links
  #3  
Old 2nd August 2016, 07:00
sasank sasank is offline
Junior Member
 
Join Date: Apr 2012
Posts: 12
sasank is on a distinguished road
Baan: FP2 - DB: sql 2008 - OS: Windows 2008
Thanks a lot Vamsi.

Regards
Sasank N
Reply With Quote
  #4  
Old 5th August 2016, 14:16
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,365
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

Please post your questions in correct forums and not as blogs.

Moved to correct forum -> Tools Development
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
sql query srikarthy Tools Development 6 25th August 2010 10:46
Tips for Multi-company / Calculated items in MS SQL query Hitesh Shah Blogs and Web links 0 23rd May 2009 13:18
EASY SQL QUERY: Japanese Form Label not displayed completely. fredintaiwan Tools Development 0 4th December 2008 07:59
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 05:35


All times are GMT +2. The time now is 20:03.


©2001-2018 - Baanboard.com - Baanforums.com