|
|
|
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 August 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 Challenge me! Posted by Pierre at 1/25/2004 10:16:32 PM I need interesting / challenging SQL problems. What's the most difficult problem with an elegant solution that you have
Here's an example of a problem I found to be mildly entertaining
Tables
Client - ClientID (int), ClientName (varchar
Order - OrderID (int), ClientID (int), OrderDate (datetim...more >>
Error in restore Posted by Yass at 1/25/2004 9:26:25 PM Dear Newsgroup,
I am using sql server 2000 over win 2000 server with service pack 4.
I have been given a back up of a database (I have tried both from T-SQL and
Enterprise Manager)
T-SQL
RESTORE FILELISTONLY
FROM DISK = 'c:\A.bck'
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
...more >>
Left Outer Join Problem Posted by David Smith at 1/25/2004 8:35:15 PM Hi, although I'm sure I should know the answer to this one, I'm writing a
query that's posing a problem. In essence, I need to list all products and
what was sold during a particular period. The three tables are STOCK,
INVOICE and INVOICE_ITEM.
Stock is linked to INVOICE_ITEM through stock_cod...more >>
Cross Tab queries Posted by venkata at 1/25/2004 7:55:20 PM Hello SQL Gurus,
There are 3 tables x ,Y AND XY
i.e.,
X is one Dimenstion table
Y is another Dimension table
By Joining the Row and the Column dimension
table we get the cell which we need to check
in the XY table whether that data exists or not
If it exists then display the descript...more >>
Get column total on same line Posted by Steve Beach at 1/25/2004 7:48:38 PM Is there a better way of doing this? I thought there might be a better way
to calculate the JobTotalCost rather then basically running the same query
twice.
Note: POTotalCost is actually a SUM(xxxx) of some other fields. I simplied
this example a bit.
Thanks
================
Sample Q...more >>
How to create/remove instance by programming Posted by Trojan at 1/25/2004 7:46:05 PM Hi,
Is there any way to create instance in SQL 2000 by VB .NET or scripting also to remove or uninstall it?
Thanks you very much,
Mich...more >>
Regular Expressions Posted by A.M at 1/25/2004 7:00:01 PM Hi,
Is there any Regular Exressions support in SQL Server ?
Thanks,
Ali
...more >>
current datetime in trigger Posted by T. Wintershoven at 1/25/2004 3:12:14 PM Hello all,
I'm new to sql programming and i cann't find the answer to a small problem.
I've seen some examples but nothing works.
Maybe one of you can help me with it.
I have
- a database called DBTEST
- a table called tblNAW
- one of my fields called LASTMOD (tinydatetime)
I would lik...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Two questions Posted by Anirban at 1/25/2004 2:31:54 PM 1. What is the difference between procedure and stored procedure ?
2. Thouh we have advantage of stored procedure why do we use query ?
Thanks,
Paul
...more >>
trigger after update problem Posted by yusuf tulgar at 1/25/2004 2:17:23 PM look at the trigger (on part 2).. when I update data on table (look at on
part 4 ) only trigger works for if HAREKET_TIPI=4
none of if HAREKET_TIPI=1,if HAREKET_TIPI=2,if HAREKET_TIPI=3 conditions
works
and opininon ?
big thanks before answer
1-------------------------------------------...more >>
character limitations in SQL2000 Posted by Doug at 1/25/2004 1:29:03 PM I was wondering the best way to maintain a complete
description that is being passed to me via XML from a
thrid party site. This site allows users to use html in
formatting their descriptions which creates obviously more
characters then a standard text description.
Therefore, in some o...more >>
DBCS to UNICODE via COLLATE Posted by Vlad at 1/25/2004 12:45:13 PM Hello all,
The following code converts DBCS to UNICODE
----start
DECLARE @ToDecode VARCHAR(10)
SET @ToDecode = CHAR(150) + CHAR(123)
DECLARE @Decoder TABLE (Decoded VARCHAR(10) COLLATE Japanese_UNICODE_BIN)
INSERT @Decoder VALUES (CAST(@ToDecode AS VARBINARY(10)))
SELECT
@ToDecode [ToD...more >>
Filtering records in a stored procedure using IN keyword (SQL7) Posted by Vince C. at 1/25/2004 11:05:42 AM Hi.
I'd like to use a stored procedure to filter records from an SQL 7 database. It
should have an argument that allows me to pass either a single value or a
comma-separated list of values. The argument should be used in a WHERE clause:
Create Procedure Filter( @Filter varchar(256) )
As
...more >>
returning data from SQL Server to ASP.NET page Posted by Rod Snyder at 1/25/2004 10:50:43 AM I'm trying to set up an asp.net (vb.net) that will allow a user to
insert/update a bio/profile. I wanted to create a SQL Server 2000 table that
includes their contact info and bio info. However, I'm not getting SQL
Server to accept more than about two paragraphs of info. I've tried the
datatypes...more >>
How do I format an int + tinyint datatype to a formatted string Posted by Top Gun at 1/25/2004 10:10:00 AM I would like to accomplish the following in a view:
Two columns such as:
BatchID (type int) = 54321
BatchSeq (type tinyint) = 1
View will return a formatted character string concontenating the above
as 00054321-001
IOW, I want to add leading zeroes to and fixed lengths in t...more >>
Performance Monitor Counters Posted by Mike at 1/25/2004 8:22:51 AM
I would like to insert my Windows 2000 Advanced Server
performance counters into SQL Server 2000 database every
hour. How would I set up Windows 2000 Advanced Server to
write out the performance monitor output to a .csv file.
Then I could set up a job to DTS the file into the SQL
Server...more >>
Help with Expanding on an existing query Posted by Peter Newman at 1/25/2004 4:56:05 AM i am running a query for an invoice generating appplication.
The query below works well, but i m trying to expand on it slight
The 'sum(c.BHYear_transcount) As Counts' returns the number of transactions
recieved in the given month, however it is counting two types of transactions
The type of t...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |