while selecting the field, I want it to be display with commas. for example, 10000 become 10,000 without decimal placed at the end. I have tried using smallmoney format but there is decimal places. ...more >>

Hi all, Have been using SqlDataSources for a while now. Reinstalled machine last week, now running Server 2003. Installed both SqlServer 2000 and 2005 with instance-names "sql2000" and "sql2005". Also installed both Visual Studio 2003 and 2005. VS2005 is the Release Candidate, and SQL2005 ...more >>

Hello Everyone, I am working on a database table that was imported from an excel spreadsheet where the date column value is stored as follow(s) yyyymmdd this seems to be stored as a numeric value and not as a date value. So I am trying to write a query on this table where I want to break ...more >>

Hi: I have a database where objects are owned by different users. I would like to revert ownership of all objects to dbo. What is the best way to do this? Thanks, Charlie ...more >>

I have no idea of how to even begin to make a query for this one. I think it's possible to do without the use of cursors. Anyone got an idea? I have the following data and needed output: declare @BeginDate smalldatetime declare @EndDate smalldatetime select @BeginDate = '2005-01-01' ...more >>

Hi, I have a SP that queries data and has data in two temp tables. How do I combine these two tables without joining them? Thanks ...more >>

I want to find all views using a particular table name. Also, I want to find all tables in a view and similarly I want to check which stored procs use a particular table or view. Can you please let me know how I can find this. Thanks Karen ...more >>

sql newb on the block, how can i run this checkdb command. 2. recently started experiencing a problem where we could add new records but could not edit or update changes in the records. any help would be greatly appreciated....more >>

I want to select all medical services charges (ChargeID, ProcedureCode, ChgAmnt, PatUniqueID, service_date, InsuranceDue) where the sum of InsuranceDue for each PatiUniqueID and service_date is zero. In other words, select all the charges for each patient by date, when all the charges for th...more >>

declare @msym varchar(200) select @msym = 'MSFT,DELL' set rowcount 500 select distinct m.* from Main m join Sym2 s on s.id = m.id where s.sym in (Select str from iter_charlist_to_table(@msym, DEFAULT) ) The idea is to search for all 'MSFT' (then 'DELL') in the Sym2 table a...more >>

I am designing a quarterly report for summary of order received quarterly. I need to find out the orderid for the order placed during the quarter, the order date field is order date. This report will run in the early morning of first day of the quarter before any new order is entered. C...more >>

This trigger needs to check the contact1 table for the deleted accountno. If it is not found there it will then use the record in contact1del. This trigger works but I know there is a better way to check for the deleted accountno in contact1 in the IF statement. Accountno values in Contact1 a...more >>

can any one suggested me a better way to compare two tables. I tried following, create table t1(tid int identity(1,1), col1 varchar(10),col2 varchar(10)) create table t2(tid int identity(1,1), col1 varchar(10),col2 varchar(10)) insert into t1(col1,col2) values('c11','c12') insert into t1(c...more >>

Hello, I have problems with select from text file with as linked server. I have TabDelimited file ekbe.txt. I do sp_addlinkedserver to the folder where this file resides: EXEC sp_addlinkedserver 'Staging', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:\staging', NULL, 'Text' my ekbe.txt has...more >>

If I had the following string in a table how could I find all records that contained the term 'Business' for example? Would Regular Expressions be supported in this context? Your comments regarding performance of a category schema such as this? // Example PrivateSector_Business_Services ...more >>

All, I have a trigger that on insert, inserts data into a linked server (Oracle database). When I insert a row of data via query analyzer into the SQL Server table, the trigger is executed and a row is inserted into the linked server, as expected. When the same exact row of data is insert...more >>

Hi All, This is what I am trying to accomplish SELECT a query from SQL2k2 export to Excel 2k. When I populate excel workbook I need the data to be formatted in certain order (esp. my column values should have comma) like 10000 should be 10,000 Unfortunately not allowed to write macros or any V...more >>

Hi All, How to define a column in sql2k with format of its value as 10,000,000 TIA ...more >>

what's the most ridiculous, bizarre and weirdest query you have ever written -- thanks, ------------------------------------ Jose de Jesus Jr. Mcp,Mcdba Data Architect Sykes Asia (Manila philippines) MCP #2324787...more >>

Hi, Using MSSQL 2000 How can I get hold of the current datetime inside a function? declare @dt datetime; select @dt = getdate(); gives an "Invalid use of 'getdate' within a function" error. Any help will be greatly appreciated. Regards, arnoud ...more >>

Hi, I have a COM+ Application written by somebody else, and when I am calling one function, it is returning an "No Transaction Is Active". I have looked at the code, and cannot see why. I have the same version of the dll running perfectly fine on other servers, so I cannot see that it is th...more >>

Is there any way to enable SQL Server 2K to access XML web services? I want to set up some triggers to call a web service method when a record is deleted. Is this possible, or will I need to write my own external app to do this on a scheduled basis? ...more >>

Hi All, I am trying to figure out why the following fails and how to fix it: I have a .NET Client application that passes parameters to stored procedures and uses dynamic SQL that is passed to the Server. Everything is great. My problem is if I want to send over to the server several DML in ...more >>

Hey there I have to copy som data from one field and split it up into 3 seperat new fields in the same table... Eks.: ------------------------------------------ Data column Artis (Old field) ------------------------------------------ Artist Larsen, Kim & Kjukken Larsen, Kim La...more >>

Hi, I have a table containing the following data: ID TitelD fk_Next_Knoten_ID fk_Previous_Knoten_ID ------ ------------ ----------------- --------------------- 131 Kupfer, Erde 138 0 132 Flachkabel 0 141 138 Dr=E4hte, Seil 139 ...more >>

Hello, I am importing a field from a text file that has a date and a time that looks like this: 199902250615 I am importing it into a sql table where that field is datetime data type, however, when I insert it into my sql table, I get the date portion of the field, but the time is lef...more >>

Hi! Let's say I have a table named Category containing categories, subcategories and update dates with the following schema: Id Cat Subcat Update 3 8 A 2005-08-01 2 8 A 2005-09-12 4 8 B 2005-09-08 1 8 B 2005-10-02 5 8 ...more >>

public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException Th...more >>

I am executing this procedure; execute sp_msforeachdb N'use ? select db_name() execute sp_helpuser' the script fails if the database name has a space in it..Is there a work around please assist, I'm new in this.. -- Eager to Learn...more >>

working on a transformation, and one of the things i'm trying to get rid of are columns with comma separated values as lists of data. my god is that annoying. anyway, i need an insert and/or update query that will break up the following comma value problem example (keyword being example, pleas...more >>

could any one tell me how to compare a datetime field in a database with the current system date. if their diff is less than 45 days then i have to fetch the whole values of that row. there may be n number of rows. raja *** Sent via Developersdex http://www.developersdex.com ***...more >>

we have a table with the following structure (not full but should give an idea how it looks like) CREATE TABLE [dbo].[JK_Product] ( [Creator] [varchar] (50) NOT NULL , [ID] [int] NOT NULL , [Product] [int] NOT NULL , [PartNum] [char] (32) NOT NULL , ... ... ... [CheckShipping]...more >>

Hello everyone, I have a query problem. I'll put it like this. There is a 'publishers' table, and there is a 'titles' table. Publishers publish titles (of course). Now I want to make a query (in MS SQL Server) that would return the last title published by every of the publishers. Quite clea...more >>

Hi folks, I am altering the datatype of a column from Int to Bigint using Enterprise Manager. It is going on for hours. Is there any way to see how much % is done/pending. I realized that SQL Server is creating a new table Tmp_TableName with the new datatype and inserts the records to it. The...more >>

Hi, Yesterday I went to company of a friend to troubleshoot their SQL Server 2000. The server has 2GB memory and no other app is using that (dedicated to SQL Server). The problem is that after restarting the service, it takes about 4 days that users fill the memory by their queries and when 2GB...more >>

Hi, We have a working application that has been ok for some time but recently as our data and users increased we started to get timeouts as some queries take more than minute to execute. This happens only occasionally on a very specific query that joins couple of big tables. Now the que...more >>

Hi, select t.type from ( exec sp_depends 'Sales by Year' ) as t doesnot work , how to correct it or actually my aim is to get this sp is depends on this table ? Thanks ...more >>

I am trying to automate upload task at midnight. For this I have create file which generate TAB delimited file, then I create a FTP connection file and thne execute this ftp script for upload the file, but file is still not uploading to FTP server. If I Upload file manually, file uploded s...more >>

I have one column which contains numbers [but the column is in char format] What will be the proper SQL query to sort that column ? If i use order by clause, the records are sorted in characted method, i.e 40,50 not 40,41 ...more >>

Hello I was wondering if you guys know howto convert an ip (string) to oct? need it as a USD TIA /Lasse ...more >>

Can I run "Maintenance Plan" directly (without wait its scheduling)? If can, How to run it? ...more >>

I'm updating every row in a 200mb table. I'm trying to work out why it running so slowly and have found that it increases the size of the log file by 625mb an then empties it, I believe, but leaves it at the same size. I've got the recovery mode set to simple which I thought was not meant to u...more >>

When importing data from Microsoft Access, DTS automatically uses smalldatetime for the Access data type datetime. How can I change this to automatically get datetime to be used for datetime from Access. Cheers Ferdinand...more >>