Is there anybody knowing how to implement cyclic transcation log on MS SQL Server 2000, similar to Oracle? ...more >>

Hi All, I need to write a bcp program using a cmd file to export the data from a table (using select query) to .dat file. Problem: 1. The problem is the destination file name is stored in a table. How can i write a bcp program in this case? Something like: BCP "select * from pubs.....more >>

hi, i would like to know if the bulk copy api for sql server is supported on unix by any odbc vendors. -- Vivek T S Member Technical Staff (Inucom)...more >>

what is the best want to get the time portion of a timestamp, both start and end, for calculations. WE are figuring the elapse time in minutes for an outage on a specific service and would a like a solution. Thank you Boyd Foreman, ...more >>

Can anyone give me an example of using OpenRowset with a text file as the data source? I can't seem to get the arguments right. Thanks, Gerald *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

hi...posted this a while ago and someone kindly gave me some help...still can't get it going though the procedure is as below CREATE PROCEDURE dbo.populate_MAIN_visitors @IP nvarchar(20), @passScreen int AS declare @ident int declare @guid nvarchar(45) SET NOCOUNT ON insert into...more >>

How can I obtain the expiration date of logins for the users of sql? is there any stored procedure, or what sys-table stores that?...more >>

Dear All, When a trigger executed by more then one client at a same time on the internet. My asp pages are getting "timed out" If anybody can give a solution. Yours Sridhar K Chennai - india. ...more >>

I can't use my news reader anymore, it's timing out, I can't ping the news server, I wonder if someone else is having similar trouble or is it something isolated to my network...? I realize the news server may not respond to ICMP.. H:\>ping news.microsoft.com Pinging msnews.microsoft.c...more >>

Hello, I have a table called Agent and I have a table called AgentP. I want insert data from AgentP into Agent if the values in the Agent table dont exist and if they do exist in Agent only provide an update. What would be the best method for this. This will be a weekly scheduled event. ...more >>

