|
|
|
January 2003 March 2003 April 2003 May 2003 June 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 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Order of something Posted by Stijn Verrept at 10/18/2003 11:01:33 PM I have the following problem:
There is a table with assemblies and one with repairs.
The manager can choose to order those repairs or assemblies in a way they
should be handled. So I would need an order field on every repair (which
can be null). Now which value should I put in that order f...more >>
top 2 Posted by u128845214 NO[at]SPAM spawnkill.ip-mobilphone.net at 10/18/2003 10:00:56 PM #Table(class, name,exam,score)
A name1 math 100
A name1 math 88
A name1 Phy 98
A name1 Chm 98
A name1 SPT 89
A name1 math 23
A name1 math 45
A name2 math 54
A name2 math 79
A name2 Phy 79
A name2 Chm 44
A name2 SPT 34
A name2 math 45
A name2 math 65
B...more >>
Stored Procedures Posted by Jarrod Morrison at 10/18/2003 6:45:12 PM Hi all
Im relatively new to using stored procedures and im not sure if it is
possible to do what I am trying to do so any help here is greatly
appreciated. I am using the variable @MachineName which is obviously the
local machine name mainly in this procedure. What is loop through from the
fi...more >>
SQL Query Problem Posted by jiatiejun at 10/18/2003 3:44:10 PM SQL Query Problem£¿
There are 3 tables£º
sales £¨include SaleID,SaleName ... etc£©
goods (include GoodsID,GOodsName ... etc)
list (include GoodsID,SaleID,Number,Price ... etc)
I want to get follow query result:
Sales Sale1 Sale2 Sale3 Sale4 ... ... Sum
Goods
Goods1 ...more >>
Recordset field attributes Posted by aris at 10/18/2003 3:06:03 PM I have a stored procedure (running on Wintel SQL Serv 2000) that selects
across a few tables one of them being a temporary. It seems that when I fill
an ADO Recordset with data resulting from this stored proc (irrespective of
language) only some of the fields are writable. The ones that aren't ar...more >>
determine column datatypes Posted by Scollop at 10/18/2003 2:32:40 PM Hello,
how I can determine the datatypes of columns of existing tables?
tnx & regards
Mark
...more >>
Dynamic SQL... Posted by R-M at 10/18/2003 11:20:21 AM Hi
I've a table with following concept in SQL Server 2000
--it means part1 include part2 with number of "qty".
create table p (part1 char(3),part2 char(3) ,qty numeric(3))
go
insert into p values('100','105', 1)
insert into p values('100','109', 3)
insert into p values('101','104'...more >>
DTS - Execute SQL Task Posted by \ at 10/18/2003 10:55:03 AM Can you ppl give me a clue on using DISTINCT in the following - it doesn't
work in the Execute SQL Task in DTS like it is - but the call itself returns
the right results in the SQL Query Analyser.
I'm using the great tool, XPSMTP, to send emails containing dataextractions.
The following code r...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Export to a ODBC DSN from SQL Posted by lundd NO[at]SPAM fihrst.com at 10/18/2003 9:02:52 AM Hi,
My problem is as follows:
From my app the user can select any DSN defined on thier machine,
which they wish to export the data to.
-------------------------------------------------------
I've played around with queries in the following format:
SELECT * INTO [ODBC;DSN=MyDsn].DestTable
FR...more >>
Error when using Cube Editor Posted by John Pederson at 10/18/2003 9:02:31 AM When using the cude editor, I receive an error message
when I attempt to access a cube. The error message is:
Unable to open the cube InsideSales. An unexpected
internal error has occurred. Please restart the
application.
I don't receive this with any other cubes. Does anyone
have an...more >>
sex Posted by skip at 10/18/2003 7:51:04 AM ...more >>
USE STORED PROCEDURES Posted by cRISTIAN at 10/18/2003 7:06:31 AM What happens if I use a stored procedure to add a caution
that is already associated with it, including the one
that is added to it....more >>
Table Locking Posted by James Napolitano at 10/18/2003 1:35:40 AM Is their a way other than security permissions to
completely lock a table. Once a record is inserted into a
table I do not want anyone to be able to delete any rows
or edit any columns. Is their a constraint that will lock
a column or complete table? I want the table to be able to
be locke...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |