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... 

SQL / ADO / ADO.NET | Forum profile
Forum profile page for SQL / ADO / ADO.NET on http://www.codeproject.com. This report page is the aggregated overview from a single forum: SQL / ADO / ADO.NET, located on the Message Board at http://www.codeproject.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "SQL / ADO / ADO.NET" on the Message Board at http://www.codeproject.com is also shown in the following ways:

1) Latest Active Threads
2) 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 forum's popularity and/or exact posting volumes at any given reporting period.
Site: CodeProject: Discussion Boards. Free source code and programming help - SQL / ADO / ADO.NET
CodeProject: Discussion Boards. Free source code and programming help
(site profile, domain info codeproject.com)
Title: SQL / ADO / ADO.NET
Url: http://www.codeproject.com/script/Forums/View.a...
Users activity: 28 posts per thread
Forum activity: 52 active threads during last week
 

Posting activity on SQL / ADO / ADO.NET:

  Week Month 3 Months
Threads: 52 183 490
Post: 149 540 1,362
 

SQL / ADO / ADO.NET Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Mycroft Holmes
25
user's latest post:
Unable to get the data from 2...
Published (2009-11-07 19:17:00)
Try the following select * from [ 11 . 12 . 23 . 121 ].testdb.dbo.userreg
Niladri_Biswas
24
user's latest post:
What would be the equivalent in...
Published (2009-11-07 00:22:00)
Yes you are right. View is to rescue and PIVOT is available since SQL SERVER version 2005. In 2000, Pivoting is archived via CASE statements e.g. http://jdixon.dotnetdevelopersjournal.com/pivot_table_data_in_sql_server_2000_and_2005.htm [ ^ ]
J4amieC
8
user's latest post:
MS SQL Selecting all rows in one...
Published (2009-11-05 09:05:00)
Steven J Jowett wrote: If I execute a SELECT query on the receipts table WHERE ReceiptId = 330804 , I get 2 rows. Steven J Jowett wrote: SELECT * FROM vuProductReceipts WHERE ReceiptId = 330804 OR ReceiptId IS NULL Steven J Jowett wrote: I would expect to get 126 rows returned, but I am only getting 63. Based on the above three asserions, im guessing there are 61 products without any receipts. What's your question?
Vuyiswa Maseko
7
user's latest post:
SSIS Variable Problem
Published (2009-11-03 03:20:00)
Good Day all i have created a Global Variable as depicted in the following Pic http://www.tiyaneproperties.co.za/SSIS/pic1.JPG [ ^ ] The Following Screen-shot shows how i created my Variable and its Properties http://www.tiyaneproperties.co.za/SSIS/pic2.JPG [ ^ ] and the Following Screen-shot shows the Script Editor Properties http://www.tiyaneproperties.co.za/SSIS/pic3.JPG [ ^ ] and the Last pic is the code that write to the XML File...
Eddy Vluggen
7
user's latest post:
SQL Server 2005 - Passing 2 Dim....
Published (2009-11-05 14:39:00)
Anusha.1980 wrote: Would you please let me know if there is a way to do it? One way would be by using XML [ ^ ]
chakran
7
user's latest post:
How to update multiple rows in a...
Published (2009-11-06 06:25:00)
sorry there is no other table. We have only one table called "BugsDB_DefectVolume". In that single table we need to update weekno and Startdayofweek using Bugdate column...
nainakarri
6
user's latest post:
Problem with Execute query by...
Published (2009-10-30 00:34:00)
I finally got the answere..... I declared @string as varchar(8000). But there are nvarchars declared which i am assigning to @string which finally lead to the problem . because of this @string is taking only 4000 charecters, I replaced all nvarchars with varchars and finally its taking morethan 4000 charecters. Regards Naina
sachees123
4
user's latest post:
sql v/s ms access
Published (2009-11-05 04:27:00)
Thats true, type in access is date/time and format is "Short Date - 26/12/2009". When i call this through SQL it change dd/mm/yyyy to mm/dd/yyyy. Where to change, in sql or access??? As i cant change system date / time format. tell
Jörgen Andersson
3
user's latest post:
Convert Oracle Query to MS-Access
Published (2009-10-30 09:25:00)
Damn! I need a coffee. Or actually rather a beer. Or both.
Andy_L_J
3
user's latest post:
Can't Create database
Published (2009-11-01 17:55:00)
I ran the script and it created a Sql Server 2008 database in the specified folders. The path the op is using is definitely for 2008, and if he was using a 2005 instance then the default path should have been what you posted - notice no comments from the op for over 4 hours.
 

Latest active threads on SQL / ADO / ADO.NET::

CodeProject: Discussion Boards. Free source code and programming help
Started 9 hours, 35 minutes ago (2009-11-09 10:19:00)  by loyal ginger
You can write a program to do the job, then schedule it using the scheduler (get access to it from Control Panel) to make it run every day at midnight.
Thread:  Show this thread (3 posts)   Thread info: how to merge or copy one database to another at Midnight every day Size: 181 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: how to merge or copy one database to another at Midnight every day :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
CodeProject: Discussion Boards. Free source code and programming help
Started 3 days, 23 hours ago (2009-11-05 20:20:00)  by Mycroft Holmes
Just add the field, SQL server will insert the ID values for existing records (It does in 2008 and I think it did in 2005). If not add the field, use row_number() to update the value and then add the identity constraint.
Thread:  Show this thread (4 posts)   Thread info: SQL Server 2005 - Working with IDENTITY column Size: 313 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: SQL Server 2005 - Working with IDENTITY column :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
CodeProject: Discussion Boards. Free source code and programming help
Started 4 days, 3 hours ago (2009-11-05 16:45:00)  by Garth J Lancaster
I'm wondering what you'd do if you had to 'resort to writing a custom program?' - since as you say, they are (I'll use the terms) disjoint/un-related instead of your 'irrelavent' since you dont have anything in common between the tables, and as you say, you cant join by record numbers the only way I can see of doing this (which assumes you can see record numbers) is to manually create a 'link' ...
Thread:  Show this thread (7 posts)   Thread info: horizontal union operation Size: 1,081 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: horizontal union operation :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
CodeProject: Discussion Boards. Free source code and programming help
Started 1 day ago (2009-11-08 19:11:00)  by Mycroft Holmes
Do the whole thing in a stored proc. Create a temp table to hold the interim calculations and then do your processing on the temp table (table var in SQL Server). Your design seems a little odd if you hold both the values to be averaged and the weighting factor in the same table. Row_number() is very useful in this type of processing.
Thread:  Show this thread (3 posts)   Thread info: Weighted average in T-SQL (like Excel's SUMPRODUCT) Size: 462 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Weighted average in T-SQL (like Excel's SUMPRODUCT) :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
CodeProject: Discussion Boards. Free source code and programming help
Started 1 day, 4 hours ago (2009-11-08 15:05:00)  by Abhishek sur
prathapcode wrote: And now coming to SQL server whether licensed key is required? AFAIK sql server express can be freely distributed. Just you need to create a setup application and execute its installer from your program.
Thread:  Show this thread (2 posts)   Thread info: Sql server license key Size: 421 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Sql server license key :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
CodeProject: Discussion Boards. Free source code and programming help
Started 1 day, 14 hours ago (2009-11-08 05:35:00)  by Abhishek sur
use Update Trigger. Whenever the row is updated use :old and : new objects to get the data from updated row and new row. If it is after update trigger, you need to use :old to get old values otherwise use select from table to get the value. Now insert them to the log table. For instance : CREATE OR REPLACE TRIGGER orders_after_update AFTER UPDATE ON ...
Thread:  Show this thread (2 posts)   Thread info: backp updated row Size: 2,019 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: backp updated row :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
CodeProject: Discussion Boards. Free source code and programming help
Started 2 days ago (2009-11-07 19:17:00)  by Mycroft Holmes
Try the following select * from [ 11 . 12 . 23 . 121 ].testdb.dbo.userreg
Thread:  Show this thread (4 posts)   Thread info: Unable to get the data from 2 tables which are in 2 differenet servers Size: 345 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Unable to get the data from 2 tables which are in 2 differenet servers :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
 

Hot threads for last week on SQL / ADO / ADO.NET::

SQL / ADO / ADO.NET
Started 6 days, 16 hours ago (2009-11-03 03:50:00)  by Niladri_Biswas
truncate table tblName
Thread:  Show this thread (12 posts)   Thread info: How can we Empty the whole tables by one single query Size: 145 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How can we Empty the whole tables by one single query :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
SQL / ADO / ADO.NET
Started 1 week ago (2009-11-02 01:32:00)  by il_masacratore
Maybe it ins't the best solution but you can use a group by (CustomerId), then you have to choose wich CustomerName is the choosen (min(CustomerName), max(CustomerName...). Sql: > select CustomerId, max(CustomerName) from Customer group by CustomerId.
Thread:  Show this thread (8 posts)   Thread info: how to write querey return the unique CustomerId with the first CustomerName ? Size: 302 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: how to write querey return the unique CustomerId with the first CustomerName ? :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
SQL / ADO / ADO.NET
Started 4 days, 19 hours ago (2009-11-05 00:20:00)  by sachees123
I dont want to change any format anywhere. Its the access which is changing the format from dd/mm/yyyy to mm/dd/yyyy. Why it is doing and wats the solution?? Thats my question.
Thread:  Show this thread (8 posts)   Thread info: sql v/s ms access Size: 207 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: sql v/s ms access :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
SQL / ADO / ADO.NET
Started 4 days, 10 hours ago (2009-11-05 09:05:00)  by J4amieC
Steven J Jowett wrote: If I execute a SELECT query on the receipts table WHERE ReceiptId = 330804 , I get 2 rows. Steven J Jowett wrote: SELECT * FROM vuProductReceipts WHERE ReceiptId = 330804 OR ReceiptId IS NULL Steven J Jowett wrote: I would expect to get 126 rows returned, but I am only getting 63. Based on the above three asserions, im guessing there are 61 products without ...
Thread:  Show this thread (7 posts)   Thread info: MS SQL Selecting all rows in one table and only rows matching in a second Size: 700 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: MS SQL Selecting all rows in one table and only rows matching in a second :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
SQL / ADO / ADO.NET
Started 4 days, 3 hours ago (2009-11-05 16:45:00)  by Garth J Lancaster
I'm wondering what you'd do if you had to 'resort to writing a custom program?' - since as you say, they are (I'll use the terms) disjoint/un-related instead of your 'irrelavent' since you dont have anything in common between the tables, and as you say, you cant join by record numbers the only way I can see of doing this (which assumes you can see record numbers) is to manually create a 'link' ...
Thread:  Show this thread (7 posts)   Thread info: horizontal union operation Size: 1,081 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: horizontal union operation :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
SQL / ADO / ADO.NET
Started 1 week, 1 day ago (2009-11-01 13:47:00)  by Andy_L_J
I'm not certain, but doesn't twsted f8 wrote: MSSQL10.MSSQLSERVER refer to a SQL Server 2008 instance? (Does on my machine)
Thread:  Show this thread (6 posts)   Thread info: Can't Create database Size: 250 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Can't Create database :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
SQL / ADO / ADO.NET
Re: SQL To XML - 6 new posts
Started 1 week, 3 days ago (2009-10-30 11:54:00)  by J4amieC
Vuyiswa Maseko wrote: i want to Store the File as "XMLDoc1.XML" in my C:\ And where is the problem?
Thread:  Show this thread (12 posts)   Thread info: SQL To XML Size: 204 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: SQL To XML :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
SQL / ADO / ADO.NET
Started 6 days, 23 hours ago (2009-11-02 19:59:00)  by Mycroft Holmes
You seem to have 2 disassociated queries here, one on Account List and another on Budget with no logic to join them. [rant] Who in his right mind allows spaces in table/field names and what idiot allows reserved words to be used as field names (Date) [/rant] SELECT [Account List].[Twin Pack] FROM [Account List] WHERE something NOT EXISTS (SELECT Budget.[Twin Pack] FROM Budget WHERE (((...
Thread:  Show this thread (6 posts)   Thread info: NOT EXISTS function not working Size: 693 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: NOT EXISTS function not working :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
SQL / ADO / ADO.NET
Started 5 days, 18 hours ago (2009-11-04 01:01:00)  by d@nish
ExecuteNonQuery would do that if you are speaking of managed C++.
Thread:  Show this thread (6 posts)   Thread info: Need help on how to update SQL query using VC++ Size: 103 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Need help on how to update SQL query using VC++ :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."
SQL / ADO / ADO.NET
Started 1 week ago (2009-11-02 02:01:00)  by Mycroft Holmes
I recommend that you BACKUP the database instead of copying the MDF.
Thread:  Show this thread (5 posts)   Thread info: Detaching SQL Database .mdf file ! Size: 106 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Detaching SQL Database .mdf file ! :: SQL / ADO / ADO.NET :: CodeProject: Discussion Boards. Free source code a..."