Tip Bank

Question: I have a table like this: name cat1 cat2—- —— —–A 1 orangeA 1 orangeB 1 appleB 1 appleB 1 appleC 2 bananaC 2 bananaC 2 bananaC 2 banana

Question: I’m trying to query our Human Resources database to find the number of temporary employees in each department. I’m using the following SQL statement: select count (*)from employeewhere status

Question: How can I dynamically add a visual userobject to a visual userobject? The PB documentation mentions how to add a userobject to a window at run-time, but not how

Question: I have a problem making reports flexible. Let us assume we have a standard report, but it changes according to the situation. How can I allow users to change

Question: Can I print only one page in datawindow? Answer: Yes, you can set the print range of a datawindow, just like in Word or Excel. If you set the

Question: I have a select query “Select * from Table where ID in (8, 2,3,78,32,1,7)” that I want returned in the same order that the IDs are in in the

Question: I want to filter out data from a datawindow during runtime. I have a sle-field in which the user enters a search string (for example, “SM”). This should be

Question: I have been asked as a SQLServer DBA to certify SQLServer 6.5 as Y2K compliant, apart from any statements from Microsoft. I am aware that Microsoft indicates that all

Question: Is there a way to title report outputs in SQL? Answer: If you are creating a quick and dirty report, you can always add a title simply by putting