Hi, Assume I have a PRIMARY KEY on one column. =20 How can I change PRIMARY KEY onto a new column using code? Do I have to recreate the table? Thanks....more >>

There is some option in Sql Server 2000 to set of avoid errors when a text larger than destination field is stored in it ? For example i must do an INSERT INTO NAMES and NAMES have a field of size 10 if i store a field of size 20 in it the server give me an error can i avoid this error...more >>

Hi, Could you tell me the syntax to set primary key on two columns when I create a table? I can't find it in the books. The syntax I found is CREATE TABLE MyTable (c1 INT PRIMARY KEY,c2 INT) How can put c2 as part of PRIMARY KEY? I don't know how to use CONSTRAINT. So if CONSTRAINT ...more >>

I am maintaining a website that connects to a SQL Server database via a system ODBC DSN. The connection had worked fine until the password changed for the userid used in the connection string. Here is the VBScript snippet that used to work fine. DSN_Name = "DSN=mydsn;uid=dsnuser;pwd=xyz12...more >>

Hi This select in my sp when I call it from Query Analyzer works and when I call it from my DTS package it dosen't work.it returns NULL into @C4ENROLLMENT_ID SELECT @C4ENROLLMENT_ID=CAST(ENROLLMENT_ID AS NUMERIC(9)) FROM dbo.IF_C4TRANSFORM WHERE FILEID=@INTERNAL_FILEID AND LINE_NUMB...more >>