I would like to use SQL query to get all rows one by one. For example: Select a,b from table1 While (I don't know which condition) Do something with row Next row Can somebody help me? ...more >>

Hi group, How can I convert an integer (used as date - ISO format) to a regular format of dd/mm/yy ? Thanks, Smith ...more >>

This is a query I have written that works, it grabs a number of users for each org that has more than 3 users, but now I want the names and it doesn't work... but it doesn't give an error, just no results. So I don't know what i'm doing wrong... this works: Select o.Name as 'Organization ...more >>

If I would like to execute the job from query analyzer: EXEC sp_start_job @job_name = 'prenosZaCPO' I get an error message: Server: Msg 2812, Level 16, State 62, Line 3 Could not find stored procedure 'sp_start_job'. Why? The 'sp_start_job' exists in extended SP in master db. If I...more >>

Trying to have a save as in my application. BACKUP DATABASE abw_SWBS_200k TO DISK = 'C:\Program Files\ShipWgt\AsBuilt\Temp.BAK' RESTORE FILELISTONLY FROM DISK = 'C:\Program Files\ShipWgt\AsBuilt\Temp.BAK' RESTORE DATABASE abw_TEMP_03 FROM DISK = 'C:\Program Files\ShipWgt\AsBuilt\Temp.BAK...more >>

Hi, I have a table with some varchar fields and a picture field of type image. I created the second table exactly similar to first table but enabled 'text in row' option: sp_tableoption 'MyTable2','text in row','5000' Then inserted all of records from MyTable1 into MyTable2. All of pictures...more >>

I'm trying to consolidate data from several organizations that use a clientID. I want a client table with unique clientIDs; other tables can contain information related to the clientID relative to the organization. Because other client information in the client table can be entered different...more >>

Hi freinds, I have couple of DTS structured file backup. I need to retore them. !!! How should I do it ? Thanks in advance, Pat ...more >>

I have defined a complex structure with vb.net. One instance of it will be about 32KB. Is it possible to save it to a SQL Server database and how to do it? Thanks in advance. Peter ...more >>

Hello, I want to create a sp, which - receives an parameter (a comma separated list to be processed by 'IN (...)') - and *fills a variable* with the result of the statement. I need the variable content for further processing. I don't know how to fill my variable 'Sumqty' in this test exam...more >>

I have stored procedure doing this INSERT INTO Customer ( Firstname, Middlename, Lastname, Address, = ContactNumber,Email, Age, Sex, Education, Profession, Income, = ReferenceNumber, Type, IP ) VALUES ([p_Firstname], [p_Middlename], [p_Lastname], [p_Address], = [p_ContactNumber], [p_Email], [...more >>

Is there a way to not specify a path for output/input in isql, yet still have the input/output in a specific place? I have found that unless specified the output file goes in various locations if the path is not specified. I would like the files to go to mssql\80 \tools\scripts, though ...more >>

I am trying to send an email message from sql server using the JMail component from dimac.net. I was able to use the stored procudure sp_send_mail from the Jmail usage examples successfully using sql server installed on the development machine and a smtp server. If I use another sql server insta...more >>

Hi All I am having a problem writing a formula. What I need is a formula that can insert a group of numbers of any size from say 3000 to 1 between any two whole numbers. For example between 12 and 13. I have a table with records. I call theses records Instructions. These Instructions are...more >>

I have just read about the Call-level interface, a library of DBMS functions that can be called by an application program. Where can I read more about the CLI function, Google & MSDN searches didn't yield much and no examples etc. Does any one actually program to this to facilitate data transf...more >>

Hi, Is there anyway to search on a sqlprogramming newsgroup before posting a new one here. I just wanna make sure if someone has already asked a question fitting my situation. If so, I would prefer to go to those recommendations first than putting a new post and wasting guru's time....more >>

I tried to write a CLR storeprocedure using C# in Yukon to access an Oracle database. My previous database components cannot be used because when I add them as reference in Visual Studio 2005, the IDE prompts me that "SQL server projects can reference only other SQL Server projects." Whe...more >>

I have a table with the columns Amount and Canceled. I need to have an automatic update occur so that when the Canceled column equals 'Y' the Amount column = '0'. How can I do this. Much thanks......more >>

Phrasing order of joins, searches and sorts. As I understand it, for a composite index to be useful, a query should refer to the columns in the same order as they are listed in the index? I played with this in QA with execution plans on, and I think I am correct. Can someone confirm this? ...more >>

Hi, I have to call a couple of system stored procedures and process the results returned, inside my custom stored procedure. Can anybody tell me how do I retrieve the results of a stored procedure and work on them inside another stored procedure? thanks, Arun ...more >>

I have some dates which visual basic writes to the database in dd/mm/yyyy format. They don't need a timestamp I have a routine in SQL server that checks if the date stored for a record matches getdate() in transact sql However because getdate() also contains a time stamp then even if the...more >>

Hey all, This is something simple which I can't seem to easily determine. Let's say I have a field and I want to strip off the first 4 characters, leaving just the remaining, varying amount. What do I use? example: raw_data = "jimb99999" finished_data = "99999" Make sense? Thanks very ...more >>

I have to authorize people in the db_owner group or some other group (ddladmin etc..) where they should be able to create tables. Problem is when they create table using Query Analyzer, they can mention owner as create table dbo.tablea and the table is owned by dbo. When they user EM to c...more >>

I can't seem to find the correct FIELDTERMINATOR and ROWTERMINATOR values. If I use this format file I can successfully use the bulk insert command but I'd prefer to not use a format file. 8.0 2 1 SQLCHAR 0 500 "\"," 1 Subject SQL_Latin1...more >>

Hi all, I've narrowed down my problem to a key issue. If I don't create a key, then ADO is happy. If I do, then I know get a complaint. I've whipped up the code fragment below to illustrate my problem. I'm using ADO v2.8, although v2.7 has the same problem. Dim dbtblSQL as New ADOX.Table ...more >>

We need to move our Access db to SQL Server. Our Access database have many SQL Queries with Visual Basic function/procedures calls, like IIf. Instead of totaly rewrite thousands of SQL Statements that uses VB function calls which isn't supported in SQL Server (like IIf), we'd like to extend SQ...more >>

Hi, I have a process I've created that uses about 15 relational tables, = The end result is a handful of records from one of these tables. This = table provides a primary key base that the rest of these tables can link = to through relationships. My requirements are than I need to copy a = sna...more >>

I'm converting an app using vb6 and access97 over to use sqlserver. One thing access can do that sql doesn't seem to be able to do is create a view with parameters. The help says I can use something like "select * from SomeTable Where SomeField = ?" or "where somefield = %some value%". I can do ...more >>

Hi all, I have this stored procedure that is used to return recordsets for a directory of doctors on a website. I was wondering if anyone could look and give me some suggestions on how I could rewrite it or enhance it to perform better. Here is the code. CREATE proc usp_GetProvidersByS...more >>

I am trying to convert a column of type varchar with a length of 8 characters to a column of datatype datetime. I keep getting the error "syntax error converting datetime from character string." I can't figure out why I am getting this error. I even converted all of the char values to ccyym...more >>

Howdy, For instance, I have a date '2004-09-27', I would like to convert it to max hours second format like this '2004-09-27 23:59:59.999'. Any help will be appreciated. THX...more >>

Can I extract from an email, finding in the body the date of the data feed, rename the CSV attachment as I save it to a folder then run the DTS pkg to import the attachment? I won't mind manually managing the process until I have confidence in it's automation, however I'd like to eventually be...more >>

Hello All, I have read through the different types of joins but I'm not getting the results that I would like. I need to join 2 tables to create a third table. I actually received help from this site to do it. select M.MemberID_,M.FullName_,M.EmailAddr_,F.DeliveryState,F.DeliveryCount...more >>

I need assistance with creating an SQL trigger. My SQL database has 2 tables: tblLogs & tblBundles. Simplistically speaking, tblLogs is a "master" table and tblBundles is a "child" table because tblBundles contains detail records for records in tblLogs. Both of these tables have a field...more >>

I have a result table set up as follows: a a1 a a2 b b1 b b2 b b3 I've tried, but have failed to come up with the code to take this result set and turn it into another set with the following setup: a a1 a2 a3 a4 b b1 b2 b3 ...more >>

I am completely lost trying to create a query that returns an ADO recordset for a threaded message display that will be displayed in a classic ASP web page. The table looks like this: CREATE TABLE [dbo].[cust_messages] ( [cust_msg_unique_id] [int] IDENTITY (1, 1) NOT NULL , [cust_system_...more >>

I need to order a recordset by a Column that is of type INT. I would like to force it to return the recordset with a particular value last. Something along the Lines of SELECT ID, Name, Age FROM TABLE ORDER BY AGE ( WITH Age = 17 LAST )<- Psuedo Code here but this is what I require is...more >>

Hi there I have a table "ContactDetails" that includes the following fields: CD_LogInName Varchar (35) Primary Key, CD_FirstName Varchar (15), CD_LastName Varchar (15) etc etc I am now creating another table "Alldetails" with the field AD_LogInName Varchar (35) [this will be part of the pr...more >>

i would like to check for duplicate data in a field called catalog_code, if i found got duplicate data,then the table (rd_awards) will not be dropped, but if i found that dun have duplicate data in the catalog_code field, the table will be dropped. Since i want to do this in stored procedure, do...more >>

Hello I created table that one of the column is smalldatetime type. create table BF(hashStr varchar(32) Primary key, fName varchar(36), hashD smalldatetime) My problem is that the smalldatetime is in 'mm/dd/yyyy hh:mi:ss(24h)' format but I neet it in 'dd/mm/yyyy hh:...more >>

Hi I have table structure like Create table tblChain (WFId int Identity(1,1) Primary key, WFDesc Varchar(50), ParentId Int references tblChain(WFID)) I have data as follows WFID WFDesc ParentId 1 Parent1 Null 2 Child1 1 3 Child2 1 4 Child11 2 5 Child21 3 6 Parent2 Nu...more >>

Hi, My database was created with 2 log files. Is it possible to ignore the logged information and have just one log file from now one? Thanks, Leila ...more >>

Hi, As books online mentions, BLOBs are not stored in row by default but they are out of the row. I'm wondered that if they are separate from searchable data(rows), how placing them into other filegroup can help performance? Basically does it? For example: CREATE TABLE Table1 ( C1 int, C2 ...more >>