Hi there!!! Where can I get info about how to build the sql logic/statements while under multiuser mode. Under multiuser mode I mean that data in the tables is modified by multiple users and all the activity is performed in the transaction bounds. I am using rowlock to synchronize the acces...more >>

Is there a way to implement a batch INSERT. Currently in my asp.net code I perform a loop. As each loop runs through I construct my Insert command and execute it through ado.net. I was just wondering if you can construct some sort of a batch INSERT command. Mabey pass an array or hash of i...more >>

I had posted this to microsoft.public.sqlserver.server a day and a half ago, with no response. I'm guessing I posted it to the wrong forum, because this should be a simple question for anyone that has ever had to design a database. Apologies if this is the wrong forum. Please direct me otherw...more >>

Hi I have a start date and an end date. I need a select statement that will, starting from the start date, return a recordset consisting of the date at X days interval upto the end date. Eg startdate 1-1-2004 enddate 1-2-2004 recordset should look like this where X=7 days... 1-1-2004 ...more >>

Friends, Is there any problem with query performance when i have a query using IN or NOT IN in a SELECT statement. Thanks Leandro Loureiro dos Santos ...more >>

Hello, I'm doing a query with an SQLQuery to MSSQL 2000. I'm trying to make a list of the fields of a table and their types. I know the data types except one: autonumeric. When I design a table, an autonumeric field it's a integer field with the identity property. How can I know if an integer...more >>

I'm looking for a way to add 4 'default' values into the beginning of a select statement in a stored proc select * from tbl_new where id = @id that would return 'me', 'you', 'something', 5 'me', 'you', 'something', 6 'me', 'you', 'something', 7 BUT, I would like to be able to have...more >>

I have table with PK on 2 columns: ID and Date are columns for primary key. If there is only one column for PK, I can get the last PK with ident_current: select ident_current('tableName') How can I get the PK, if it's combined from 2 columns? Thank you for your answer, Simon ...more >>

We have a very large database of customers and we are trying to do a count on whether a specific field in the customer table is null or not null. The numbers are changed for privacies sake but here is what's happening. SELECT count(*) FROM maillist result: ~4000 ---- SELECT count(...more >>

Hi, I have two tables, tableA and tableB. They have a same column named, COLUMN11. Here are data in these tables. tableA COLUMN1 AAA BBB tableB COLUMN1 AAA How do I find data value BBB which does not exist in the tableB? Thank. Mindy ...more >>

I'm using a job to execute a sp accross linked servers over the internet. In query analyzer the sp executes fine, but in the job i have the following error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. [SQLSTATE 28000] (Error 18452). The step fail...more >>

I have a stored procedure that stopped working today. The code that fails uses xp_cmdshell to run pkzipc.exe. I have reduced the procedure to the following code that is failing. Running this from cmd prompt works fine - from my sp, runs forever without doing anything. set @cmd = 'pkzipc -e...more >>

Hello, I'm hoping someone can help with this. I'm looking for a sql statement to get me my results. If somehow I can use a stored proc, that'd be cool too, but I know nothing about them (I am doing this to display on the web with ASP). I have a games table. table: GAMES game_id game_...more >>

I have a written a SQL query which extracts a subset of data and sorts into order, e.g. SELECT cust_id, cust_name, cust_total_spend FROM cust_data ORDER BY cust_total_spend DESC Within the select statement, I would like to generate a 'ranking' column that simply increments from 1 to 'n' ...more >>

Hi, I have some data in a table (in 3 columns) as follows: Type Month Amount Advertising July 150.0 Banking Charge July 980.0 Food July 1560.0 Advertising August 120.0 Banking Charge Aug...more >>

i'm creating a Dynamic Query inside one of my stored procedures, and i got the following question... if i use quotes for setting my Dynamic Query inside a string, how do i set a text inside the Dynamic Query: EX: Select @Sql = 'Select * From Teams where Category = ( i want to use here quotes fo...more >>

Hi, i need some help designing a query. let's say i got 2 tables from a Soccer Tournament DB, TEAMS PLAYERS TeamID---------------I PlayerID TeamName I----------------TeamID Etc..... ...more >>

I'm trying to convert a combined City/State field in one table into separate City and State fields in a destination table using the following method. Let's say that: Table1.CityState = "Columbus, OH" and I want: Table2.City = "Columbus" Table2.State = "OH" so I'm trying: ...more >>

Hi My Application is designed for 5 languages.English,Spain,France,Japan and Germany. It works fine for all other 4 languages except France.The Problem is When Retreiving data from the database i get an error "Arithmatic Overflow of data of datatype DateTime. The same Application it wor...more >>

The following procedure produces impossabe output according to BOL for the RETURN statement. Proc ================== CREATE PROCEDURE dbo.StoredProcedure1 AS Print 'Here 1' RETURN (Select Count(*) from INFORMATION_SCHEMA.COLUMNS) Print 'Here 2' RETURN (Select Count(*) from INFORMATI...more >>

is it possible to convert a varchar(10) value to datatype of money (sql server 2000)?? i have a value stored as '0000008752' in my db, but i need to convert it to money so it will appear as 87.52 - any help with this would be much appreciated. another ex. '0000010000' would become 100.00...more >>

Good morning ... I have this scenario ... TableA (Col1(PK), Col2, Col3, Col4(FK recently added from TableB)) TableB (Col4(PK), Col5) TableA has 10000 rows and TableB 20. Col4 in TableA has Null value on all the records. I need to randomically fill Col4 in TableA with the values of Co...more >>

Hi All, My programmers have asked for my help in troubleshooting an ftp issue we're having when calling an FTP command from a DTS but I'm stumped. I'm not a programmer myself so hopefully I provide you with enough info. Basically, we have a DTS that runs nightly - goes out to a client FTP si...more >>

Hi all, what is the alternative way to use trigger (insert, delete, update) that have column data type (text)? I don't want to recreate my table. Thanks a lot...more >>

Hi friends, I have a Students table that contains student information (name, DOB, GPA, etc.). I want to use a single SELECT statement to select the name, DOB, GPA of the student who has the highest GPA. What should the statement look like? Thanks!...more >>

Can I use multiple constraints to partition my tables and if so, can I insert into the partitioned view? Here's my script: --Energy July 2003 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PMO_Energy_07_2003]') and OBJECTPROPERTY (id, N'IsUserTable') = 1) drop table...more >>

If I am using bcp to queryout an sp any temp table in the sp would have to be a global temp table or can it be regular temp tables? thanks Meenal ...more >>

Hi there. I have a table in the following format TaskID AttributeKey AttributeValue 1 SomeText 23:30 1 MoreText Daily 2 Text Monday 3 Text 03:45 3 TextAgain Saturday Basically I have a table with some schedule details for an a...more >>

Hi, I have db driven form on an asp website with three drop- down boxes that are mapped to one table. I'm having trouble in finding a way to update the boxes other than using cursors. Data can be supplied in either some or all of the boxes. So I am either updating, inserting or deletin...more >>

Hi, Is there good site where I can find database model samples? I need model for sending reports with many options, like enable/disable sending, groups, time schedules, history, ... I'm using SS2000 Enterprise edition SP3 on Win2000 Advanced Server SP3 Thanks in advance Nikola Milic ...more >>

I have a stored procedure that simply insert a row into a table and it doesn't insert properly. Below are the table definitions as well as the sp. The problem is that the AppID read from the tblCounters table is not being read correctly. The update portion of the stored procedure is workin...more >>

Hi folks, When we do an UPDATE on one of our tables (say TableA) through Query Analyzer(QA) it will not give us a chance to roll back the transaction (even though our IMPLICIT_TRANSACTIONS is set to ON). We get a message "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION...more >>

Is there an option I can add to the RESTORE command in sql server that if it finds bad media, or something doesn't work right, it will keep the database like it was. My company has remote locations only connected to us by modems, and when they get kicked off, the database they were uploading t...more >>

I have two tables: TableA, TableB. The structure of TableA is exactly same as of TableB. TableB is empty. TableA has 1234 records. The structure of these tables are as under: Field1 int Field2 int Field3 int Field4 chat(3) ............. ............. ............. Field89 TIMESTAMP I...more >>

I have a table (say, Table1) defined as: Column Type ------ --------------- ID indentity int(Primary key) nameData varchar(32) In a stored procedure I want to query for a record with a particular value for nameData. If it is there, I want to retrieve its ID. If not, ...more >>

Hello: When I run the following distributed query, it takes several minutes to complete as opposed to running the same query on the remote server, where this query runs in a second. -- query start select Account_ID, sum(case portfolio_num when 1 then Income_Commission_Amt else 0 end...more >>

This is what I would like to achieve, I need to extract from a db a set of information which has been written to various tables during the course of a day. This information needs to be encoded in the form of XML and then written to as an ordinary file on the server. This needs to be writt...more >>

Hello All, I want to setup a scheduler for a job. But the scheduler should not start the job if it is already running. Can we do something to accomplish this? Or is it automatically taken care by SQL Server. Thanks in advance Satish...more >>

Hi, I have built a collection of procedures which act on a number of tables. These work successfully using the "sa" user and now i want to use a new user to execute the packages and modify the data (DML). For my new database i have enabled the db_datareader and db_datawriter options but i canno...more >>

it seems that i have something missing when updating a distributed partitioned view...using sqlserver 2000 ent edition, win 2000 server.... i get ==> union all view 'customers' in not updateable because the defintion contains a disallowed construct (42000,4416) has anyone had this problem?...more >>

Hi, I have a funny Error in our sql server 7 & 2000. When I compare two string in Unicode format. I receive that it is the same when I add new nchar. I don’t understand why? Could you help me ? declare @str nvarchar(128), @str2 nvarchar(128) Set @str = nchar(21121)+ncha...more >>

Hi, I have a funny Error in our sql server 7 & 2000. When I compare two string in Unicode format. I receive that it is the same when I add new nchar. I don’t understand why? Could you help me ? declare @str nvarchar(128), @str2 nvarchar(128) Set @str = nchar(21121)+nc...more >>

Hello all I need to find out which user is current using the sql database. I can't use multiple login names, as this is out of my control. So far I have been querying the sysprocess table using @@SPID and working back from the host name. eg. select distinct(hostname) from master.dbo.sysproc...more >>

I want to date the creation as well as the last modified entry in a sql table. How do I do that? Where may I find information about working with Date and Time in SQL? I know the "Now" in Access but I don't know the equivalent in SQL and how to use it. Thanks...more >>

Hello! I have a problem about xp_sendmail. I must send an email using an Intranet address. If I use this syntax: exec xp_sendmail @recipients = 'ilenia', @message = 'hello', @subject = 'Test' where 'ilenia' is the name of account Intranet mail, or even if I try to use my Internet personal...more >>

Dear all, I am wanted to write a UDF where the number of parameters is not known until runtime. Any ideas on how to do this? I have looked on BOL and the web and can't find any answers. Many of the UDF's that come with SQL Server display similar functionality. Such as CHECKSUM() which can als...more >>

I have an audit table which includes some columns with defaults based on system functions - but these do not always work.. table definition.. CREATE TABLE dbo.Audithistory ( event_time datetime NOT NULL DEFAULT getdate(), event_type int NOT NULL, dbname varchar(10) NOT NULL...more >>