Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

dBforums - Database Support Community - www.dbforums.com | Site profile

Site profile page for http://www.dbforums.com. This report page has aggregated and summarized the online discussions from the Message Board located at http://www.dbforums.com. This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional site profile information for http://www.dbforums.com is also shown in the following divisions:

1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.

Title: dBforums - Database Support Community - http://www.dbforums.com dBforums - Database Support Community
Url: http://www.dbforums.com
Users activity: 3 posts per thread
site activity: 728 active threads during last week
Site rank: 1,365 (go to rank page)
Domain info for: dbforums.com
 

Posting activity table on dBforums - Database Support Community:

  Week Month 3 Months
Threads: 728 2,199 6,067
Post: 2,424 6,595 17,336
 

Authority Badge:

dBforums - Database Support Community | Forum Authority Badge

dBforums - Database Support Community posting activity graph:

Posts by:  day  week  month 
 

http://www.dbforums.com Alexa graph:

Top authors on dBforums - Database Support Community during last week:

Name
Posts
Brett Kaiser
90
user's latest post:
Where clause to select both null...
Published (2009-11-20 16:05:00)
picky picky Code: WHERE idParCat = COALESCE(@parCat,idParCat ) OR idParCat IS NULL Pat is saying Null is not equal to anything...even itself it being an existential thing here
r937
83
user's latest post:
The Yak Corral X - Page 11 -...
Published (2009-11-20 20:12:00)
Quote: Originally Posted by TallCowboy0614 BTW Rudy...that sounded like the beginning of a cheap dimestore smut book. VERY nice. i was quoting, verbatim, a post that someone made here in this thread, which was deleted before i could respond to it fortunately, the entire post (which contained, other than this splendid prose, nothing untoward, i.e. no links, nothing) was in the email notification i received, and it shall forever live in my...
pootle flump
67
user's latest post:
SQL Server 2008 functionality...
Published (2009-11-20 15:46:00)
Quote: Originally Posted by blindman You are in serious danger of impressing me. A link to a white paper or BOL reference would be nice, though. You are in serious danger of disappointing me - you posted in the thread right after I last mentioned this: TRIGGERS vs using code in an sproc These were the references: http://sqlblogcasts.com/blogs/tonyro...0/27/1248.aspx http://www.sqlmag.com/Articles/Artic...11/pg/2/2.html DML Trigger Execution
blindman
67
user's latest post:
SQL Server 2008 functionality...
Published (2009-11-20 18:12:00)
Quote: Originally Posted by Enigma Looking for this ??? Really? Quote: When you have a schema change on your source table, you should do the following: 1. Change the schema of your source table. 2. Create a new capture instance. That new capture instance is created with the new (changed) schema of the source table. 3. Wait for a change to occur, and then read the minimum LSN from the new capture instance (using sys.fn_cdc_get_min_lsn(new...
mike_bike_kite
48
user's latest post:
The Yak Corral X - Page 10 -...
Published (2009-11-20 15:34:00)
I've actually had a bit of fun recently being involved in an uncovering of info regards climate change for one of the newspapers here in the UK. I actually believe in climate change but this data points otherwise but no doubt it will hit the headlines this weekend. My journalist friend always seems to get interesting stuff - the last one I played on was the one involving how much power is used by a Google search - I didn't agree on...
mishaalsy
47
user's latest post:
Importing database structure
Published (2009-11-20 02:06:00)
you are welcome
Lenny77
46
user's latest post:
Absolute SUDOKU Solver - Page 5...
Published (2009-11-20 18:42:00)
Code: Source (line, sudoku_str) as ( select 1, '800000350' from sysibm.sysdummy1 union all select 2, '000041002' from sysibm.sysdummy1 union all select 3, '000350040' from sysibm.sysdummy1 union all select 4, '000090718' from sysibm.sysdummy1 union all select 5, '018000920' from sysibm.sysdummy1 union all select 6, '924080000' from sysibm.sysdummy1 union all select 7,...
Tonkuma
42
user's latest post:
Converting DATE to CHAR
Published (2009-11-20 04:57:00)
TO_CHAR() returns VARCHAR(254). Code: ------------------------------ Commands Entered ------------------------------ DESCRIBE SELECT date_ , REPLACE(CHAR(date_, EUR), '.', '') AS "DDMMYYYY(replace.char)" , TRANSLATE('ghefabcd', HEX(date_), 'abcdefgh') AS "DDMMYYYY(translate.hex)" , SUBSTR(TO_CHAR(date_, 'DDMMYYYY'), 1, 8) AS...
gvee
41
user's latest post:
help wit vb6
Published (2009-11-20 16:11:00)
VB6 & Access... Why did you chose to post in the Adabas topic then?
pkstormy
40
user's latest post:
How to Close a subForm in a main...
Published (2009-11-20 12:00:00)
Removing the sourceobject essentially removes the subform from the main form (and thus, removing any code, recordsets cycling, or anything else associated with the subform.) You can use the visible to hide/unhide the subform but as you mentioned, the form is still running in the background. This can have affect on any code you run which opens the subform's same recordset and updates it (if the subform is invisible). If the subform is not...
 

Top 10 active forums on dBforums - Database Support Community during last week:

DB2 - 513 new posts DB2 - forum profile
Microsoft Access - 344 new posts Microsoft Access - forum profile
Microsoft SQL Server - 303 new posts Microsoft SQL Server - forum profile
Oracle - 211 new posts Oracle - forum profile
Database Concepts & Design - 159 new posts Database Concepts & Design - forum profile
Chit Chat - 123 new posts Chit Chat - forum profile
MySQL - 111 new posts MySQL - forum profile
PostgreSQL - 93 new posts PostgreSQL - forum profile
Unix Shell Scripts - 56 new posts Unix Shell Scripts - forum profile
ASP - 29 new posts ASP - forum profile
 

Top 10 forums on dBforums - Database Support Community:

Microsoft Access - 27,327 posts Microsoft Access - forum profile
Microsoft SQL Server - 23,094 posts Microsoft SQL Server - forum profile
DB2 - 21,145 posts DB2 - forum profile
Chit Chat - 13,950 posts Chit Chat - forum profile
Oracle - 12,230 posts Oracle - forum profile
Database Concepts & Design - 9,158 posts Database Concepts & Design - forum profile
MySQL - 8,769 posts MySQL - forum profile
Sybase - 4,012 posts Sybase - forum profile
Informix - 2,016 posts Informix - forum profile
Microsoft Excel - 1,939 posts Microsoft Excel - forum profile

Latest active threads on dBforums - Database Support Community:

dBforums - Database Support Community
Started 1 day, 1 hour ago (2009-11-21 10:54:00)  by darylmark
Darren, Are you trying to do the grouping on the SQL side or within Crystal Reports. Given the SQL above, you can create a CR Running Total which will sum the value of QTY. You could also create a group for LedgType and then use the Record Selector to limit what records are displayed in the group. I hope this helps.
Forum:  Crystal Reports Crystal Reports - forum profile
Thread:  Show this thread (2 posts) Thread info: SQL Command Size: 337 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SQL Command :: Crystal Reports :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 2 weeks, 6 days ago (2009-11-02 09:49:00)  by andersons andersons is offline Registered User
I need to know if it is possible to display a different picture in a report based on the data that is retrieved. What I have is a Crystal 9 report and I need to display a different person's signature at the bottom, based on the siteid field, e.g. if the siteid is Anywhere I want to show John Doe's signature, but if the siteid is Nowhere, I want to show Jane Doe's signature. Is there any way to ...
Forum:  Crystal Reports Crystal Reports - forum profile
Thread:  Show this thread (3 posts) Thread info: Dynamically change picture in report based on data Size: 775 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Dynamically change picture in report based on data :: Crystal Reports :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 2 weeks, 6 days ago (2009-11-02 04:21:00)  by edgard_s Registered User
I have a project in vb6 with external crystal reports, i need to set the report data source dynamically through vb6
Forum:  Crystal Reports Crystal Reports - forum profile
Thread:  Show this thread (5 posts) Thread info: Set the crystal report data source from vb6 Size: 116 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Set the crystal report data source from vb6 :: Crystal Reports :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 1 day, 1 hour ago (2009-11-21 10:30:00)  by darylmark
Greetings den@t, What you can do is create a formula which returns the left most three characters (Using LEFT string function) of the inventory ID. You can then create a group based on the formula and then sort the inventory IDs within that group. Hope that helps.
Forum:  Crystal Reports Crystal Reports - forum profile
Thread:  Show this thread (2 posts) Thread info: How to group when no field to group on? Size: 448 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Creating Your Own Grouping Criteria :: Crystal Reports :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 1 day, 1 hour ago (2009-11-21 10:26:00)  by darylmark
The other thing you could do is to create a group based on the property id, sales date and sales price. Then at the group level you could check "Suppress if duplicate" to turn off the duplicates.
Forum:  Crystal Reports Crystal Reports - forum profile
Thread:  Show this thread (2 posts) Thread info: Supressing duplicates Size: 206 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Solving Duplicate Values :: Crystal Reports :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 2 days ago (2009-11-20 11:55:00)  by msbclem
I'm working on a similar report but for property sales based on property class code. I'm just using the select expert to get data from the class codes I need.
Forum:  Crystal Reports Crystal Reports - forum profile
Thread:  Show this thread (3 posts) Thread info: creating a report template Size: 159 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: I'm working on a similar report but for property sales based on property
class code. I'm just using the... :: Crystal Reports :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 1 week, 6 days ago (2009-11-08 19:47:00)  by r937
oh noes!! i guess it was all my fault, i started IX and it was immediately a spam magnet
Forum:  Chit Chat Chit Chat - forum profile
Thread:  Show this thread (170 posts) Thread info: The Yak Corral X Size: 246 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: oh noes!!

i guess it was all my fault, i started IX and it was immediately a spam
magnet :: Chit Chat :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 6 days, 5 hours ago (2009-11-16 07:04:00)  by r937
Quote: Originally Posted by Bazzaah What I am puzzling with is how to connect database entries to the actual audio files. Code: INSERT INTO mp3s ( title , genre , location ) VALUES ( 'my lonely heart' , 'country rock' , 'D:/stolen/country/lonely.mp3' )
Forum:  MySQL MySQL - forum profile
Thread:  Show this thread (16 posts) Thread info: Link mySQL db to content Size: 1,147 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Quote:

	Originally Posted by Bazzaah What I am puzzling with is how to connect database entries to the actual... :: MySQL :: dBforums - Database Support Community"
 

Hot threads for last week on dBforums - Database Support Community:

Chit Chat
Started 1 week, 6 days ago (2009-11-08 19:47:00)  by r937
oh noes!! i guess it was all my fault, i started IX and it was immediately a spam magnet
Forum:  Chit Chat Chit Chat - forum profile
Thread:  Show this thread (170 posts) Thread info: The Yak Corral X Size: 246 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: oh noes!!

i guess it was all my fault, i started IX and it was immediately a spam
magnet :: Chit Chat :: dBforums - Database Support Community"
DB2
Started 2 weeks, 3 days ago (2009-11-05 10:37:00)  by sathyaram_s
700 is obsolete. I suggest you take 730. IBM developerWorks : DB2 9 Fundamentals certification 730 prep series Download these tutorials and I am sure you can pass (and learn too)!
Forum:  DB2 DB2 - forum profile
Thread:  Show this thread (102 posts) Thread info: Where I can get the DUMPS of Paper 700. Size: 348 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: 700 is obsolete. I suggest you take 730.

IBM developerWorks : DB2 9 Fundamentals certification 730 prep series

Download... :: DB2 :: dBforums - Database Support Community"
Database Concepts & Design
Started 4 days, 19 hours ago (2009-11-17 17:09:00)  by Brett Kaiser
usually U treat phone numbers as pretty much unique to a person/business So I don't worry too much about redundant data Also, a Phone number ID???? WHY on earth do you want to do this? And is this a table? Code: PhoneNumberID (pk) OfficeID (fk nullable) PatientID (fk nullable) PharmacyID (fk nullable) SiteUserID (fk nullable) AreaCode Prefix Suffix If ...
Forum:  Database Concepts & Design Database Concepts & Design - forum profile
Thread:  Show this thread (56 posts) Thread info: normalizing the PhoneNumbers table Size: 896 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: usually U treat phone numbers as pretty much unique to a person/business

So I don't worry too much about... :: Database Concepts & Design :: dBforums - Database Support Community"
JAVA
Started 1 week ago (2009-11-14 13:45:00)  by Pyrophorus
DriverManager call is correct. Did you configure an ODBC source named RedWines in the system ? Having only an Access database named RedWines is not enough. HTH Laurent
Forum:  JAVA JAVA - forum profile
Thread:  Show this thread (26 posts) Thread info: run in my PC: Type 1 db driver Access / java[SE1.6] Desktop Applications,
what I need Size: 196 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: DriverManager call is correct.
Did you configure an ODBC source named RedWines in the system ? Having only
an... :: JAVA :: dBforums - Database Support Community"
Microsoft SQL Server
Started 4 days, 8 hours ago (2009-11-18 03:23:00)  by dportas
CDC. It takes only a few minutes to enable it and the impact in most cases should be minimal (of course you should make sure you test it). Triggers introduce lots of complexity and frequently harm performance and make support and development more difficult.
Forum:  Microsoft SQL Server Microsoft SQL Server - forum profile
Thread:  Show this thread (25 posts) Thread info: SQL Server 2008 functionality for Audit Log Size: 257 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: CDC. It takes only a few minutes to enable it and the impact in most cases
should be minimal... :: Microsoft SQL Server :: dBforums - Database Support Community"
DB2
Started 1 week, 2 days ago (2009-11-13 02:20:00)  by sathyaram_s
let's say d1 and d2 are the columns in table dts representing start date and end date for considerations .. then your query will be Code: select (julian_day(D2)-julian_day(D1)+(dayofweek_iso(d1)- 1))/7 from dts for testing, i used Code: with dts(d1,d2,comment) as ( values('2009-11-09','2009-11-15','- no bounday crossed, 7 days'), ('2009-11-09','2009-11-16' , '...
Forum:  DB2 DB2 - forum profile
Thread:  Show this thread (33 posts) Thread info: Difference in weeks between dates Size: 1,685 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: let's say d1 and d2 are the columns in table dts representing start date
and end date for considerations... :: DB2 :: dBforums - Database Support Community"
Database Concepts & Design
Started 2 days, 11 hours ago (2009-11-20 01:17:00)  by blindman
Most of the time you can simply store address information as an attribute of person, or as a subtable if people can have more than one address, and not worry about storing the same address twice because 95% of the time we are much more interested in tracking people than tracking houses. But if you are developing a real-estate application, or a building maintenance application, then you would ...
Forum:  Database Concepts & Design Database Concepts & Design - forum profile
Thread:  Show this thread (24 posts) Thread info: Quick question... very new! Size: 507 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Most of the time you can simply store address information as an attribute
of person, or as a subtable... :: Database Concepts & Design :: dBforums - Database Support Community"
Oracle
Started 6 days, 23 hours ago (2009-11-15 12:41:00)  by anacedent
>Isikukood is a personal ID, where are 11 numbers. First number is 3 or 4. If 3 then man and if 4 then woman. Second 2 numbers are year of birth. If this is real life production "design", the person responsible should be promoted to chimney sweep trainee. Otherwise it is a decent homework assignment.
Forum:  Oracle Oracle - forum profile
Thread:  Show this thread (23 posts) Thread info: MAX average points by year and sex Size: 349 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: >Isikukood is a personal ID, where are 11 numbers. First number is 3 or 4.
If 3 then man... :: Oracle :: dBforums - Database Support Community"
Microsoft Access
Started 4 days, 8 hours ago (2009-11-18 04:15:00)  by healdem
select my, column, list from mytable where acolumn not like "~*" MSysObjects is the table you want queries can be found by limiting the Type to 5
Forum:  Microsoft Access Microsoft Access - forum profile
Thread:  Show this thread (22 posts) Thread info: SQL statement Size: 184 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: select my, column, list from mytable
where acolumn not like "~*"

MSysObjects is the table you want
queries can... :: Microsoft Access :: dBforums - Database Support Community"
Microsoft SQL Server
Started 5 days, 8 hours ago (2009-11-17 04:08:00)  by pootle flump
Good for you! So what's the question?
Forum:  Microsoft SQL Server Microsoft SQL Server - forum profile
Thread:  Show this thread (21 post) Thread info: Converting functions of Postgre SQL into SQL Server 2005 Size: 44 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Good for you!
So what's the question? :: Microsoft SQL Server :: dBforums - Database Support Community"

This page was found by:   Concatenate with Microsoft AQT