|
|
|
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 Multi-table Stored Procedure With Aggregates Posted by mblacky2000 NO[at]SPAM hotmail.com at 9/21/2003 10:13:46 PM Hi
I'm in the process of creating a maintenance cost report for the Pulp
and Paper company for whom I work. The company uses a Maximo
maintenance management software with a semi-normalised SQL Server 2000
backend. This stores the data from which the report is to be derived.
All maintenance...more >>
Problems with xp_sendmail Posted by aerick at 9/21/2003 9:58:22 PM hi,
I'm having a problem with xp_sendmail.
I've tried the following from query analyser with sa as
the user:
exec master..xp_sendmail @recipients='aezza@msn.com',
@subject='test',@message='test message', @query='select
top 1 * from TestDB..TestTable'
with the following result:
ODBC ...more >>
Need your help with a non trivial T-SQL Posted by Tomer at 9/21/2003 6:15:20 PM Hi All,
Please help me to realize if I can do it with T-SQL
I have two Tables:
1. Books Ordered by person -> OB
2. Available books -> AB
I need to create a query that will return all the column of the AB table,
BUT only when All the books ordered by a person are available...more >>
Using master server/target server plan Posted by dre at 9/21/2003 5:05:10 PM I have made a sql server the master server and the others
that I have target servers. How do I setup those jobs that
were on the target servers on the master server? Do I
generate the sql script for each job on the target servers
and apply those scripts to the master servers master
databas...more >>
Method required to Combine Data from multiple tables Posted by Ron Sorrell at 9/21/2003 3:49:02 PM I have a requirment to take data from a large set of tables where the
total number of these tables may change on a regular baisis and
output into another table. All the tables willl have the same
columns. Frequency is being debated but it maybe as much as once per
hour.
Example
1) I ne...more >>
Double quotes in T-SQL string variable Posted by Sender at 9/21/2003 3:22:44 PM How do we store the double quotes in string variables. For example:
DECLARE @str char(100)
SET @str = "I LIKE "SQL SERVER" VERY MUCH"
Please correct the above SET statement
...more >>
Restoring multiple transaction logs on another server Posted by Andrew John at 9/21/2003 2:57:41 PM Dear knowledgeable people,
Is there a simple way to restore the latest full backup, plus all the transaction
log backups on to another server. I know you can on the same server, 'cause
all the backup history is there in MSDB. But how many people back msdb up
every 15 minutes?
Consider the...more >>
count() with Group By Posted by mmaxsom NO[at]SPAM citlink.net at 9/21/2003 2:28:43 PM Hello,
I'm having some issues with trying to get this query to work.
Hopefully someone can shed some light.
I have 2 tables that I'm trying to join.
Table 1 (tblRepresentatives)
rid rep_fname rep_lname sup_id
----------------------------------
1 john doe 100
2 j...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Illogical SQL Server Timeout? Posted by groups NO[at]SPAM lfsh.com at 9/21/2003 9:56:04 AM I have an rather interesting situation.
I'm building out a reporting application using ASP.Net and C#. The
app contains about 20 different reports that people can choose from
that they can then filter down by entering criteria specific to that
report. Additionally, the people using the sit...more >>
about transaction Posted by welyngj at 9/21/2003 9:52:51 AM create table Table1 (a tinyint)
go
begin tran
insert table1 values(1) ----successful insert
table1 values(1000) ----will report error
commit tran
select * from table1 ------one result succeed,another fail
I think that It should rollback all.but it doesn't.
can exp...more >>
Server performance is slow Posted by niitmalad at 9/21/2003 6:49:02 AM Dear Friends
We have a very small network which is having 20 local
clients and 5 vpn clients. For the separate task we have
created diffrent databases with requred views form main
database.
But from last month the performance of my server is going
down the response from the server is s...more >>
Passing Parameters to OpenQuery Posted by Octo at 9/21/2003 5:50:50 AM Hello,
I've a linked server connection to an Oracle DB and I
want to run a query from the SQL server but I need to
include some parameters that I get from some table in the
sql server and I will get the result in a cursor. It will
be something like this :
@MySQL = 'DECLARE MyCursor CURS...more >>
Color Coding Records Posted by Brennan at 9/21/2003 5:08:00 AM Hello:
I have a Access 2000 database that has a series of reports
that track the status of pending bids for an electrical
contractor. Based upon the value in the status field, I
would like to color code the individual record in the
Detail section to a particular color. I cannot use the
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |