|
|
|
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 Can any one help me with this SQLXML 3.0 SP3 Problem? Posted by Grant Smith - eNVENT Technologies at 11/12/2005 11:32:16 PM I'm having a problem with SQLXML. I have written a small VB.NET
application to manipulate xml files and import them into an SQL Server
database.
Every time I run the application, the import fails. The error log
contains the following xml:
<code>
<?xml version="1.0"?>
<Result State="F...more >>
Stored Procedure Problem (Bug?) Posted by Gary Harding at 11/12/2005 8:57:47 PM Hello
We're using SQL Server 2000 SP3 on Windows Server 2003 (no SP) with 24
Windows XP Pro SP2 clients.
We have a stored procedure which allocates sequence numbers from a table.
It's called frequently, and concurrently, by code running on clients and on
the server.
Normally, it works fine...more >>
select 2/5 Posted by Hassan at 11/12/2005 8:10:04 PM How can i get 0.4 and not 0 as the output ?
...more >>
Variant to Decimal type Posted by Scott at 11/12/2005 4:10:16 PM My code returns 48 because I'm setting @mypercent as an integer. I need it
to return 1 decimal point and return 48.2.
I tried different decimal types but got errors. What should my final line of
code be to return 48.2?
CODE:
declare @myvalue1 as int
declare @myvalue2 as int
declare @myp...more >>
What does Index Tuning Wizard consider? Posted by querylous at 11/12/2005 4:05:03 PM If index tuning wizard is used to analyze a workload (i.e., a trace), does it
consider the frequency with which queries occur?
I am about to run the wizard on a mid size database, with several hundred
users. If running a trace during active use, the max number of queries
(~32,000) for the t...more >>
automagical calculation of a field value Posted by Jan Rösner at 11/12/2005 1:56:24 PM Hi All,
I have a table "AggregatedSales" which has a column called
"AggregatedSales.YearSum".
This column should contain a sum which can be derived directly from another
table called "Sales" by summing up all values of "Sales.Price" WHERE
"Sales.Year" = 2005.
Is it possible to have MS SQ...more >>
Executing stored procedure against openxml rowset Posted by CJ at 11/12/2005 10:51:55 AM Im trying to run a batch user account process where a chunk of xml
would define user account info to create a set of new accounts against
one database call. Something like this..
<accounts>
<account user="testAcct1" pass="testPass1" type="LN"/>
<account user="testAcct2" pass="testP...more >>
INSERT INTO...WHERE (copy rows from table into same table) Posted by GW at 11/12/2005 10:48:12 AM Trying to copy rows into new rows but changing the first column id to
sNewASMM which is entered by the user.
There are several rows with the sSourceASMM ID.
Table is indexed on inkasmm, inkprod.
sSQL = "INSERT INTO INKT" _
& " (inkasmm, inkprod, inkcqty)" _
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Convert DateTime to NVARCHAR Posted by refdk at 11/12/2005 9:03:14 AM Hi,
My test table looks like this:
1 Id int 4 0
0 DateTimes datetime 8 1
0 DatoTid nvarchar 14 1
With the following content:
1 15-10-2005 10:22:00 15102006102200
2 16-10-2005 11:16:00 17102005111600
I would like to show the records that are different, but I...more >>
create new table from base table Posted by barcode NO[at]SPAM dds.nl at 11/12/2005 4:48:43 AM Hi,
I am trying to create a new table from an existing base table. The base
table isn't normalised in any way. The table was given to me and that's
what I have to work with. The problem is that parent ids can have
multiple sectors and the second level records only have 1 sector. I
want to ite...more >>
How to restore Values to Table based on some Query Posted by vinoth NO[at]SPAM gsdindia.com at 11/12/2005 4:19:08 AM Hi,
I have a table called A and another Table Called B.
A table has the following Column and Values
ID One Two Three
----------------------------------------------
10 test01 test02 test03
11 test11 test12 test13
12 test21 te...more >>
SP succeeds but returns error Posted by Hoof Hearted at 11/12/2005 1:15:02 AM A have a stored procedure which finds an unused record in a table and then
populates it with data. When I call it from MS Access, it does exactly what
it is supposed to, but it returns error code -2147467259 - unspecified error.
Here's the code:
CREATE PROCEDURE AddAccountsEntry @Keyname ch...more >>
Select in transaction?? Posted by ReTF at 11/12/2005 1:05:56 AM Hi All,
I did read that I cant put SELECT in one transaction, but I need put one
SELECT in one transaction(see code), because I need have certainty that this
SELECT was executed, how I should do this?
BEGIN TRANSACTION
INSERT INTO transacoes(
data,
terminal,
documento,
aut...more >>
GETDATE Posted by Chris Lane at 11/12/2005 12:00:00 AM I have a database that contains, amongst others, the following fields
DocNo, DocDate, DocAmt
I need to extract the data in the these fields, but only where the date (in
yyyy-mm-dd format) is equal to the current date. In other words, I need a
schedule of documents produced on the day of runnin...more >>
Help with SELECT statement Posted by Niclas at 11/12/2005 12:00:00 AM Hi,
I have two tables with a UserID column and need to construct a query that
lists all UserIDs from Table A that is not present in Table B.
Any help with this select statement would be appreciated
Niclas
...more >>
Abstract DTS Posted by Toff McGowen at 11/12/2005 12:00:00 AM Hello
I have a DTS package that loads an Sql Server Database with data from MS
Access datasource. The package works fine but I want to be able to change
either the source or destination connection or both (for reuse purposes) and
still have the package run.
Note that regardless of the conne...more >>
SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. - ERROR !!! Posted by Peri at 11/12/2005 12:00:00 AM Dear All,
I am facing this peculiar problem in SQL server.
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Some times the process is coming as 80, 65 and 59. If this e...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |