|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
Help with query
John -
24 Jun 2006 8:13 PM - 2 messages
Hi, I would like some help with a query. I would like to delete all rows when the key appears in one table and not the other. For example the info in table 1 on my DB is my current work. I then import the upto ...
Use of 'Line numbers' for certain tables
John Linville -
24 Jun 2006 2:22 PM - 9 messages
Hello Been reading posts by Celko et al about not using 'line number' column in a table. This I can understand except in the case of a 'Invoice detail' table where the lines must appear in a certain sequence on the customers invoice. ...
Help with query
Niclas -
24 Jun 2006 2:09 PM - 3 messages
Hi, I have a stored procedure (posted below) that returns a club ranking list with fatsest to slowest time for a swim club based on Stroke,Distance,Course,Gender,Age. Number of rows in the ranking is based on the @Rowcount variable passed in. ...
XML help
reachmano -
24 Jun 2006 1:25 PM - 3 messages
Is there an option you can add to a sql query that would give me XML output which also includes the datatype. Example: I would like the XML output to show <property name="LinkNumber" type ="Integer">101</property> ...
A professional approach and customized solutions for business of all sites.
arvyly -
24 Jun 2006 12:07 PM - 2 messages
Professional web design and other web development services is what Wicked Innovations specializes in, from complex integrated solutions for business and advanced multimedia products. We offer affordable prices, a professional approach and customized solutions for business of all sites. What separates us from the rest is not only we provide a unique and ...
SQL Server - Accounting
pedaammulu -
24 Jun 2006 7:24 AM - 4 messages
Accounting Software Development using SQL Server and VB.Net or ASP.Net ? Madhav [link] Kiss Goodbye to expensive training programs ...
Distributed Queries
Karen -
23 Jun 2006 10:27 PM - 11 messages
We are using MS SQL Server 2000 service pack 4. On our production servers the following scenerio works, our LAN department recently rebuilt one of our development servers and we are having problems. On our central development server I create a temp table CREATE TABLE ...
get a count between a time range
TDT -
23 Jun 2006 9:12 PM - 8 messages
I am trying to figure out if I can do this in a SQL query. I need to know how many users are active during a given time period. I want to be able to return the results below. If you look at the row with ...
Why run time double in a script?
nick -
23 Jun 2006 8:30 PM - 19 messages
I have table value UDFs. It takes about 2.5 minutes when I execute select * from dbo.myudf('...') I have a stored procedure to run thousands of the UDFs as dynaml SQL: @sql = 'insert into @tablevalue select '+.....+' from dbo.myudf('+...+'...)' ...
time-series calculation logic question
GB -
23 Jun 2006 6:44 PM - 9 messages
Hello, I have a simple table of 2 columns: datadate ( datetime) like '2006-01-31' and x (real). I am trying to implement the following logic: If x(t-1) > x(t-2) then Flag(t) = 1 If x(t-1) < x(t-2) then Flag(t) = 0 ...
Searching sql image types with WHERE clause
James -
23 Jun 2006 6:39 PM - 3 messages
Hello, I am storing finger print records in sql server 2000 on a table with a column type of image. I am able to store and access the records with no problems at all. I had a late breaking requirement to search for a ...
duration vs cpu
Lianne Kwock -
23 Jun 2006 6:07 PM - 4 messages
Hello all, I ran a trace on a store procedure and the result showed that the duration is 500 ms vs 80 ms on cpu. I want to know why duration is taking a lot longer than the cpu time. Does anyone know what might have slowed down the ...
Problem using EXEC() to run DBCC DBREINDEX
nosurfdj -
23 Jun 2006 6:06 PM - 4 messages
I am trying to run DBCC DBREINDEX using EXEC(), code is below. Based upon the error message at the bottom, the @currenttable variable receives the value 1 but when @currenttable is referenece in the DBCC statement, the value isn't there. Can anyone tell me what I'm doing wrong? ...
Datetime comparison problem
Ellie -
23 Jun 2006 5:32 PM - 10 messages
Hi, I am having trouble finding any records with a datetime of 2006-06-16 09:04:39:347. This time clearly falls between the beginning and end times. I'm even converting to a char to see if that works. It seems to work if I ...
Synchronizing two SQL Server Databases
le_mo_mo -
23 Jun 2006 4:57 PM - 3 messages
Hi, I am trying to have two SQL Servers (Local/remote) synchronized. I was wondering if there are any jobs I can run to make this happen. I have one server defined as linked server for the other. I can not figure out ...
What kind of code in a stored procedure is actually run on client?
nick -
23 Jun 2006 4:38 PM - 3 messages
I created a stored procedure Sql Server 2000. There is a bug in the sp - an infinite loop. I run it on my client pc using SSMS. And my client PC CPU soar to 100%. I thought the whole SP will be run on the server side. It seems it runs on ...
paramater values inside IN clause
Pedro -
23 Jun 2006 4:34 PM - 19 messages
I have a problem in a stored proc where I pass more than one value to the parameters inside a IN clause: it doesn´t retrieve any data. But if there's only one value I get results. here's the code: ...
creating Powerpoint presentations (etc) from SS 2000 T-SQL
Randall Arnold -
23 Jun 2006 4:09 PM - 17 messages
I have a need to create Powerpoint presentations from T-SQL queries (SS 2000). Contents will involve sharts and tables. Now, I can think of some crude hacks to accomplish this but I'm looking for the most elegant method ...
Does many tables matters
Steve, Putman -
23 Jun 2006 4:01 PM - 9 messages
Does it matter if we have hugh number of tables vs few tables. One example is this. We have a table called Vendors where VendorID is the Primary key, and another table VendorNotes (VendorID Int, Note varchar(500)) where VendorID ...
Adding days and setting time
simon_s_li -
23 Jun 2006 3:59 PM - 4 messages
Hi, Can someone please help me with a SQL Server 2005 issue with date and time. I want to take the current date and time and add 2 days to it, but the time must be set to 5pm. If the current date/time is past 5pm it will go to the next day at 5pm. ...
Registering SQL Server Instance through a batch
DJL -
23 Jun 2006 3:46 PM - 1 message
I have a particular network environment where my profile doesn't save the Enterprise Manager application data when I reboot. Therefore every day I have to re-register all the SQL Server units in my EM. I am wondering if I coudl write a batch that could register the units. ...
Multiple Inserts in the Same Stored Procedure
bradley.d.walker -
23 Jun 2006 3:41 PM - 8 messages
Hey, I have a project that I have been working on and I need to insert a record into multiple tables and I if any one of the inserts fails I need to rollback all of the previous inserts that were done. To ...
UDF vs SP
Robert Bravery -
23 Jun 2006 3:32 PM - 11 messages
Hi all Which is quicker, better for returning a recordset. A UDF or a SP. THanks Robert ...
Kind of cross-tab query
J055 -
23 Jun 2006 3:26 PM - 3 messages
Hi I'd like to get the results below from this sort of data. I might also have additional tables that need another 'prods' type column. Thanks Andrew --------------- declare @docs table (docID int primary key, docname varchar(25)) declare @prods table (prodID int primary key, docID int, prodname ...
SQL server 2005 date conversion bug??
Panos Stavroulis. -
23 Jun 2006 2:49 PM - 10 messages
Hi, I have a very strange problem converting a string to a date... See the following query select [RTG MDY ISSUER RATING], mdy_rating_date, convert(datetime,mdy_rating_date,103) rate_date ...
Inserting single record files into SQL 2K5 based on file's existen
David Bowles -
23 Jun 2006 2:39 PM - 1 message
We are in the process of migrating from an in-house 'ERP' system to Dynamics AX and until we have our AX Returns Subsystem up and running, we want to create a process that if files containing one record each appear in a folder, ...
SQL Select
magix -
23 Jun 2006 1:54 PM - 3 messages
have following table record Year ModelYr Type 1999 1994 2 ...
HELP on SELECT Statement
magix -
23 Jun 2006 1:41 PM - 2 messages
I have following table record Year ModelYr Type 1999 1994 2 ...
Strange Query Analyzer result
Brent White -
23 Jun 2006 1:15 PM - 6 messages
I am looking at archiving some tables. One of them is a table called TXUYLS01. It is a fairly large table (about 650K rows). My issue is this: If I do this query in Enterprise Manager: SELECT * ...
Copy triggers between databases without copying table
SMC -
23 Jun 2006 1:13 PM - 6 messages
Is there any way to copy a trigger between SQL Server databases without copying the table? In other words, is there some what to apply a trigger to a table through a script? ...
Update Trigger
Paul Cheetham -
23 Jun 2006 12:53 PM - 3 messages
Hi, I'm new to writing triggers, and I can't seem to get the syntax right of this one. What I am trying to do is this. On Update of DB1.Table1 If (Update(Table1.Completed)) UPDATE DB2.Table2 ...
SQL 2005 updating data in SQL 2000 DB via linked server returns error
ccjjharmon -
23 Jun 2006 12:45 PM - 19 messages
I am attempting to push data updates via linked server from a master database (running in a SQL Server 2005 instance) to a local database (running in a SQL Server 2000 instance) via linked server. I am performing the updates via stored procedures. ...
SqlDependency fails when not connected to domain
Jason Saidoo -
23 Jun 2006 12:34 PM - 2 messages
SqlDependency seems to work for me just fine when I am at work and logged into my work domain. I attempted to demo SqlDependency outside of the office and it simply would not work. In debugging, there are zero errors, and the ...
Erro at login [Ms Sql-sever 2000]
fabian.szukat@googlemail.com -
23 Jun 2006 12:31 PM - 1 message
Hi @ all I 've got a big problem: I Programm wiht Java and i'd like to conect a database form SQL Server 2000 SP 4. Became ab dany access message, The messe is: "Error during the registration for the user "Fabian". A cause: No familiar SQL server ...
search in only non tagged words
shahdharti -
23 Jun 2006 12:26 PM - 7 messages
Hi I want to search from table for rows where value should be part of text , but search should omit values from tag. like create table #t (data varchar(8000)) insert into #t values('<div> this is a div text </div>') ...
Transaction causing procedure to get progressively slower
Someone Else -
23 Jun 2006 12:16 PM - 3 messages
Hi Guys, I've got a procedure that does a lot of work on a database. When run within a transaction it gets progressively slower. It uses lots of nasties like nested cursors down to about 5 levels, and temporary ...
Need to know about Getdate function?
SouRa -
23 Jun 2006 11:33 AM - 6 messages
Hai, Let me know when this function returns null value Substring(Convert(varchar,DateAdd(MM,1,GETDATE()),107),1,3)+' '+right(Convert(varchar,DateAdd(MM,1,GETDATE()),107),4) regards Soura ...
No mapping exists
Oxns -
23 Jun 2006 9:45 AM - 2 messages
Hi, Hope this is the right forum. Calling a SQL Express database (which is working fine), from a Web Page using C#. Get the Exception : No mapping exists from object type System.Data.SqlClient.SqlCommand to a known managed provider native type ...
BUG(?): Distinct + variables TSQL
mzacharzewski -
23 Jun 2006 8:49 AM - 11 messages
Hi All, the following TSQL statment doesn't return expected value: declare @tmp varchar(500) set @tmp = '' select distinct @tmp = @tmp + ',' + Col from ( select 'A' as Col union all select 'B' union all select 'A' ) x select @tmp expected: ',A,B', returns: ',B' ...
Another Join / aggregate newbie request for help
henry -
23 Jun 2006 8:21 AM - 2 messages
Hello I need to present som logged data from a tabel accumulated last hour and total. I have two tables [analog register] AR ID (unik PK) SignalText (plain text, description of the datapoint) id SignalText ...
help me with date
amjad -
23 Jun 2006 8:15 AM - 4 messages
Hi i have date field. when used paratemized query from asp.net . in which date field is null , it null the whole dynamix sql , then i decide to use isnull function to convert null to '', i like set @mydate=isnull(@mydate,'') ...
Fetching the wrong value in structure varible....
Shahul -
23 Jun 2006 7:15 AM - 1 message
Dear Pals, In my win32 console application, using the ODBC ver.3, trying to fetch the records from the Table. While fetching the resultset, some variables are not retrieving the correct value. Here the scenario. Table1 has following two fields, ...
Counting unique FK
Michael Maes -
23 Jun 2006 6:50 AM - 6 messages
Hi, I'm not sure how to explain my problem, so I'll go ahead with an example. There are two tables: tblContact & tblContactAddress tblContactAddress has a FK ContactId. I want my SP to return something like this: ContactAddressId ContactId ... Position ...
aggregate function
Squirrel -
23 Jun 2006 3:31 AM - 6 messages
The following statement fail to generate my expected result: select A.part_id, sum( (B.total + sum(C.amount)) * D.rate) from A, B, C , D where B.part_id = A.part_id and C.line_id = B.line_id and convert(char(6), B.date, 112) = D.code ...
CLR SP and config file
Richard -
23 Jun 2006 2:02 AM - 2 messages
Can a clr stored proc use a config file? ...
time_series calculations in SQL
GB -
23 Jun 2006 12:19 AM - 2 messages
Hello, I have a simple table of 2 columns: datadate ( datetime) and x (real). Is it possible to create SQL select statement ( not UDF) which performs the following calculations: y = (x(t) - x(t-12)) / x(t-12). Here t is datadate column value. ...
Execute sql scripts saved in a text column of a table
Peter -
22 Jun 2006 11:33 PM - 4 messages
How can I execute sql scripts saved in a text column of a table? Thanks, Peter ...
cant find connection code
Carl Henthorn -
22 Jun 2006 11:23 PM - 1 message
I am using 2005 profiler against a 2000 database. I am running a dts package that uses an odd driver to connect to a third party database file. I would like to take this out of dts and create a sql proc instead, so I was using ...
SqlBulkCopy problem
GB -
22 Jun 2006 11:16 PM - 2 messages
Hello: I am developing C# project, using ADO .NET 2.0 to connect to SQL Server 2005. I created a DataTable from scratch, and then use SqlBulkCopy to insert it into an empty table in a SQL Server 2005 table. ...
How to insert/update a text field using writetext/updatetext?
Peter -
22 Jun 2006 10:53 PM - 1 message
I'm trying to update a textfield using updatetext but I'm keep getting Null textptr passed to UpdateText function. When I insert a record, do I need to initialize the text column to something? ...
Can't run my scheduled job which accesses a linked server: other options?
ryan_willow -
22 Jun 2006 10:35 PM - 5 messages
I have a stored procedure in a database on a server, and this stored procedure uses a linked server. The login I was given is only granted DBO permissions on this database. I am trying to set this up so that the above stored procedure runs once ...
a little SQL problem
brownjenkn -
22 Jun 2006 10:29 PM - 2 messages
I have what is probably a simple problem and I guess I'm just looking for whatever solutions you all can suggest... I have this query: Select columnA , sum(columnB) as VAL from myTable where columnA in ('01,'02') group by columnA ...
context connection in CLR table valued functions
Sascha -
22 Jun 2006 9:15 PM - 2 messages
I have to filter cells of a table, i.e. replacing individual table cells with nulls. In a stored procedure I could use the following code snippet, where the filtering is done by SendThisRow() and BuildSqlDataRecordFromFilteredIDataRecord(). using(SqlConnection connection = new SqlConnection("context ...
"Live" queries in sql 2005 ?
Owen -
22 Jun 2006 9:11 PM - 3 messages
A colleague was telling me the other day that in Sql Server 2005 there is a special type of query you can do, whereby it runs in the background and brings back results automatically, whenever they change. He referred to it ...
Multi Column grouping
Scott Cadreau -
22 Jun 2006 8:56 PM - 2 messages
I have a table with 9 code columns in it. I want a listing of every possible code in any of the 9 columns with a count of each. Is there a way to do this without creating a new table that has 9x the rows that the ...
How Many Normal Forms Are There?
Smithers -
22 Jun 2006 8:08 PM - 3 messages
I could swear that I once read that there were 12+ normal forms, with most of them theoretical. I can't seem to find the document and maybe I'm confused about what I'm remembering. So, can someone tell me how many normal forms have been somehow defined (or ...
View and using maximum dates
mgabig -
22 Jun 2006 7:58 PM - 4 messages
Hello all, Originally, I had a query that looked like this: SELECT TOP 100 PERCENT co, id, salary, rate, ratePer, startDate, endDate FROM dbo.ERate WHERE (rateCode = 'Base') AND (startDate <= GETDATE()) AND (endDate ...
Query problem with joins
wilhelm.kleu -
22 Jun 2006 7:47 PM - 1 message
Hello Let me explain the problem I am having: I have two tables, data_t and a_data_t a_data_t is the archive table of data_t The two tables are exactly the same. In the table values are stored: Value (A numeric value) ...
FTP from xp_cmdshell
randy -
22 Jun 2006 7:33 PM - 2 messages
I have a .bat file that uses ftp -s:scriptname that works from a cmd window and works from running the .bat file but won't work from xp_cmdshell. The sql agent proxy is set to a system administrator domain account that is ...
Would you suggest contacting MS paid support?
gshawn3 -
22 Jun 2006 7:14 PM - 3 messages
Hi, I am having what seems to be an obscure issue with SQL Server 2000. I posted about the problem in these groups about 2 days ago but did not receive any suggestions. I have never contacted MS paid support before, so I am not sure what to ...
sql server 2000 fn function?
nick -
22 Jun 2006 7:10 PM - 2 messages
I just found that the following code on my SQL Server 2000. And it works fine. what's { fn .... }? SELECT GETDATE() AS date, { fn SECOND(GETDATE()) } AS sec ...
Counting Date Query
tarheels4025 -
22 Jun 2006 7:03 PM - 5 messages
I have a table called sv_call_log The table contains columns row_id, card_num, start_date, end_date. This table logs calls. The start_date is when the call begins and end_date is when the call ends. They are both fromatted as follows EX. 2004-09-20 15:55:29.247 ...
If file exist, FTP file
David -
22 Jun 2006 6:49 PM - 2 messages
Within a SQL Server Job, I am using the following vbscript to connect to a FTP server and FTP a file: strLocalFolderName = "My Folder Name where we put the file to be FTPed" strFTPServerName = "FTP Server Name" strLoginID = "FTP Server Login ID" ...
Outlook locked with sql 2005
Jack -
22 Jun 2006 6:33 PM - 1 message
I am setting up SQL 2005 server. We are using SQL Mail. I have defined the email operator and defined notifications on a job to send out emails when job completes. The issue is the my outlook client on the server gets locked once sql server ...
How to add condition to where clause?
bic -
22 Jun 2006 6:10 PM - 8 messages
I have a long query and therefore want to avoid using it twice in an if else structure, while still be able to achieve excluding an id when @id=null(meaning all included) in the where clause or like. i.e. ...
How to empty log file in SQL 2005?
Marco Napoli -
22 Jun 2006 5:47 PM - 9 messages
I have been trying to shrink or emptly a log file in one of my Databases but to no evail. When I try to shrink it only shrinks it by a little bit and grows to the original size within seconds. ...
ORDER BY DATETIME field BUG?
wolfen42 at gmail.com -
22 Jun 2006 5:20 PM - 9 messages
I was under the impression that the DATETIME field was stored internally in SQL server as two integers? Any idea how to get correct ordering of a datetime field? I have two records containing a datetime field with these values and ...
Select Distinct Data from Symmetric Table
Norton -
22 Jun 2006 5:14 PM - 4 messages
Hi EveryOne, I have a table like this and wanna to distinct some columns so that only one record will show for this criteria (User1 <> User2 AND User1SampleNo <> User2SampleNo) User1 User1SampleNo User2 User2SampleNo EuclideanDistance ...
Select Distinct Data from Symmetric Table
Norton -
22 Jun 2006 5:05 PM - 1 message
Hi EveryOne, I have a table like this and wanna to distinct some columns so that only one record will show for this criteria (User1 <> User2 AND User1SampleNo <> User2SampleNo) User1 User1SampleNo User2 User2SampleNo EuclideanDistance ...
using aggregate functions in co-related query to find some column value
Rajeev -
22 Jun 2006 4:50 PM - 3 messages
I have two tables Expense_Addl and ExchangeRates These are the scripts CREATE TABLE Expense_Addl ( FileId int, HostAmt money, HostCurrencyCd char(4), ...
Some difficult joins
Rajeev -
22 Jun 2006 4:46 PM - 2 messages
I have two tables Expense_Addl and ExchangeRates These are the scripts CREATE TABLE Expense_Addl ( FileId int, HostAmt money, HostCurrencyCd char(4), ...
SQL Server 2000 View -- Case Statement
robboll -
22 Jun 2006 4:38 PM - 4 messages
In a table I have a date format: YYYYMMDD What do you do when instead of NULLs or Blank Dates there are 99999999? In Access I'd use an IIF statement. This case statement by itself doesn't work. Any ideas appreciated: ...
Job Outcome Constants (SQLDMO_JOBOUTCOME_TYPE)
marcmc -
22 Jun 2006 4:21 PM - 2 messages
How can i write a simple procedure as below, call it from a job, and because @m = 2 it will fail the job step and so show me the red x beside the job name in ent mgr? create procedure marc1 as ...
Beginning Balance Query
Lyners -
22 Jun 2006 3:40 PM - 5 messages
Hello all, I would like a total (beginning balance) field in a query be the total for the year up to the month based on another field within the query, so that when the fiscal_date = '5/1/2006' that I would have a field contain totals ...
Images in SQL
Preacher Man -
22 Jun 2006 3:15 PM - 9 messages
I notice that SQL 2000 has a datatype of image. My question is after I setup the table and fields how do I populate the table with image data? ...
Incrementing column in a query
Charlie@CBFC -
22 Jun 2006 3:13 PM - 3 messages
Hi: I would like an incrementing column in result set of a select query. Numbers begin with 1 and increment by 1 for each row in result set. Does same as counter column in table. How do you do this? ...
joining two tables
magix -
22 Jun 2006 3:01 PM - 5 messages
Hi let say I have record:s in two tables, namely tblTable1 and tblTable2 tblTable1: Year SerialA SerialB 1998 1 3 ...
How To Move A Database Table
JLuv -
22 Jun 2006 2:49 PM - 3 messages
I want to SELECT data from one database table and INSERT it to another table on a second SQL Server in C# ADO.NET. Where can I find information on how to do this? ...
How to query for transaction's isolation level...
SammyBar -
22 Jun 2006 2:36 PM - 6 messages
Hi all, Is it any way to query a running transaction to see the isolation level it is using? I'm debugging a mobile .net application that access a SQL 2K database and I need to verify if it is running transaction on the desired ...
t-sql statement one-one match
Joe K. -
22 Jun 2006 2:31 PM - 6 messages
How can the sql statement listed below be modified to test the UserProfiles_Number table that UserID field has only one record in the PhoneNumber table that corresponds to the UPID field? I would like to output the records from UserProfiles_Number that do not have ...
convert year part of a date
GV -
22 Jun 2006 2:27 PM - 5 messages
Hello all, I have some data in a Varchar(15) column name datecolumn that I need to fix, should be date value. some of the data is like this 12/6/304 4/1/105 4/26/705 2/4/705 ...
Subquery performance concern
trtranger -
22 Jun 2006 1:30 PM - 8 messages
Hi Group, I have 2 tables: x and y. this is my query select x.abc, (select y.def from y where y.id=123) as comment1, (select y.def from y where y.id=456) as comment2 ...
Custom data extension has trust issues
hokietoner -
22 Jun 2006 12:41 PM - 3 messages
I wrote a custom data processing extension which works in preview mode, but when viewing it from the report server I get the error: ---- An error has occurred during report processing. (rsProcessingAborted) Cannot create command for data source 'MeridiumDataSource'. (rsErrorCreatingCommand) ...
trigger vs default
Tom W -
22 Jun 2006 12:40 PM - 3 messages
I downloaded some example code from MS and don't understand why this trigger is being used. Wouldn't a column default accomplish the same thing? Is there some reason a trigger is 'better' than a default? Is ...
Query tuning
Justin -
22 Jun 2006 12:38 PM - 3 messages
How do you guys go about compare the efficiency of two queries? What I usually do is run the "Display estimated execution plan" in the query analyser and see each query cost (relative to the batch) and pick one that ...
Bulk insert from text file in to multiple table
Prabhudeva Kenganavara -
22 Jun 2006 12:19 PM - 2 messages
Hi, I have a requirement, i need to bulk insert the data form the text file. we need to insert firt 2 values from text file and insert into first table. then retrive the primary key value of inserted values then with this ...
Adding a line return to an SQL messge
Robert Bravery -
22 Jun 2006 11:52 AM - 11 messages
HI all, I'm adding a custom SQL message. How do I insert a new line, line feed. So that the message is split between a few lines Thanks Robert ...
ASP error with stored procedure
Geoff Lane -
22 Jun 2006 11:14 AM - 3 messages
SQL Server 2000 on Windows 2003 SP1 and IIS6 I'm getting the following error from my ASP page: Microsoft OLE DB Provider for SQL Server error '80040e14' Formal parameter '@mname' was defined as OUTPUT but the actual parameter not declared OUTPUT. ...
A query runs 1 times slower from a .NET application the from Query Analizer
Boaz Ben-Porat -
22 Jun 2006 11:13 AM - 11 messages
Computer: 3.4 Ghz CPU, 1 GB RAM, 2003 Server database : MS SqlServer 2000 Enterprise. ~ 10 GB database file. Largest table in the database contains 11,000,000 records. Framework: .NET 2.0 I try to run a query against the database, selecting aggregated data from ...
NT Events
ipramod -
22 Jun 2006 10:55 AM - 1 message
Hi, Can I get all the NT Event ID's that can be generated for SQL Server 2000? Let me know ASAP. Regards, Pramod ...
Find the nearest date of one column of a table from another table
Rajeev -
22 Jun 2006 10:14 AM - 6 messages
I have two tables Expense_Addl and ExchangeRates These are the scripts CREATE TABLE Expense_Addl ( FileId int, HostAmt money, HostCurrencyCd char(4), LockDt smalldatetime ) INSERT INTO Expense_addl values (1001, 500, 'USD', '2006-06-15') ...
Views and Query Optimizer
sorinr -
22 Jun 2006 9:52 AM - 2 messages
Hi all, Supose I have a view that combines fields from multiple tables. When I select something from this view, does the query optimizer know to 'use' just the fields specified in the SELECT statement and in the WHERE clause (if any)? ...
question-synch
P Platan -
22 Jun 2006 9:49 AM - 1 message
Hello! We have 2 databases.An old one which has the old schema and the new one which has the schema that we want to go for. We are in the middle of the transition and by using triggers we keep them ...
Last Execution Time of Stored Procedure
Immy -
22 Jun 2006 9:10 AM - 7 messages
Hi all, since seeing the post from Satya with regards to Alter time of proc, there's been a question bugging me for quite a long time now. Is there a way within SQLServer (2000) or 2005 where i can tell the last ...
BETWEEN PROBLEM IN DATETIME QUERY
Savas Ates -
22 Jun 2006 8:33 AM - 5 messages
I have some Records in my table like that 2006-06-16 14:15:01.607 2006-06-16 14:17:28.187 2006-06-15 14:17:28.000 2006-06-13 14:17:28.000 2006-06-17 14:17:28.000 ...
How to get the dates on which a proc is altered ??
Satya -
22 Jun 2006 8:14 AM - 5 messages
Hi All, I want to see the dates on which a proc is altered in a database. Is there any way to get this information ? Regards Satya ...
GROUP BY with multiple columns
Reik -
22 Jun 2006 8:14 AM - 6 messages
Hi all, Iam havin a rather complex query and need to add another column in the resultset. That new column is a COUNT aggregation and I need to use the GROUP BY clause. Below is the query that I tried. However, there is a problem with ...
Using Index
neeju -
22 Jun 2006 8:13 AM - 7 messages
Hi, Is there any way to make sure that perticular query uses specific index. I know that this can be accomplished using index hint. But client is arguing to work out on any other way to force the query to ...
SQL Server 2005 and Cursors
steve_craze -
22 Jun 2006 8:03 AM - 3 messages
Hi Everyone! We are using a cursor for paging results in SQL server, mainly due to the performance gains achieved when working with large results sets. We have found this to be of great benefit when working with SQL Server ...
|
|||||||||||||||||||||||