|
|
|
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 how can this be done Posted by Chris at 12/14/2006 10:08:00 PM Hi,
I need to pass back multiple selection from an asp.net app datagrid and
update a table. How should I handle this? I get the values by looping he
datagrid, but, do I execute the update stored procedure on every iteration?
Or is there a way to pass all the selection at once to the sp?
Th...more >>
date difference in day,hours and minutes Posted by vanitha at 12/14/2006 10:06:01 PM hi,
i want to find the date difference in days,hours and minutes format.
please help me to solve this.
thank you
vanitha...more >>
Restore Sql Server 2005 db to Sql Server 2000 Posted by SalP at 12/14/2006 7:49:39 PM I have a database that was backed up on a SQL Server 2005 system. Is it
possible to restore the database to a SQL Server 2000 system?
...more >>
Scalability issue with Query .. Finding the MIN / MAX values into 1 row of data Posted by sloan at 12/14/2006 6:16:41 PM
I'm looking for alternate methods help ... on a query I have.
My mockup is this:
There are 3 stories , and each story spans several pages (in a book
presumably).
Lets say 'Little Red Riding Hood' is on pages 11,12,13,14.
I'm interested in the StartPage and EndPage for Little Red Riding Hood...more >>
error Internal SQL Server error Posted by Roy Goldhammer at 12/14/2006 6:11:30 PM Hello there
On my sql server
when i do Select with group by
i can't place it inside of another select
for example
select *
from (select ....
group by)
it gives me the error:Internal SQL Server error
what is this error and how can i solve it?
...more >>
How to Get Fields Specification (PK, FK, SA, UA, DD) Posted by Eric Jose E. Salip Ahmad, CoE at 12/14/2006 5:24:01 PM Good day everyone!
I would like to ask for help regarding table field specifications. I need to
get the specification for a table field. I can already get the specification
for PK and FK but there are some specifications that are needed in my project.
The table that I am referring to are t...more >>
writting to a text file from SP Posted by gigel at 12/14/2006 5:10:13 PM Hey all,
In sql2k5 is there any other way to write to a text file besides
using the FileSystemObject?
Because of the structure of the output file bcp is not an option.
thanks,
gigel
...more >>
Help on a SQL Query please Posted by Mike9900 at 12/14/2006 4:27:01 PM Hello,
I need a query which identifies invoices which have not been paid fully
using the following table please:
ARTable Schema:
--------------------
ARID (PK, int), CustomerID (FK, int), InvoiceID (FK,int), TransactionID,
ARDate (datetime),DebitAmount (numeric), CreditAmount (numeric)
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Trying to Understand the use of Temp Tables Posted by Elmo Watson at 12/14/2006 4:17:24 PM I'm trying to understand Temp Tables (creating them with a # at the first of
the name) - I've never done this before, but I've got one here at
work.....I'm using Query Analyzer to walk through it section by section, and
try to understand it.
However, I'm stuck at the creation of them - I get a...more >>
Inventory database design question Posted by Craig HB at 12/14/2006 3:34:00 PM I have developed an inventory database for restaurants, and have come across
a problem with the design. I have a potential solution, but want to check it
before I implement it.
The results in the database are calculated by restaurant, by StockPeriod
(which is a week, but could be something ...more >>
Table variable performance vs. temp table Posted by brandon.richter NO[at]SPAM gmail.com at 12/14/2006 2:36:31 PM Hi,
I've got an identical query, one with temp tables and one with table
variables that results in two completely different execution times.
The plans look virtually the same but execution time is around 2
minutes with the variables and less than a second with the temp table.
The plan shows t...more >>
How to temporary disable auto number columns and the reset them Posted by Maxwell2006 at 12/14/2006 2:05:08 PM
Hi,
We have tables with autonumber primary key and we need to insert test data
in them.
What would be the easiest way temporarily disable autonumber columns, load
test data and then enable again the autonumber columns?
Any help would be appreciated,
Max
...more >>
Cannot drop schema because it is being referenced by object 'SqlQueryNotificationService' Posted by mpaine NO[at]SPAM htxml.com at 12/14/2006 12:47:46 PM I am having difficulties dropping a user from a database because of
this error:
Cannot drop schema 'usr' because it is being referenced by object
'SqlQueryNotificationService-59d3e8da-c223-425e-afe7-480d074356de'.
I guess this could be that I had Query Notifications still open.
select * f...more >>
Stored procedure output Posted by Max at 12/14/2006 11:46:36 AM Hello,
I have a stored procedure that is taking two parameters and returning a long string. It seems that the string returned is not
complete and gets cut off towards the end. Is there a setting somewhere that I can change to be able to return a longer string from
the stored procedure?
...more >>
Concatenate output to return one string Posted by Henry Jones at 12/14/2006 10:50:32 AM I have a query that returns state abbreviations. The query is:
Select distinct R.RegionName from Regions R
JOIN InstXRegionXSubRegion S ON S.RegionID = R.RegionID
where S.InstID = 4
What gets returned is (5 rows):
CA
AZ
OR
WA
DE
What I would like returned is: CA AZ OR WA...more >>
UDF in derived table Posted by Brian Ackermann at 12/14/2006 10:28:19 AM Hi all,
I've got a question. I've looked through the archives, but didn't have
any answers jump out at me.
Here's the situation. I've got a simple UDF which returns the last N
months of 'usage' for a part. What I need to do, is to collect that
data back into my query, to build a list of ...more >>
Completely separeate data and deadlock Posted by Pawel Pabich at 12/14/2006 9:30:14 AM Hi,
Within one transaction I load the whole graph(foreign key relations)
of objects from my database(sql server 2005). Then I traverse the graph
and delete them one by one. I know it is not the fastest way but I have
to do this in this way. When I delete only one graph at a time there is
no ...more >>
ObsoletedSprocException is being thrown Posted by Tom at 12/14/2006 7:45:43 AM I have run into a strange problem with SQL Server 2000 (SP4). I am
calling a fairly simple stored procedure that selects a set of data
from one table based on several parameters passed in (combination of
varchar and int).
The problem is that everytime I execute this procedure, SQL server
ret...more >>
Profiler problem database name Posted by Prasad at 12/14/2006 5:17:50 AM Hi,
I am profiling the Object:Created event, but when I execute the
Create Table,View or SP the database name shows a garbage value.
I have SQL Server 2000 sp4 installed
Any body has any idea how to get the database name.
TIA
Prasad
...more >>
Padding Posted by sara at 12/14/2006 3:57:02 AM Hi All,
Could you please help me with this question:
I have a table which has records in the form of (date datetime ,number
int).
for example (only some records):
jul-12-2004 45
jul-14-2004 49
jul-15-2004 67
jul-19-2004 78
.....
I wonder how can I put the value 0 for dates missing, s...more >>
Special View Posted by Kurt at 12/14/2006 3:37:24 AM Hi,
I wish to know if it is possible and how can I create a view which
represents values for each date during a period, knowing that I have
only intermediate date.
For a better comprehension, I gonna present you an example of what
I'd like to do.
Here is my table:
Date value1 ...more >>
Cut any space in string Posted by Luigi at 12/14/2006 2:46:45 AM Hi all,
I have a string variable, like this one:
declare @a nchar(180)
set @a = 'aaaa bbbb cccccc ddd'
Ho can I cut all the spaces in this string, so to obtain
@a = aaaabbbbccccccddd'
?
Thanks a lot
...more >>
SQL2005 blocking Posted by simonZ at 12/14/2006 12:00:00 AM SQL2005 server was blocking, running at 100% of processor, and the program
didn't work.
So I go to activity monitor to see, hat is going there.
When I opened the only active proccess on my database, I saw the following
TSQL command batch:
create table #tmpDBCCinputbuffer ([Event Type] nvarc...more >>
Source Safe Posted by Sugandh Jain at 12/14/2006 12:00:00 AM Hi,
We desperately need to have some Source Control for version maintaining and
to enable quick replication of chenges done to development server to say
staging server or QA server... or a production server
Any tools, that can plug in to sql server,
as vss or MicroSoft Source Safe integra...more >>
List and Meaning of all the Values Error_Number() Function can provide. Posted by Sugandh Jain at 12/14/2006 12:00:00 AM Hi,
I need a list of all the errorNumber which Error_Number() function can
return from the Stored Procedure.
And each of the errorMessage associated with it.
Following is the versions of related sql softwares in use..
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Anal...more >>
Duplicates in query Posted by luna at 12/14/2006 12:00:00 AM How can i stop duplicates in this query ?
SELECT RecordType.ProductID, Personal.Surname1, RecordType.Type,
Sales.PackIssued, Sales.PackIssuedBy, Sales.Consultant,
SalesAppointments.Rep,
ResponseType.ContactMethod + N' ' +
ResponseType.HearAboutUs + N' ' + Response...more >>
Limiting what gets entered into a field Posted by Robert Bravery at 12/14/2006 12:00:00 AM Hi all,
I somehow understand that this can be done, AS you notice I am still new at
this.
I have a single character column, that will store either "D", or "C". How
can I make sure that this is the only options available and the only values
that may be entered.
Thansk
Robert
...more >>
use sP parameters Posted by Roy Goldhammer at 12/14/2006 12:00:00 AM Hello there
i've build store procedure that gets string parameter and use it in dinamic
sql server:
CREATE PROC sto
@letters varchar(100)
AS
DECLARE @str varchar(8000)
SET @str = 'SELECT .....
FROM tblClient C
JOIN (SELECT ClientID
FROM tblClientLan...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |