|
|
|
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 Sub query question Posted by Ganesh at 6/4/2005 11:34:14 PM I want to run a correlated sub query something like this
Select * from master m
where m.key
exists
select top 1 det1, det2
from detail d where m.key = d.key
Now i want to return the det1 and det2 field values with all master table
values
how can i do this
Thanks
...more >>
SQL Server - SQL query variable Posted by Mike at 6/4/2005 8:45:10 PM Running SQL Server 2000 SP 3
I am trying build a SQL server query. See below for partial SQL:
SET @sExec = 'SELECT DISTINCT Price_Quote_Package.Price_Quote_Package_SID,
Price_Quote.Price_Quote_SID, Price_Quote_Package.Price_Quote_Package_Name,
Custom_Pricing_Customer_Registration.Customer...more >>
problem in parameterized queries to avoid Sql Injection Posted by andy at 6/4/2005 4:30:01 PM I tried to use parameterized queries to avoid Sql Injection attack but in
case I have to generate script based on conditional statement .. things got
out of control ...
The following link wasn't that much helpful...
http://dotnetjunkies.com/WebLog/chris.taylor/archive/2004/10/13/28370.aspx
...more >>
Making a Non Primary key a unique column Posted by RD at 6/4/2005 1:41:12 PM I have a table in which a column that is not part of the primary key must
contain data that can not be duplicated in the same column in another row
but it should not - for other design reasons - be the primary key.
I created an index on that field in the table and in the properties for that
in...more >>
sysdepends not showing a stored procedure Posted by Keith G Hicks at 6/4/2005 12:13:41 PM I have a stored procedures that make use a couple of tables (it runs just
fine I might add). Why would that procedure not show up in the sysdepends
table? It doesnt' show any of the dependencies for this procedure. I even
dropped the proc and recreated it to see if that would do the trick. One o...more >>
huh? Posted by rodchar at 6/4/2005 11:46:01 AM hey all,
i have 2 fields in a single table
field 1 is a parent id number
field 2 is a parent id number reference number
For example:
0,0
1,0
2,1
3,1
4,2
how do i get a report like the following
Childs related to Parents
Parent 0:
has Child 0
has Child 1
Parent 1:
has Ch...more >>
Sql Server Secure Connection? Posted by matthias s. at 6/4/2005 10:53:20 AM Hi there,
I'm planning to write a web-app which will be utilizing an SQL server.
The provider hosting my app runs SQL Server 2000 and I've got access to
one database, which I can use for my application.
Now I've tested connecting to the server from my devbox at home using
Query Analyzer ...more >>
newbee question on function Posted by Danny Ni at 6/4/2005 10:43:47 AM Hi,
I created some functions in SQL server 2000 server. Every time I use the
functions I created I have to prefix them with dbo., say dbo.myFunction. Is
there a way to get around it?
TIA
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Given a date I need to get the month end date. How do I get this ? Posted by Peri at 6/4/2005 8:57:35 AM Dear All,
Is there any way in SQL server to get the month end date given a date.
That is : If I give 15/05/2005 it should give me as 31/05/2005, and If I
give 01/06/2005 it should give me as 30/06/2005.
Is there any in-built funtion to achieve this ?
Thanks and Regards,
Peri
...more >>
Clean up a table & save to another table Posted by MGFoster at 6/4/2005 4:56:36 AM I'm trying to filter and update the table AllAgreements (below) by
moving parts of each row into appropriate tables and deleting redundant
rows. This table is just a scratch table used while importing old data
into a new DB.
The situation: A company supplies credits to its customers (othe...more >>
Regular expression in SQL 2000 Posted by Guhanath at 6/4/2005 4:27:01 AM Hi All,
We are migrating a web application from oracle to SQL Server 2000.We have
used regular expression extensively in Oracle.
Is it possible to use Regular expressions in SQL 2000 queries??
--
Guhan...more >>
Instead of trigger to increment PK Posted by Ant at 6/4/2005 3:52:04 AM Hi,
I'm trying to increment the PK col of a table by using an instead of insert
trigger. (I don't weant to use the identity col property as if a row is
deleted, the rows must remain contiguous 1,2,3 etc) I'm expecting that the
trigger finds the last PK value & increments it, then inserts it ...more >>
A Bug With Running Total Query? Posted by Nathan at 6/4/2005 2:28:02 AM Using SQL Server 2005
Query Result From 1 Table with 3 Cols:
Date Amount RunningTotal
6/1/2005 730.0000 730.0000
7/1/2005 415.0000 830.0000
8/1/2005 415.0000 1245.0000
9/1/2005 415.0000 1660.0000
10/1/2005 415.0000 2075.0000
11/1/2005 415.0000 2490.0000
12/1/2005 415.0000 2905....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |