|
More site info...
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.
|
|
|
|
|
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:
|
|
|
BoardReader Authority Badge code for dBforums - Database Support Community (http://www.dbforums.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
dBforums - Database Support Community posting activity graph:
|
|
http://www.dbforums.com Alexa graph:
|
Top authors on dBforums - Database Support Community during last week:
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
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...
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
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...
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...
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,...
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...
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?
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:
|
|
Top 10 forums on dBforums - Database Support Community:
Microsoft Access
- 27,327 posts
|
Microsoft SQL Server
- 23,094 posts
|
DB2
- 21,145 posts
|
Chit Chat
- 13,950 posts
|
Oracle
- 12,230 posts
|
Database Concepts & Design
- 9,158 posts
|
MySQL
- 8,769 posts
|
Sybase
- 4,012 posts
|
Informix
- 2,016 posts
|
Microsoft Excel
- 1,939 posts
|
|
|
|
|
Latest active threads on 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.
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 ...
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
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.
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.
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.
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
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' )
|
|
Hot threads for last week on 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
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)!
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 ...
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
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.
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' , '...
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 ...
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.
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
Started 5 days, 8 hours ago (2009-11-17 04:08:00)
by pootle flump
Good for you!
So what's the question?
|
|
Size: 337 bytes
