|
|
|
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 Query Questions Posted by LacOniC at 3/25/2005 8:58:26 PM I have following query to update database. But it's not complete.
1.) If FORUM_MEMBERS.M_AGE value is empty that user will be added to all forums's access list. Big problem. =)
2.) If user is exist in FORUM_ALLOWED_MEMBERS table, this query duplicates FORUM_ID for that MEMBER_ID. Another
prob...more >>
Shape Command in SQL Server - Need to have more than one child set. Posted by Peri at 3/25/2005 7:27:24 PM Dear All,
There is a shape command in sql server with the following example
SHAPE {SELECT au_id, au_lname, au_fname FROM authors}
APPEND ({SELECT au_id, title FROM titleauthor TA, titles TS
WHERE TA.title_id = TS.title_id}
AS title_chap RELATE au_id TO au_id)
Can you ...more >>
Combine Multiple Results into 1 RecordSet Posted by Stuart Shay at 3/25/2005 6:37:37 PM Hello All
I have the following SPROC Below which I want to return the results of the 3
Querries in a single record Set which I can use in my webapp
/********************************************************
CREATE PROCEDURE dbo.sp_StatsSQLVersionCount
AS
SELECT Count(*) As Total FROM...more >>
perform all the actions in one pass rather than take serveral calls to server Posted by E B via SQLMonster.com at 3/25/2005 6:03:45 PM My application has one web form where admin can add as many users as
desired and at the end when he press SaveChanges I want to add all of them
to database, There should be some way to pass arrays to stored procedure..I
am looking for it or something similar to this....
I want to pass an array...more >>
Joining from two different tables Posted by itmex at 3/25/2005 5:09:04 PM
Hi all,
I have a test sales table with 12 records showing sale_id, sale_date,
prod_id, cust_id, unit_price, qty. Then I have two other tables,
customer and products from where I would like to extract product
description and customer name. When joining the sales the table with
either custom...more >>
Please help on Posted by Sathian at 3/25/2005 4:26:54 PM Dear Friends,
When I tried to start Micosfot Search Service on Windows 2000 Server with
SQL server, the following message was obtained.
"Could not start Microsoft Search Service on Local Computer. Error 3: The
system canot find the path specified."
When I tried to apply SQL2kSP3 t...more >>
Audit Records Posted by Robert E. Flaherty at 3/25/2005 4:08:42 PM One of the requirements for an application I helpping to develop is
providing audit records of add, updates and deletes including the user who
added, updated and deleted. This application is being sold commerically to
users who have different requirements including not needing audit records.
...more >>
Conditional SQL Query Posted by epigram at 3/25/2005 3:57:19 PM I'm learning SQL Server 2000. I have two tables that I need to join, table
A and table B. The result set is a little tricky though. Table A has a set
of columns that are duplicated in table B. The reason is if there is no
data in these columns in table A, then that means that the data "def...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Stored Procedure Question Posted by TJBowens at 3/25/2005 3:56:46 PM Are there any commands that can be used to dump results to a flat file, or
does this need to be controlled by an external app ?
Thanks in advance...
...more >>
loading csv to database Posted by Vince
Hi there!
I have some csv files which contain sample data to be loaded into a
database..
Well , do you know such a tool to do so and specially accessible tool
from vbscript to load my data??
thanks a lot :)
Vince...more >>
question about guest account in model database... Posted by === Steve L === at 3/25/2005 3:29:25 PM i disabled most guest accounts in sql server soon as i set it up.
excepts the ones in master and temp dbs. but the guest accout in model
database says 'via group permission' and i couldn't delete it. should i
just leave it or do something about it? (if so, how). thank you
...more >>
Temporary Tables as Parameters Posted by Robert E. Flaherty at 3/25/2005 3:01:38 PM From within SQL Server 2000, how do you send data from a temporary table or
a table variable from one stored procedure to another?
...more >>
Adding an identity column solely for the benefit of the clustering index? Posted by Joergen Bech
Let's say I have a table containing string values:
ValueTable:
----------------------------
ValueID guid
ParentID guid
SomeValue nvarchar(1000)
SomeOtherValue nvarchar(1000)
with indexes on
ValueID (clustered)
ParentID, SomeValue (non-clustered)
ParentID, SomeOtherValue...more >>
How to ROLLBACK TRANSACTION on client level Posted by E B via SQLMonster.com at 3/25/2005 2:32:12 PM Suppose i connect to db (SQL Server) from the client (.NET) and call to
some store procedure, in this sp i start transaction (BEGIN TRANSACTION)
and before COMMIT or RALLBACK an error happen that imidietly stop the
execution of stored procedure, In the client i cacth this error but what
about an...more >>
pivot question Posted by Steve H at 3/25/2005 2:29:36 PM Hello,
How can I build a table that pivots Date and Qty, but uses Price from first
month?
Have this:
Part Price Date Qty
1A 5 1/05 10
1A 6 2/05 20
1A 7 3/05 30
1B 2 1/05 10
1B 1 ...more >>
SAN Connectivity Issue Posted by Mark at 3/25/2005 2:11:04 PM I have SQL 2000 SP3a EE on Compaq hardware. I have all user data and system
data on SAN Drives. I am noticing that even though SQL Server is set up as
automatic on start up still it doesn't stat the server automatically. I have
to manually start SQL Server service after the machine is booted u...more >>
Using bigint in bitwise operations Posted by Igor Marchenko at 3/25/2005 1:11:03 PM I trying to use bigint in bitwise operations on SQL Server 2000 SP3.
Following stetment generates an error :
select 2149582848 & 1
Server: Msg 403, Level 16, State 1, Line 1
Invalid operator for data type. Operator equals boolean AND, type equals
numeric.
According to the following tab...more >>
add seconds to time. Posted by Fab at 3/25/2005 1:02:19 PM Hello how would i add 5 seconds to this value in a select statement?
2005-02-16 04:12:44.000
...more >>
Grouping on time Posted by Fab at 3/25/2005 11:51:34 AM Hello,
I have a table with 2 columns, time and amount. I want to be able to group
by an interval and sum the amount see below of a sample of the data.
Time Amount
2005-02-16 05:41:00.000 100
2005-02-16 05:41:01.000 100
2005-02-16 05:41:02.000 100...more >>
CURSOR FETCH STATEMENT IS HANGING Posted by rajeshlh at 3/25/2005 11:29:02 AM Hi All,
I have a stored proc that uses a cursor to iterate over the join resultset
of 5 tables. After fetching roughly 12,000 records and running for about 30
minutes, the next FETCH statement inside the WHILE loop hangs. This happens
consisently. I tried to do a commit / checkpoint after ...more >>
A question about bulk insert and partitioned views Posted by Sean Shanny at 3/25/2005 11:23:54 AM To all,
I posted this question in the server list and that may not have been the
appropriate place so I am posting here.
I have built a partitioned view exactly as described in BOL. I can insert
data into just fine and it places the values in the correct sub-tables
according to the check c...more >>
tables in stored proces Posted by Frank at 3/25/2005 11:15:17 AM Hi,
I need an overview of tables used in stored procs. Does anyone have a nice
select statement to give me that info?
Thanks in advance
Frank
...more >>
How can we understand ? Posted by hoz at 3/25/2005 10:52:21 AM How can we understand
- which stored procedures executes slowly ,
- which stored procedures needs more memory ,
- which indexes has much more mb
- which indexes are not used
- which indexes stay in memory
thanks for your answers
...more >>
"Order by" by parameter in stored procedure Posted by Carlos Santos at 3/25/2005 8:41:03 AM I would like to pass the name of a column to a stored procedure, so the
result of the query would be ordered by that column.
I tried this:
CREATE Procedure ProductsByTab
(
@TabID int,
@Order nvarchar (50)
)
AS
SELECT
*
FROM
Product
WHERE
TabID = @TabI...more >>
Locking Performance Problem Posted by moonliver NO[at]SPAM gmail.com at 3/25/2005 8:39:19 AM I have stores that communicate with a central database table. they do
updates every day with a stored procedure called sp_UpdatePriceTable.
its an average of 4000 records and takes about 30 seconds. If two
stores update at the same time. It takes like ten Minutes. What can I
do to fix this probl...more >>
user defined functions in sql2000 Posted by sergiu at 3/25/2005 8:35:02 AM i have a very strange problem and somebody might help me :-)
I have a multistatement user defined function and from time to time it
starts returning wrong results and what i mean by that is that i run the
function get the wrong results, i take the source and create a new function
that return...more >>
Default settings for strings and numbers Posted by bagman3rd at 3/25/2005 8:11:07 AM How do I change the default settings on SQL Server so that; when I create a
new table in EM or import a table from Excel, I will always get varchar(100)
for any string instead of nvarchar(255), and change the default for numbers
to numeric(19,6) instead of float(53)?
Thanks.
Archer...more >>
Save Excel file in the text field Posted by Test Test at 3/25/2005 7:58:03 AM I need to insert Excel file (the whole file alongwith data) into a text
field in the SQL table. Is that all possible (through VB scripting or
????)
Any ideas? Thanks!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
deleted object for trigger Posted by Sean at 3/25/2005 7:23:02 AM Is 'deleted' object available for a table with Identity field? I try the
scripts as following. It gets me the error "Invalid object name 'deleted'".
How can I bypass it? Thanks.
CREATE TRIGGER dbo.myTable_Update ON dbo.myTable
FOR UPDATE
AS
SET IDENTITY_INSERT dbo.myTable_History ON
GO
...more >>
Query needed Posted by Satya at 3/25/2005 6:03:02 AM Hi All,
I have a table
Task(
idTask int primary key,
sTask varchar(60)
)
with the following data.
idTask sName
---------------------------------
1 B
2 A
3 C
4 B
5 ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |