|
|
|
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 Data Migration Posted by Vanitha at 9/11/2005 11:51:03 PM Hi friends,
I have changed the existing database scripts by adding primary key and
foreign key constraints.
Now i have created the new structure, I want to mograte the existing data
into the new structure. There is a chance for duplicate records and also
records that does not satisfy re...more >>
varchar data Posted by Chandra at 9/11/2005 10:49:02 PM Hi,
I have the following statements in my stored procedure.
declare @charstring varchar(8000)
set @charstring = 'select '
--cursor Loop starts here
set @charstring = charstring + @appendstring
--cursor loop ends here
--finally I'm printing the @charstring
print @charstring
...more >>
Transpose of Rows into columns Posted by Chinnappa at 9/11/2005 9:55:03 PM Hai,
My requirement is I want to convert rows into columns. So I used cursor
fetch single row.
The fetching operation is affected on a particular table while creating
more than one index on that table. By removing index fetching operation is
working fine.
I want to know whether the...more >>
regarding 'with (holdlock)' lockhint Posted by hari krishna at 9/11/2005 9:46:01 PM hi,
I have two stored procedures which updates and inserts in to same table
after some manipulations of data.
But the data it takes from different tables in this two stored procedures.
if i put with(HOlDLock) in these two storedprocedures will it give any
problem when it is processing. becau...more >>
Redirect Name Pipes Posted by john at 9/11/2005 9:31:05 PM My DB is using SQL 7. Clients connect via Name Pipes (Client Configuration
Utility).
I am planning to move the DB to another (SQL 7) machine, and looking for a
fast and simple way to change (SQL) server name value in the Name Pipes
string on all (or selected) clients.
NT4 & 2000 domain wit...more >>
ORDER BY Question Posted by rythm at 9/11/2005 8:22:02 PM Item Quantity
I1 10
I2 7
I1 5
Assume that is the Data.
I want it ordered by Quantity FIRST and then show the same Item again
if it exists.
How can I display it in this way
Item Quantity
I1 10
I1 5
I2 7
P.S Please do not say "ORDER BY Item, Quanity DESC"...more >>
ROLLUP with GROUP BY and Categories Posted by rythm at 9/11/2005 8:16:01 PM I am trying to display Hieracrhial Data. I am running into trouble when I try
to display a PRODUCT multiple times when it has different PRICE.
Please read below to see what I mean:
tbl_Category:
CategoryID ParentID Category Lineage SortOrder
1 0 All 1 0
2 1 Beer 1.1 1
3 2 Domestic 1.1.1 ...more >>
Script to Populate DB with Sample Data? Posted by jpuopolo NO[at]SPAM mvisiontechnology.com at 9/11/2005 12:58:58 PM All:
Is there a tool out there that will construct DB creation scripts that
include taking the source data from the tables can carrying the info
over to the script? The goal here is for developers to be able to check
out the DB creation script (the DDL that creates tables, stored proc,
etc.) ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
This newsgroup q Posted by Thom Anderson at 9/11/2005 9:21:22 AM Is this NG going to be the location for public (not beta) SQL Server 2005
programming questions or has another been started?
...more >>
no count of zero Posted by Buz at 9/11/2005 7:46:01 AM Count doesn't seem to be returning zero when there are no records. I've
checked my joins. I've tried ISNULL(Count(*), 0) [which I've NEVER had to do
before] to handle a null count (still no 0). It's a new machine to me, and
I'm wondering if there is some system setting I need to make sure coun...more >>
C# Interview question help Posted by programmerforknowledge at 9/11/2005 7:44:40 AM Hi All
I am fresh college graduate who has done C and C++ during college
times.After that i had done a C# course from one of our local computer
institute.The course is BCM which ran for 1 year.But now when i am
looking for job the questions asked in interview are really very very
weird and does...more >>
how to get the first 10 max salaries of employees out of say 100 employees Posted by joshithay via SQLMonster.com at 9/11/2005 1:23:02 AM hi,
i got a small pbrobs
i want to get first 10 max salaries out of 100 employees from my_tbl(ex)
i tried by writing subqueries..but i need a simple query to get it...more >>
How does SQL manage the requests it receives? Posted by Meir at 9/11/2005 12:00:00 AM We have a web application running for about 3 years in 20 different
installations. This week we started to have a problem in one of our
installations.
We are running SQL Server 2000, there is a stored procedure that calls to
other nested stored procedures, in one of the nested stored procedur...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |