Hi i want to build a table. The situation is as follows : There are 7 customers which send in their nominations. Also they keep sending their revised nominations. I need to track the nominations, revised nominations, revised dates of each customer. What i hav thought is following columns Cust...more >>

Hi, In Job Scheduling dialogue box, under notifications tab there is an option called "Write to windows application log file". Where do I find this file? I would like to know the physical path of the file. Regards, Sevugan.C...more >>

Hi, As soon as the mail session is started I am getting the following error message. Why Am I getting this? How should I resolve this? Help me in this regard at the earliest. SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is...more >>

Hi any idea how much parameters stored procedure supports. renjith...more >>

Hi Is there any way to disable a trigger from running (trigger is not dropped). i just dont want the trigger not to be executed for a temporary purpose(but must be in database) renjith...more >>

I have been trying to implement the following: 1. A user updates a table ... 2. A trigger fires on the event that ... 3. Run a shell command DTS pointing to a batch file [d:\test.bat]. 4. The batch file executes: @echo off dir >> d:\test.txt It will execute .MBX file(s) associated to an...more >>

Could the moderator please move all my posts regarding replication to the replication forum ? Thanks. ...more >>

when I run exec sp_dropdistpublisher @publisher = 'server1' i get the error Cannot drop server 'MACHINE1' as Distribution Publisher because there are databases enabled for replication on that server. what is the system sp to disable replication for a db ? ...more >>

Hi, I have an union join statement and sql give me the message : Server: Msg 4414, Level 16, State 1, Line 1 Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (256) was exceeded. When I count the table anf found only 78 table. I usi...more >>

Can I know how to convert a string of such format "31/05/2005 12:30PM" to date time in order to store in database. I have used this select cast(convert(char(19),LOGIN_DATE,103) as datetime) but it display index of out range.The purpose i want to store it in this format is because later i wil...more >>

I posted this in DTS group but did not receive any solution that I can use. So reposting I have to move data from 2000 tables from one Server to another (total 10 million records). The Servers are physically in different locations. Is there an easy way to create a DTS package to do the same? ...more >>

Hi All, I need help in setting recursive trigger option on for several triggers... Can you please help me.. If i set with sp_dboption it is for the entire database; i don't need that.. Thanks Moh...more >>

Hi, Is there a way i can set recursive trigger on for only a set of triggers or do i need to give on database level. Thanks Mohamadi....more >>

hi, how to conver the time to: dddhh -> Mon01 - Tue23? Thanks. ...more >>

i saw that if sub select contains aggregate, you should use outer join. I have to do a subselect because i only want the max(date) from one of my joined tables instead of all that meet the inner join criteria, but i don't see how to do it. Is there an example you can give me or a website to go l...more >>

Does anyone know of a product or way in which we can submit a dynamically created expression and determine if it is TRUE OR FALSE? We allow our users to activate certain expressions such as balance > 10000 and x < 3. We need to be able to dynamically evaluate the expression as true or false fr...more >>

We need to be able to dynamically take an expression such as 1 AND 1 AND 0 and have it evaluated. Anyone know of a way to do that without using an extended stored procedure. Needs to be a user defined function so that we can make it part of a select statement. thanks....more >>

Dear all, I got a problem when try to create user function. Can anybody help me? Below is my statement: CREATE FUNCTION test (@par1 int) returns int as begin declare @par1 int return @par1 end And got the following error: Server: Msg 170, Level 15, State 1, Line 2 Line 2: Inco...more >>

Hi all, I have created a trigger to insert a row into an Audit tables for specific users. when they update, insert or delete from tables in the DB. 2 questions: 1) can I capture what the user was doing? (insert,delete,update) 2) if Update can I capture the field(s) updated? TIA, Joe...more >>

Hello Everybody, I have query which is generating XML using for xml explicit. It is as following SELECT 1 as tag,null as parent, Id as [ROW!1!Num], FILENAME as [ROW!1!FileName!element], TransactionFlag as [ROW!1!TransactionFlag!element], Hours as [ROW!1!Hours!element], ProjectID as [ROW...more >>

Hello all: I am not sure if this is the place to get help formulating querys but here it goes. We need a way to get a total sum of a certain field for many rows but to not display some that belong to a specific category. For instance, lets say the category is "Stuff", and another category ...more >>

I have table on user interface. User can change different values on that table on each row. When clicks submit button I pass values for each row to stored procedure to create update on database. If table has 100 rows that means 100 calls to stored procedure and 100 updates. Is it pos...more >>

When making stored procedure changes, we always copy the existing stored procedure (change 'alter' to 'create', and append '_old_mmddyyyy' to the proc name. Well, the 'old' procedures outnumber the production stored procedures 3 to 1. I argue that these are still compiled, and consume system ...more >>

How do you re-insert the NULL statement into a blank field?...more >>

How can you re-set the value in a field to NULL?...more >>

I think CASE is what I need. Given 2 columns in a table, col1 and col2. In my data set there can be 3 cases: col1 and col2 are both not null col1 is null and col2 is not null col1 is not null and col2 is null Pseudo code to follow SELECT if col1 and col2 are not null then return col1...more >>

Hi, We are using SQL 2000 and grouping sales per group. We want the top n products of each group. We have the query working where we join the sales table on itself. The performance is not too good, we have better performance when query all sales grouped (no second join on sales) and fetchin...more >>

Hello, friend, In a function, I need it to call itself a few times. However, it seems that it is not supproted: When I created it, it said the function did not exist since this function was really not there yet. But, I do need this function to repeatedly verify certain values based on th...more >>

When running the following query: SELECT ID_i FROM OPENROWSET('SQLOLEDB','PARS100585';'abcp_admin';'Anna',abcp.dbo.Transactions) I get the error: Server: Msg 7353, Level 16, State 1, Line 1 OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during exe...more >>

I have an instance of SQL Server 2000 (SP4) running on Win 2K. On it I have a task that runs to decompose xml into tables using sp_prepare/sp_remove xml doc procedures and openxml. When the server is booted, or sql server and sql server agent processes restarted, it sits happily using abou...more >>

Hi All, I have created a trigger to insert a row into an audit table based on username. Is there a way to capture what the user was doing? (insert,update,delete) Also is there a way to capture what column was updated for an update? This way I can load my audit table with username,event,en...more >>

Boy it sure would be nice if CONCATENATE were in the list of aggregate functions! I know how to do this manually but it seems that it has to be done often enough that it would be good to have. I know it could be a little nuts if the column to be concatenated had a lot of characters in each row ...more >>

Hi! I want to insert records in a table when a special condition is met. The tables are Order and Project in the Order table, there is a field called proj as well in the Project. What i want to do is, if the Order.Proj does not exist in the Project database, i want to insert a new reco...more >>

Hi, Probably a very simple question but... I have a table which contains customer transactions. What I'm after is a SQL statement which will give me a count of transactions for the top four customers with everyone else grouped into "Other". The thing is, I'm not completely sure how to a...more >>

Hi, Under the Notifications tab of the job scheduling window, there is an option to update the status of the job scheduled. i.e., Write to windows application log file. Where do I find this file? I would like to know the physical path of the same? Regards, Sevugan.C...more >>

Hi I have a fairly common problem when calling a stored procedure from ADO using the OLEDB Provider for SQLServer. I read all the post I could find about the problems and all of them found a solution in including the SET NOCOUNT ON directive at the beginning of the procedure. I did that...more >>

Can anyone show me how to convert date time to "dd/mm/yyyy hh:mmAM"...more >>

Dear all, I would like to ask is there any way to write a SQL statement that display date and time such as "31/05/2005 1:30PM".All i had tried including the sample in the SQL online help, it seem that any of the code support this format. Thanx....more >>

Hello, I have got an sql: DECLARE @error int BEGIN TRAN INSERT INTO reports (a, b, c, d) SELECT dr.a, dr.b, ru.c, ru.d FROM dailyreport as dr LEFT JOIN reportunit as ru ON dr.id_dailyreport = ru.id_dailyreport WHERE state>=1 SELECT @error = @@error IF @error = 0 B...more >>

Hello, I have got an sql: DECLARE @error int BEGIN TRAN INSERT INTO reports (a, b, c, d) SELECT a, b, c, d FROM dailyreport as dr LEFT JOIN reportunit as ru ON dr.id_reportunit=ru.id_dailyreport WHERE state>=1 SELECT @error=@@error IF @@error=0 THEN BEGI...more >>

I want to test the multi lingual feature of SQL Server.. I have a database whith the default collation 'SQL_Latin_General_CP1_AS I have created a table CREATE TABLE [dbo].[emp] ( [eno] [int] IDENTITY (1, 1) NOT NULL , [ename] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON ...more >>

given the two following tables: CREATE TABLE things (thingid int, owner int, description varchar(50)) CREATE TABLE people (personid int, name varchar(50), admin bit) my plan is to implement a sort of security based on authority, the rules for which will exist in stored procedures such as the...more >>

What is the best way to quickly export all the data from a SQL2K database to an empty SQL database of exact same strucure on another network. I cannot connect the two servers in Enterprise Manager because SQL ports are closed between the two networks but I can get a remote desktop (VPN) conne...more >>

Hello, I just wanted to see if anyone had any ideas on how I could shorten this TSQL script. If possible, I would like to increase the 'day' range from -3 / 3 to -7 / 7 but this would extend the TSQL even longer. Any ideas would be welcome! Thanks! Anubis. SELECT ItemMaster.S...more >>

Hi, In "Inside SQL Server" by Kalen Delaney she says: "In SQL Server 7, all clustered indexes are unique. If a clustered index is built without specifying the unique keyword, SQL Server will force uniqueness by adding a uniqueifier to the rows when necessary. This uniqueifier is a 4-byte v...more >>

Hi there ... I have two identical tables. When the need arise, I would like to move data from tbl1 to tbl2, and delete the just moved data from tbl1. What is the best way to do this? I can figure this out by using INSERT and then a DELETE, but is there a more clever way to do this? -- ...more >>

We have a SQL Server at our main centre which is around 10 Kms from another sub centre. The sub centre connects to the SQL server at the main centre using VPN. The students then use a computer at the sub centre in order to view their scheduled classes, give their attendance and so forth. T...more >>

ho fatto un update che non dovevo senza fare backup prima come posso ripescare i dati??? gia committato ovviamente carlo ...more >>

-- Thanks ! ...more >>