Hi, I am calling a stored procedure from DreamWeaver, but I am getting an error, perhaps someone can help (It has to do with the last field (text), if I use nvarchar instead works fine. SP: CREATE procedure Addtemplatestocase @FirmId int ,@CaseId int , @SecLtr nvarchar(50), @LtrName nv...more >>

Hello All, I have table with two fields, Field ID1 can repeat but not ID2. ID2 is unique primary key Both have string data type Table T1 ---------- ID1 ID2 x x1 x x2 x x3 y y1 y y2 Now I...more >>

Hello, What would be the easiest way using a SQL query to do this : I have a table with columns: ID(int), data1(int), data2(int) I want to copy for each ID data1 to data2 so : ID - data1 - data2 1 - 90 - 0 2 - 239 - 0 3 - 213 - 0 Will become : ID - data1 - data2 1 ...more >>

Hello, Is there a way, through t-sql, to query a linked server and display its list of tables? I know you can see the list through Enterprise Manager but am wondering if there is a way view the list with a query. Any help would be greatly appreciated! Thanks in advance. ...more >>

Hello! I am really puzzled by the was SQL Server is using statistics. I was looking at DBCC SHOW_STATISTICS output for one of the indexes. I noticed EQ_ROWS value and executed query WHERE <indeed column>=<value>. Query plan showed number of rows I expected. When I executed similar query...more >>

Hi. I have a stored procedure where I'm creating a Temporary table, inserting data into it from another stored procedure, than altering it by adding another column, then doing more stuff within the temp table. My problem is after my Alter statment, I need to use a GO statement to the table...more >>

I need to get acount(*) of a table and use it later in my sp,How can I do that? Thanks ...more >>

/* Please help. Thank you for your time and ideas. Given this data setup how do I answer efficiently this question? The result set can be very large of sales. For a given sale, are there any other sales of the same maker, that have been sold in the same configuration? In this data, sales...more >>

I got a Table which has Text Data Type ... I inserted around 15 to 20 pages document into Text Data type Column. But when Reterive the table using select query I can only view 8 kb of data. I cannot view the complete 15 or 20 pages which I inserted. Is there any way to view the Data. Th...more >>

Hi all, I'm preparing to pull data into a new DB from an existing system. The first piece of this is to copy from one flat file (Customer) into two files (Entity and Role) into the new DB. The problem I've got is that I need to create the key in Entity and then use that key to insert the ...more >>

I'm refactoring a cursor written by another employee. It includes a cursor that uses the FOR UPDATE clause to update records as the cursor iterates through the records. Please assume that the cursor cannot/should not be replaced. When executing the snippet of code below, I get the SQL Ser...more >>

Hello, I have a list of employees (+5000) that I use to compare with a database. I can find the employees that match the list. How can I find the ones that are not in the database from this employee list? For example, This is the Employee List (text file) EmployeeID LastName Fir...more >>

This group is always awesome. Thanks in advance for your help. I need to put together some recordsets for a charting application. I think this is everything (ddl, data, expected result set.) Thanks again. CREATE TABLE [dbo].[Tracking] ( [key_] [varchar] (10) COLLATE SQL_Latin1_General_...more >>

create table tbl1( fld1 varchar(10), fld2 varchar(10)) insert into tbl1 Values('joe','x') insert into tbl1 Values('joe','y') insert into tbl1 Values('joe','z') insert into tbl1 Values('bill','x') insert into tbl1 Values('sam','z') insert into tbl1 Values('ted','x') insert into tbl1 Values...more >>

I have view, which work good. The view has 2 query, one query union all next query. Each query is join of 24 tables. I need to do change in the view. I had, at begin of both queries: " select _id = WOrig.XpitOrderNumber*1024+OSCL.ID, ...........". Now I need to split the fie...more >>

I have an ASP program that uploads a csv file to a temporary table. sometimes if there is an error, null values are inserted into the row in an infinite loop. When this happens I reset the server but is there a better way of avoiding this on the SQL server? a)How can I kill this process manua...more >>

Okay, im a little confused. I just read the doc for the LOG function, and it says that LOG uses base 2. So i figured okay, LOG(8) = 3, right? cuz 2 ^ 3 = 4. Well, wrong! According to SQL server, LOG(8) is not 3, but rather 2.0794415416798357. So i thought maybe my memory of the logarithm fun...more >>

I have the follow query with a subquery that is not returning the correct results, please help. The query is supopse to pull all consumers that have a specific type of step applied to the record however they are suppose to only appear if another specific type of step is not on the record. ...more >>

I have two databases. One is on SQL server 2000 and one is an Access 2002. I have a table named [Data] with a field named [LName] on the SQL server. I have a table named [Names] with a field named [FullName] on the local DB. I get a data type error on this query: SELECT [LName], [FullName] ...more >>

Hi friends.... I need to query using isqlw the SQLService uptime (Or using DMO), could anyone help me?...more >>

Scenario: Run a batch file.. Multiple Querys... An error occurs in 1 query and in QA all other queries will run and return results. In dot net I can't get past the error.. ie Select top 1 lastname from northwind.dbo.employees raiserror ('Error Here',14,2) Select top 1 firstname from north...more >>

Greetings, I am getting the following error "Server: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'IF'." My SQL statement is: SELECT dbo.tbl1.col1, dbo.tbl1.col2, dbo.tbl1.col3, dbo.tbl1.col4, IF IS NULL(dbo.qry1.col5) THEN BEGIN dbo.qry2.col3 END ELSE BEG...more >>

Server = SQL Server 2000 SP3a Client = Access 2000 SP3 (.adp) I was looking at sp_tableoption, and it has a couple of options which sound interesting: pintable text in row I've read BOL, but could someone clarify a little please: pintable = BOL sais [When enabled, marks the table as RAM-...more >>

We have a MicroFocus COBOL program that is calling a new stored procedure that is only called from this pgm. All data types are consistent between the two (i.e., fields are defined with the same attributes in both stored proc and COBOL pgm). But after the COBOL pgm executes the stored proc...more >>

Hi I have a SUM function in my query that's giving me the wrong value My tables are : CREATE TABLE [CurrentDataReports] ( [MachineID] [int] NOT NULL , [PartNumber] [nvarchar] (50) COLLATE Latin1_General_BIN NOT NULL , [ShotCount] [bigint] NULL , [CycleTime] [int] NULL , [Status] [int] N...more >>

I apologize for the cross post but I am using ADO.NET methods and such to access SQL and I am thinking perhaps both sides will have valuable input for this. I have two tables one called QUOTEINFO and one called QUOTEITEMS. One contains the specifics of the quote and the others contain t...more >>

Background: I have a DB that has 5 tables (USERS, COMPUTERS, GROUPS, OU) and is populated using DTS every a.m. from Active Directory with new and modified security princpals (ie USERS, COMPUTERS, GROUPS and Organizational Units). My DTS order: 1. Copy security principal properties into...more >>

Hi anyone knows how can i check the date/time the SQLServerAgent/MSSQLServer services startup?, using WMI or consulting some properties in master or msdb? Thanks all....more >>

I have a question with using osql. I'vce got a batch file that executes a series of SQL scripts. These SQL scripts each will take between one and two hours to execute. What I think is happening is that when one script fires off, the next in line immediately fires. How can I tell the bach fi...more >>

Scenario: The system needs to manage events by groups. There is no hierachical concept in the events. Special events have different attributes that need to be treated differently so I create a separate entity. Note that the DeviceID has a many-to-one relationship with a LocationID (not in the ...more >>

Good morning, experts. Got a syntactical snag I need a fresh pair of eyes on. I've looked at this query too long and I know that the fix is probably staring me in the face but I can't see the "forest for the trees", as it were. SELECT * FROM ((SELECT XH.CDS_04 , XH.CDS_07 , XH.CDS_...more >>

I have the following stored procedure and was wondering if anyone could help me. I've not written sql in ages and I'm not sure if i'm working efficently. I'm trying to return a dataset to bind to a asp.net datagrid and then I also want to display the total count of records in a label. Does any...more >>

Hi I have simple SELECT query SELECT StartDateTime, EndDateTime, Machines.[Name], SUM(DATEDIFF(MINUTE, StartDateTime,EndDateTime)) As Duration, Quantity ,CycleTime FROM ProductionData INNER JOIN Machines ON Machines.[ID] = ProductionData.MachineID WHERE MachineID = 1 AND Quantity > 5...more >>

Hi, I have a table named ProdData with 2 fields startdatetime and enddatetime, Iwant to get the total downtime from another table named Downtimes between these 2 dates for each record that I extract from the ProdData table, and get it one table in SQL QA so I can execute it directly into a sp...more >>

Hi guys, how do i select the lastest record from a Database? say, if the column i want to select is called "criteria_searched", how do i select the last row that was stored? thanks in advance =) *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have the following records Date EmployeeId Projec 20050503 12345 VERIZO 20050503 12345 CINGULA 20050503 12345 SPRIN 20050503 24680 CINGULA I need the resulting table to look like this Date EmployeeI...more >>

Hi all, I am trying to figure out a small code snippet, maybe someone has this already? I am looking for code which would validate that a value is a valid binary multiple of 2. That is, i want to validate that some number 'n' is in the sequence: 2, 4, 8, 16, 32, 64, 128, 256, 512, 1024, 20...more >>

Hi i hava a procedure that call another procedure, but thie procedure just can go on processing if the called procedure has any errors. I don't know how to to this. Now when some error occurs in the called procedure, the main procedure is going on! =/ Thanks do much Daniel Groh ...more >>

What is the different, type CHAR , VARCHAR, NVARCHAR, and NCHAR? I have looked for answer at SQL Server's manual book. But I still not understand. Please explain me so simple away. ...more >>

Hi, My table stores around 30000 users, out of which around 5-10 are demousers. Right now we are using the NOT IN Statement to list the original users like SELECT * FROM UserTable WHERE UserID NOT IN ( Demo User IDs) I know this will affect performance. Right now i am planning to modify the...more >>

Example my data Name -------- adi Adi ADi AdI adI type field "Name" is Varchar(4). How to select data that its value "ADi". ...more >>

Hi, I have a requirement for a query which returns as many columns as many rows are present in the table. Table looks like this Parent_Assembly_id Child_Assembly_id 1 2 2 3 3 ...more >>

Can any one give me an example to give admin role (Full access) on a database to a Role in the sql server database using T-sql statements. I am trying to create roles and users in sql server using t-sql statements. when I create a user it will be created with a permission to login to that db. ...more >>

Hi, I just upsized my Access 2000 database to MSDE (which I intend to upsize to SQL Server in a few weeks) and got a .adp file from a .mdb file. How do I connect to this .adp file from Visual Basic? Can I distribute this file easily like Access? Please help, I have no idea what to do with ...more >>

Similar to my other question, but the counting is different. Thank you again for your help. CREATE TABLE [dbo].[Tracking] ( [key_] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [value_] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) insert into tracking VALUES ...more >>

Hello, Is it common to use Locking Hints in the ADO query string? myself didn't have a chance to use it. what situation is useful to use it? Thansk. ...more >>

Hi Does anyone know of a way / script to remove all extended properties from objects within a certain database? Tia James tgl ...more >>

Hi Everybody, I'm doing a program to generate newsletter and in turn need to read the = bounced email message from OUTLOOK and store these data into SQL db. = These bounced email addresses will need to be collected and for further = processing. But different ISP has different format of pres...more >>

Ladies and Gentlemen, I would like to offer you the following string functions Transact-SQL GETWORDCOUNT() Counts the words in a string GETWORDNUM() Returns a specified word from a string AT() Returns the beginning numeric position of the first occurrence of a character expression wit...more >>