Hi All I am finding unexpected results when inserted into a newly created table that has a field of datatype int identity (1,1). Basically the order I sort on when inserting into the table is not reflected in the order of the values from the identity field. Have I been wrong in assuming t...more >>

Hi , I need to place the results of two different queries in the same result table parallel to each other. So if the result of the first query is 1 12 2 34 3 45 and the second query is 1 34 2 44 3 98 the results should be displayed as 1 12 34 2 34 44 3 ...more >>

I have an ItemSTDPriceHistory table as below and this is a child table of itemlookup table with one to many relationship. if exists (select * from dbo.sysobjects where id =3D object_id(N'[dbo].[ItemSTDPriceHistory]') and OBJECTPROPERTY(id, N'IsUserTable') =3D 1) drop table [dbo].[ItemSTDPrice...more >>

I have a column which stores dates (datetime data type). I would like to fetch one data which is the most latest date among them. So if there are 04/01/06, 05/08/06, 05/12/06, 06/15/06, then 06/15/06 is the one I need to output. how can I write this in sql stmt? select datebegin from testt...more >>

Hello All, i was wondering what is the main difference between the windows authentication and mixed mode authentication?? according to security recommendations, we should enable windows authentication, rather than mixed one, i don get the point why do we refuse the mixed mode authentication...more >>

Hello, On the database we have stored procedure that loads couple thousands rows with information, it has to be done sequentially because during this load various variables and values has to be changed and modified. We have about 10000 rows to process every day - usually it takes about ...more >>

I am writing some code generation stuff and I am trying to get a script like this to work: IF (something) BEGIN CREATE PROCEDURE Whatever AS SELECT 1 as one END But it complains about this, so I am guessing that I can't put the create prodcedure in an IF block. Does anyone kn...more >>

I would like to create a stored procedure which creates a temp table to store some XML. The # of fields of XML is dependent upon the contents of another table in the application, so the first part of my procedure identifies the # of fields necessary. That is working correctly. The second part...more >>

I look after a database which is part of a third party CRM product. The users of the product complain of intermittant poor performance, the suspicion is that some more senior users are running their own queries (the product allows users to do this). I've been asked by the development team ...more >>

Hi, We have enterprise manager for sql server 2000. I would like to store comments about my database schema somewhere in the database. I want to store information about the intent of tables and columns. We have EM but I am open to any suggestions regarding products. ...more >>

There is itemlookup table, which stores item number and item description. Also there is a child table, pricehistory, of the itemlookup table, which stores different prices and different date ranges. So it is one-to-many relationship. (Price can be stored more than one with a different date range...more >>

In deploying SQL Express, how do I create a new server (INSTANCENAME) programmatically? What would be the best approach to accomplish this. Thank you so much, ...more >>

How to schedule backup of transaction log??? ...more >>

Hi all, If I set recovery model SIMPLE then truncation of log files will be automated , but I will lose database changes made since the last backup was taken. Is there any way to automate truncation of log file and backup of database upto last change has been done???? Plz Hel...more >>

Dear friends, If i want to specify the column name as "acc_no" then it total size is 6 it must get the first two letters as alphapets and the remaining 4 as numbers for this how to write the query?. Please reply. By, Gobi S. ...more >>

Hello, Could you explain me please the following error: "Database 'DemoDotNET' cannot be opened due to inaccessible files or insufficient memory or disk space. (Microsoft SQL Server, Error: 945)" I have checked: free disk space is large enough, I have much enough memory, other files in the ...more >>

I have a bit of a problem with regards an indexing strategy. Well, basically there is no indexing strategy on a set of data I have at work. Now, I didn't create the design as I would have allowed for this. OK, so there is primary key (clustered) indexes (mainly composite keys), but no other in...more >>

Hi, I got another question here: I want to use query like this: SELECT * FROM (sp_lock AS T) WHERE objectID = ... The purpose is that I want to query the result set returned by sp_lock using derived table, but it doesn't work. Why? Thanks, Baihao -- Posted via Mailgate.ORG ...more >>

Here's my problem: I'm developing an ASP.NET 2.0 application that has a user select one or more auto manufacturers from a listbox ("lstMakes"). Once they do this, another listbox ("lstModels") should be filled with all matching models made by the selected manufacturers. If lstMakes was not m...more >>

Hi, Say I have a table Job with columns name, date, salary . I want to get the name ,date and salary for the date when that person earned maximum salary. I am using something like SELECT X.name,X.date,X.salary FROM job X WHERE X.salary IN (SELECT MAX(Y.salary) FROM job Y where Y....more >>

Hi all, Any thoughts on the best way to run an update query to update a specific list of records where all records get updated to same thing. I would think a temp table to hold the list would be best but am also looking at the easiest for an end user to run. The list of items is over 7000 ...more >>

Hi Everone, I'm writing a script to import data from an XML file, and this tutorial is really an awesome guide : http://www.kbalertz.com/Q316005/Import.Server.Component.aspx ... problem though is here's a snippet of my XML file: <planets> <sun rise="6:23" set="20:33"/> <moon rise="18:5...more >>

Can I determine if a value is numberic then output 'text' else output 'some other text'? I'm trying to do this in a select statement. Thanks! ...more >>

After rebuilding an index, it still shows as the same amount of fragmentation. ANy ideas what's wrong? I'm determining which indexes to rebuild using the following query: SELECT OBJECT_NAME(i.object_id) AS TableName, i.name AS IndexName, ips.avg_fragmentation_in_percent FROM sys.dm_db_ind...more >>

hi sir i have table hh .it has two columns one is hhno is integer datatype another hhdoc is xml data type like hh table hhno hhdoc ------------ --------------------------------------------------------------------------------- 100 <suresh>sfjfjfjfjf</su...more >>

According to BOL <--- BACKUP LOG Specifies a backup of the transaction log only. The log is backed up from the last successfully executed LOG backup to the current end of the log. Once the log is backed up, the space may be truncated when no longer required by replication or active transaction...more >>

Is it possible installation SQLXML 3.0 on Windows 2003 Server??? ...more >>

Hi, I created a composite index (lastname, firstname). I know the following queries will use this index: WHERE lastname = ... WHERE lastname = ... AND firstname = ... Also this won't use the index: WHERE firstname = ... But how about: WHERE firstname = .. AND lastname = ... And why...more >>

Hi, We have a lame app that uses 2 datetime(8) fields, 1 stores the date, the other the time. example query: select aud_dt, aud_tm from orders results: aud_dt aud_tm 2006-06-08 00:00:00.000 1900-01-01 12:32:26.287 I'm trying to create a q...more >>

I am using an MS Access front end to input data into a SQL server database. From Access I am generating an update query utilising an inline function. My problem is that when I update a time value, instead of updating the field with something like 08:00:00 it updates it to 1/1/1900 08:00:00. I...more >>

I have a sql 2000 database on my local machine that I need to get to a far away server so he can make one like it on his server. The admin tells me I need to make a dump of it and send it to him. I just don't know how to do that. Can someone help me out? Thanks, Jerry ...more >>

Hello, Folks. I am not sure if this can be done (and a brief search of this group didn't yield any results that I thought would do the trick) but if it can be done it would make my life easier so here goes. First, what I am trying to accomplish is to make a program I've written automatically ...more >>

Hello, Is there anyway.. we can disable AUTOCOMMIT option in MSSQL server while executing the SQL queries via SQL ANALYZER ...more >>

Opinions? I've installed all three to try'em out and they all seem to be working so far, more or less. Log Explorer has given me a couple of errors but I started over and continued OK. ApexSQL Log squawked about "redo for delete cannot be generated for tables lacking clustered index". Hu...more >>

Is there an easy way to script the tables from within a database to include the indexes etc... Basically, if I want to script a number of tables, I can right hand click on them and generate the script that way. What I'd like to do is this same process in T-SQL if possible so I can build an SP ...more >>

hi guys! Currently i'm facing a bit odd situation. i cant modify my code so i have to make changes in SQL Server. the problem is, i've modified one table by adding new column and now i want only those row which has not null value in that column whenever the select statement gets fire. i mean ...more >>

I need to link some data from SQL Server 2005 with Oracle 10 data. One way is to link Oracle server to SQL Server and use ROWSOURCE for retrieving data. What other ways for joing data from both databases exist ? Can I do it from SQLCRL VB - Stored Procedure ? If yes, what objects shall I ...more >>

Hi all, I'm using SQL Server 2000 SP3 to store data for real time transaction processing. I have set up replication to another server using a push subscription to give me immediate backup. I need to alter the data type of one of the columns and am using the following basic sql: al...more >>