|
|
|
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 Insert data to crossib qurey Posted by Roy Goldhammer at 8/23/2003 10:52:46 PM Hello there
I have a query that i need to enter to table
The query is crossib (Pivot)
and the data should enter for two tables: tbl1(ID - primary key, other)
tbl2(ID- Foreign Key from from tbl1, ColName - the columns on the crossib
query) both of them are Primary key and data
How can i...more >>
nText select Posted by RDufour at 8/23/2003 8:15:46 PM Got a field with ntext that contains richtext format data Need to make a
query that selects all the records that have no text in it.
The field can be Is NULL or it can have the rtf in it but no characters that
would be visible when bound to a rich text box in a user interface.
Select where f...more >>
I need the result set of SP-1 in SP-2, How to get it T-SQL? Posted by joe at 8/23/2003 8:13:29 PM I need the result set of SP-1 in SP-2, How to get it T-SQL?
An SP is written a long time back, and I can not modify
it, but I need the result to be used in another Stored
Procedure (SP) to do some processing work.
For example I need something like this:
Create Proc SP1
As
Select ...more >>
SQL Error Message Posted by sqlfan at 8/23/2003 6:34:16 PM Is there a way to return the error message along with the
error number to the client application?
Thanks...more >>
tutorial sites Posted by marwan hefnawy at 8/23/2003 5:47:23 PM Would you please tell me some sites that give SQL tutorials (especially
programming SQL) for beginners and for advance level. Thanks in advance
...more >>
CASE or IF/ELSE Posted by Bent Lund at 8/23/2003 5:12:47 PM
Hello,
I'm working on some procedures where I need conditional execution of
some code.
The main part of the procedure:
DECLARE
@CUT_NO [int]
--Get the current @CUT_NO from underlying tables.
select @CUT_NO = ......
-- The problem: If @CUT_NO = 0 I need to execute some code, and...more >>
Program that inserts values? Posted by Jason Davis at 8/23/2003 5:08:39 PM Is there a program that insert million of random values into mssql
databases?
I'm looking for a stress test and indexing improvment under heavy load and
millions of rows.
...more >>
do I have to have a PK/identity? Posted by Jason Davis at 8/23/2003 4:06:42 PM I have 2 tables - Products and Categories
I also have a ProductsCategories table that lists certain product(s) in
various categories.
for example:
Product_id Category_id
1 5
1 6
2 5
3 7
4 7
Do I need to have a PK/identity for this table? i.e - ProductsCategories_id
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Newbee Question Posted by Scott Holmes at 8/23/2003 3:22:27 PM I can do basic queries, but I have run into a situation where I can't find
an example to start from.
Two Tables A and B They have a one to one relationship on a field named
OpportunityID. I need to update a value in Table B based on a value in
Table A.
So, in plain english I want to Locat...more >>
Updating SELECTED rows Posted by Jason Davis at 8/23/2003 2:11:25 PM Is there a way to UPDATE a specific column when records are selected?
For example, I sometime use this:
SELECT TOP 10 * FROM tbl WHERE col_id IN (@Rnd_list_of_value)
How can I instantly update column (col_select_count) with +1 for all
selected values? can I do it on the same statment via t...more >>
UPDATE col=col+1 not safe? Posted by Jason Davis at 8/23/2003 2:08:42 PM Hi there,
I've heared that incrementing column counter like this:
UPDATE table set col_count=col_count+1 WHERE col_id=10
is not safe? meaning I can "lose" counts on multiple calls.
Is that true? what is the proarbility of that to happen? and is it another
way of doing it without losing coun...more >>
SQL help needed Posted by Ajit at 8/23/2003 12:12:26 PM There are 2 tables:
CREATE TABLE [dbo].[T1] (
[T1] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T2] (
[T2] [int] NULL
) ON [PRIMARY]
GO
The values in both the tables are as follows:
Table T1:
T1
---
3
7
Table T2:
T2
---
1
2
3
4
5
6
7
8
9
10
11
12
13
...more >>
GROUP BY Problem Posted by Scott at 8/23/2003 10:39:16 AM I'm having trouble trying to write a select statement that would make my
data in in Figure 1 look like Figure 2. Being that Shift1,Shift2,Shift3
aren't fields, but rather data from the Shift field, how can I achieve this?
(I omitted extra joins, etc. for simplicity)
FIGURE 1 (below works fine)...more >>
Multiple Cascade Flaw in SQL Server 2K Posted by archertravis NO[at]SPAM yahoo.com at 8/23/2003 9:57:51 AM I keep running into this, and every time I do, it bugs me more.
Example tables:
Map (PK MapUID)
Sector (PK SectorUID, FK MapUID)
Boundary (PK BoundaryUID, FK MapUID)
SectorBoundary (PK SectorBoundaryUID, FK SectorUID, FK BoundaryUID)
To avoid confusion, this represents: "A map is divided i...more >>
Large recordsets ... Posted by Michael Tissington at 8/23/2003 9:27:19 AM This is more of a design / implementation question.
I'm writting some code that needs to implement a number of interfaces that
can be called by an external application to popualte a recordset and scroll
through it. - A guess a bit like how we use the ADO api.
The recordsets can containe betw...more >>
Complex and Dynamic SQL Query ----------Please help Posted by Joe at 8/23/2003 12:48:09 AM Dear Friends,
How do write the below dynamic update Query? I am new to this SQL Query.Its
very very urgent requirements.
If anyone knows please help me the below SQL query.
I would appreciate any help.
UpdateEmployee()
FieldName datatYpe
EmpName - string
EmpNo - int
Sex ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |