| Groups | Blog | Home |
|
March 2003 April 2003 May 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 how/what should be the query for this result Posted by choudharymv NO[at]SPAM gmail.com at 6/28/2006 7:25:24 AM I have 1 table "Progress"
P_no b_no status build_date
----------------------------------------------------------------
25 1 First_slab 2006/4/5
25 1 second slab 2006/5/6
25 2 ...more >>
SQL Express (General Qs) Posted by Maura Jenkins at 6/27/2006 3:01:29 AM Hi ...
I would sincerely appreciate some input on a few questions related to SQL
Server Express:
(1) Is SQL Server Express free for business use ?
(2) Does the 1GB RAM limit does that mean SQLExpress will only use 1 GB or
the machine it's running can only have 1 GB installed ?
(3) Si...more >>
Have Insert statement, need equivalent Update. Posted by rhaazy at 6/26/2006 1:54:26 PM Using ms sql 2000
I have 2 tables.
I have a table which has information regarding a computer scan. Each
record in this table has a column called MAC which is the unique ID for
each Scan. The table in question holds the various scan results of
every scan from different computers. I have an ...more >>
Would replication work here? Posted by mkerrigan NO[at]SPAM ktoys.com at 6/26/2006 12:48:46 PM I have two databases on the same server. I want to populate and keep
synchronized a table on database 2 from a view on database 1. Whenever
data would change in the underlying tables on database 1, it would
update the table on database 2. Is this something that can be done
through replication...more >>
SELECT statement help Posted by schoultzy at 6/26/2006 12:36:19 PM Hello everyone,
I am working with the following code:
select section_master.trm_cde, section_master.crs_cde, crs_title,
crs_capacity,
crs_enrollment, section_master.udef_3a_1, monday, tuesday, wednesday,
thursday, friday, begin_time, end_time, bldg_cde, room_cde,
name_master.last_name
f...more >>
SQL Help Posted by Bill Schanks at 6/26/2006 9:13:31 AM I have this SQL:
SELECT
U.ID,
U.PrefID,
U.LastName,
U.FirstName,
U.FirstLogin,
U.LastLogin,
UserActive =
CASE
WHEN (U.LastLoginAppVersion = '' OR U.LastLoginAppVersion IS
NULL) THEN 'No'
ELSE 'Yes'
END,
COUNT(DISTINCT A.ID) AS AssingedIssues,
COUNT(DISTINCT R.ID) AS...more >>
How do I query pc making call to data base? Posted by prumery NO[at]SPAM verizon.net at 6/25/2006 9:04:37 AM I'm using one account to connect to the 2005 express data base via
asp.net v2 and I want to get the users domain account and insert it
into journal tables. Is there a way for me to get the users domain
account from a stored procedure? If not, how would you track changes
to data from a shared a...more >>
Exporting Table with Data to Script text file in MSSQL 2005 ? Posted by olo at 6/23/2006 11:07:44 PM Hi!
How to exporty table to script file with data ? When I use Scipt Table As
option I get script to create table but without data :(
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Unique key on 2 fields in which 1 is non unique under the first unique key Posted by Vicky at 6/23/2006 4:53:55 AM Hi ,
I want to create a unique field on 2 columns named (customer_id ,
is_default ).
but the problem I have in having this is in my customer table
customer_id field is unique and can have more than 4-5 values for
is_default field. hence if I want to create a unique key composed of
the above 2...more >>
not enough storage is available to complete this operation err msg Posted by Dica at 6/22/2006 6:10:07 PM i'm receiving this error message in my dts package:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: Note enough storage is available to complete this
operation.
Note enough storage is available to complete this operation.
Note enough storage is available to complete...more >>
assign each instance by each IP Posted by Racheal at 6/22/2006 2:43:44 AM Dear all,
Do you know how to assign each instance by each IP.
eg.
SQL/Instance1 = 192.168.0.2
SQL/Instance2 = 192.168.0.3
SQL/Instance3 = 192.168.0.4
Thank
Racheal
...more >>
SQL Server 2005 and Cursors Posted by steve_craze NO[at]SPAM hotmail.com at 6/22/2006 1:01:13 AM Hi Everyone!
We are using a cursor for paging results in SQL server, mainly due to
the performance gains achieved when working with large results sets.
We have found this to be of great benefit when working with SQL Server
2000, but have run into major problems when using it on SQL Server
200...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |