Hi, someone send me a visual basic transformation script to tarnsform some data in sql 2000 server, but I don't know how to run that script. It would be very kind of you, if you can tell me step by step how to run (with which tool of sql server) that script. regards atx ...more >>

Hi all, I need a urgent help. My server crashed yesterday because of the harddisk problem. I lost my backup file and only got this *.mdf and *.ldf file. I tried to restore these using attach database method and also by creating a database...stop the sql service... overwrite the created da...more >>

Is it possible to have query result to have a column per row of a table? e.g. Employees table ID (identity) FirstName Ref containing ID, FirstName 1 Tom 2 Dick 3 Harry Project table ID (identity) Name containing ID, Name 1 Client A ...more >>

Does anyone know how to write scripts for generating update statements for existing data? I found a stored procedure online that generates INSERT statements for a given table, I was wondering if anyone has worked on a UPDATE generator...more >>

Please look at following code: use mybase select name,OBJECTPROPERTY(id, N'IsExtendedProc') op from master.dbo.sysobjects where name=N'xp_myxp' use master select name,OBJECTPROPERTY(id, N'IsExtendedProc') op from master.dbo.sysobjects where name=N'xp_myxp' When OBJECTPROPERTY is calle...more >>

Hi, How can i group the datetime field with different time period in same day e.g 2006/1/23 07:00:00 12 2006/1/23 07:01:00 10 result : 2006/1/23 22 Thanks & Best Regards, Sexball ...more >>

Is it possible? I only have the MDF from my SQL 2000 DB, and I need to import it to SQL Server 2005.... Best Regards Fabio Cavassini ...more >>

What is the TSQL command to chanage a column of int type to identity type and vice versa? Thanks in advance! KM ...more >>

I'm trying to divide 2 integers to return a column of C's per thousand with (Failures / Dropped) * 1000. I've tried different version of float, cast as decimal etc. I'd like 4-5 didgits after the decimal. What is the correct way to divide integers to return a usable number. Yr M...more >>

Hi there. We're using SQL Server 2000 on a Windows 2000 box with dual hyperthreaded Intel CPUs, raided hard disks and 2GB RAM. It should certainly be able to handle our currently fairly modest demands. We have all the latest security patches. Parallelism is disabled. We're currently e...more >>

Hi, i need to create a sql statement to find out record between a period, but i only want to search with the date part only (e.g. 2006/1/23). In my database, the type of the field is in datetime format. How can i bypass the time part but still can find out what i need (e.g. 2006/1/23 00:00...more >>

Hi all, Running SQL Server 2000 on Windows Server 2003 Executing SP in VB client program accross subnets takes about 1:20 seconds. Within the same subnet takes only 7 seconds. Any ideas? thanks gv ...more >>

I have a column name of Text datatype. Most of the values in this column contain html tags. For Example: Column Value = <P><FONT face=Verdana size=1>Regulatory Affairs.</FONT></P> Can someone please help me with an update statement that will replace "Verdana size=1" to "Arial size=1" fro...more >>

I'm trying to normalize a table but I'm not sure what the proper way to do it is: Imagine you have these two tables: Commodities =========== CommodityID (primary key) Description UnitWeight UnitValue UnitOfMeasure CountryOfManufacture HTSCode ExportLicenseRequiredFg PackageConten...more >>

I try to compare dates in a NON EXISTS expression like this: SELECT ArticleNo, SerialNumber, DateShipped, DateAssembled, DatePackedForShipment FROM ArticleSerialNumbersTempEgersund a WHERE (NOT EXISTS (SELECT b.ArticleNo, b.SerialNumber, b.Date...more >>

I want to join 2 tables conditionally. One order needs to join with one instruction. The three potential join fields are: Country, Exchange, and Type. These fields are required in the Orders table but only Country is required in Instructions. The data entry requirements of the application are su...more >>

hi all Now I have an error operation, then SQL Server give error message as follows: Violation of UNIQUE KEY constraint 'gwbh'. Cannot insert duplicate key in object 't_xt_gwsj'. " I want to set this error into a variable, e.g. @errstr how to do? thanks! -- Ê÷Éϲä»Ò ...more >>

I have created the indexed view v_Tour_I_Idx with multiple indexes as UNIQUE CLUSTERED INDEX [TranTour_TranId_Idx] ON Column [TransactionId] ; INDEX [TranTour_Date_time_Idx] on column [Date_Time]; Both 2 columns have statistics and updated up-to-date. I have created another view as: ...more >>

My first time encountering this error, and I can't find any documentation on it... adErrUnsafeOperation 3716 - "Safety settings on this computer prohibit accessing a data source on another domain." I'm calling a stored procedure in an enterprise environment, returning a single recordset,...more >>

Is anyone familiar with SQL Express? I installed it but cannot find any Data Tranformation Services. Has this feature been removed from this edition? I went to the SQL compariosn page but could not find DTS on any of the editions. thanks! ...more >>

Hi I seem to be getting the following error, when running a SP which = populates a table: *********************************** Server: Msg 8650, Level 13, State 127, Line 1 Intra-query parallelism caused your server command (process ID #62) to = deadlock. Rerun the query without intra-query...more >>

I've programmed a user defined function (SQL2000), which in a specific query references a linked server (another SQL instance, BTW contained in same physical server). The sintaxis is ok, but i couldn't apply the definition because of following error: "Error 7405: Heteogeneous queries requir...more >>

I have two subreports in a main report. I have the main in a subscription that gets push down to a pdf every morning. What the user has requested is to down load to an excel but each subreport to be in a separate book within the same excel file. Is this possible?? ...more >>

I have been at this all day. I have a view in SQL server that queries across two tables with a one to one relationship. I show all the fields in table one and get blanks where there is no record in table two. Is there a way to substitute the <Null>s with a string like 'BLANK'. They are cau...more >>

I need some help with this syntax Select * FROM PROJECTS WHERE CONTAINS(Problem_Description, '"Invalid use of null"') And WHERE CONTAINS(Problem_Status, '"Open"') Can you have multiple CONTAINS Statements? I am getting a syntax error with the above code snippet. What am I missing? Thank...more >>

Is there a simple way in an update trigger to identify what columns have changed? We have a web-based application that requires us to show a log of column changes associated with a record. For example if a user logs in through the website, changes their name on a web-form, we update the databa...more >>

Does anyone know how to extract just the domain from a URL in T-SQL? So, for example, http://www.awebsite.com/pages/thispage.html" would come out as http://www.awebsite.com, or just www.awebsite.com. Many thanks for any help. ...more >>

Hi. I'm using Coalesce to change a NULL returned value from a Select statement. Here's my code: SELECT TOP 1 @StartDate = Coalesce(Discount_Effect_Date, '01/01/1980') FROM MyTable WHERE RTrim(Subtable_Id) = 'I03U' Print @StartDate When I have a row in MyTable where the Subtable_Id = '...more >>

Hi, I'm just wondering, how big should the transaction log files be in relation to the database files? I noticed the the transaction log files on my server are quite a bit larger than the database files. Is this normal? Thanks in advance, Linn ...more >>

Hi, I have a problem... I want to backup data to a backuptable from a table that has a relation to an another table. And the backup should be done with a trigger when an update or delete occurs... What I mean is that if I have a table A with columns of NameID, Name and LinkID... then the Link...more >>

I would like to link an Excel Spreadsheet to my SQL 2K Database. Where do I need to start? For example. I would like to have a cell in Excel that gives me the sum of Sales Orders in my SQL Database. I would also like for this to be able to change according to a date field in excel that c...more >>

In select Query SQL Query Analyzer how to specify a different server name. For Ex: If i want to copy data using "insert into select......" statement from a different server to my current server, Is it possible using SQL Server 2000? Thanks Imtiaz ...more >>

Hi In Oracle there is a concept that allows one to perform an update without using the rollback logs so you can try to improve the performance of an update. Does such functionality exist in SQL Server 2000? I cannot seem to find anything on it in BOL Thanks N ...more >>

I am trying to keep it consistent with data from the source, I change datatype for a field from int to smallint and it has a value between 200 and 1000. When I do it in Enterprise Manager, I give me this warning: - Warning: Data might be lost converting column 'auto_pre_appr' from 'int'. Is...more >>

I am writting a query for a forcasting report and I am having a problem figuring out how to calculate the amount of quarters that a certain contract spans. I need to calculate the total quarters and then divide the total contract by that quarter total to get the a single quarter value. Then calc...more >>

i am using select CONVERT(varchar(15),getdate(),101) result is 1/23/2006 but i want result in 01/23/2005 what am i doing wrong. Any db settings??? ...more >>

First off I would like to admit that I am an beginner to intermediate SQL user, so I am familiar with the logic flow, simple commands, and terminology, however I am not experienced and still learning. I have been given a project to create a stored procedure that will execute a repair, reindex ...more >>

Hi all, OK, bear with me on this! I have a load of tables that are related, and one of the tables holds 'points' associated with skills which are associated with products. As an example I've rewritten this to be programs as the products, and therefore skills associated with the products are e...more >>

Hi, Two questions, in the query analyzer I typed this: backup database hcn to disk 'D:\Microsoft SQL Server\MSSQL\BACKUP\mybackup01232006.bak' And I got a syntax error: Line 1: Incorrect syntax near 'D:\Microsoft SQL Server\MSSQL\BACKUP\hcnprod01232006.bak'. I also tried it without the...more >>

Hello, What exactly means the "control-breaks in the result set"? From an ADO recordset, I will see the summary as a new recordset? If I will use MyRst.NextRecordset I will move to summary recordset? If this is the case, is it any way to use alias in this summary recordset instead of "cnt" or...more >>

I am not a programmer but have noticed in this query peaking my processor when running. The table has over 2.7 million rows. Is there a better way to write the sp for better performance or tweak the table? The excution plan shows TableScan 37%>Filter 56%> Sort 4%>pParallelism/Gather Stream ...more >>

Can you pass a part of a table name as a parameter? Our database was created so that the last four characters of the table name are client specific so each time we get client data, the last four characters are different, causing me to modify all queries I have setup. For example a table na...more >>

Hi, I've got a stored procedure that makes use of several cursors to collate data and then place it into a temp table, which is then eventually returned to the calling code. The problem is that when I execute the stored proc, opening the cursors seems to be returning a recordset, when all I n...more >>

Why can't I include the path to the bcp utility when I use xp_cmdshell? This works fine in the command window: "C:\Program Files\Microsoft SQL Server\80\Tools\binn\bcp" "ABData.dbo.tCMD_OutputToFile" out "c:\temp\abdata.txt" -c -U"chagus" -P"c" but this don't work from within SQL Query Ana...more >>

Hi there, I have a mysterious problem when I use a datetime value in a where clause. On a SQL Server installation on Windows 2000 it works as expected but on Windows 2003 I don't get a value. Here's an example : select * from dbo.tblImportEffBlockData where efficiencyBlockId = 305 an...more >>

i am trying to code a proc that tests whether a job is running. i understand how to get job status from the xp_sqlagent_enum_jobs via the current execution status and i also understand that status = 4 means the job is idle. what does status =5 (suspended) mean? The BOL information seems to in...more >>

Is it possible to use : set concat_null_yields_null off Inside a view ? Thanks ...more >>

SQL Server 2000 accessed via ADO. I have a "lending libray" type of application with key tables represented by the following DDL: CREATE TABLE LibraryItem ( ItemID INT PRIMARY KEY IDENTITY, ItemName VARCHAR(128), LoanTypeID INT, BorrowerID INT, LoanDate DATETIME...more >>

Hi, I have a DTS package that runs 4 other packages on a nightly basis. This package usually takes about 2 hours to run, but ocasionally it jumps to around 5 hours to complete. There have not been any changes to the parameters or coding. It is the same process that causes this each time ...more >>

Hi, Query puzzler here. I have a table of PEOPLE. Besides the Person ID, each record has five Date fields- Married , Graduated, Started Job, Got Famous, Got Rich I want to write a query that shows what the current status of each person is. In other words, show which event has happen...more >>

I have a requirement to know all the parse errors happening in my sql server 2005. Is there any log file /error file which stores this information. Is there any other way by which I can store all the parse errors happening in my sql server ?. If microsoft sql server does not store Pars...more >>

My application needs to run its database on MS ACCESS. But Win NT4.0 does not support the latest MS ACCESS database -- its driver is out of date. Can I run the redist.exe deployed with SQL2000 to update latest driver? Is it free?...more >>

Hi to All! I am trying to use the 'Bulk Insert' command to load a data file into a MS-SQL db. The line I am using is: BULK INSERT Data..tbl_load FROM 'C:\Data\data.txt' WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n' ) Sql Server is giving error: ...more >>