Hi , i need some help . My problem is referencing a column from another tables column let say these two are my db tables . I want pro_price in Products to be taken from price in Products . Whenever price in Products is updated , pro_price in Products is updated too . How can i do ? CREATE ...more >>

I need some urgent help with copying an image field from one SQL Server table to another. This is a vb.net web application with a SQL Server 2000 database. I need to be able to copy a signature, without the need to display the signature on the web page. Have been trying to do it with a sp w...more >>

hi i need the module function in SQL es mod(34-35)=1 thanks Carlo ...more >>

Hi all, I want to design the security of my application. It seems that I must not use object permissions because every time the users attempts to read/modify/delete a record, he may encounter with a handled error stating that you don't have permissions to perform this task and etc. But I wa...more >>

Hi all, Suppose that client A and client B read a record and B begins editing that. Meanwhile A attempts to delete the record. Our project's rules says that the record must not be deleted while it is being edited by other user. Whereas our clients are disconnected, client B cannot lock the recor...more >>

Firstly, apologies if this it the wrong place to ask! I have a stored procedure which builds some SQL in an nvarchar. I can, of course execute this SQL with EXEC(@mySQL), but how do I access the recordset that is returned *while still within the stored procedure*? Basically the SQL returns a...more >>

MyTable StudentId ClassId MergedClassId DateIn DateOut 1 101 NULL 9/3/04 12:00 AM 10/12/04 11:59 PM 1 102 101 10/12/04 12:00 AM 10/13/04 11:59 PM 1 103 102 10/14/04 12:00 AM 2 101 NULL 10/12/04 12:00 AM 10/13/04 11:59 PM 2 102 101 10/14/04 12:00 AM ...more >>

Hi all. The following select returns 2 as the number of the week. I our calendar it is still week 1. Is there any settings that controls this? We have tried the Set DateFirst, but it will not make this select correct. SELECT DATEPART(ww, '2005-01-08') thank's all. -gh ...more >>

Hi, I like to know if there is concatenate function available in SQL script. I like to combine two columns together as a unique key. Please help. Thanks in advance and Merry Christmas Sarah ...more >>

This is absolutely driving me crazy. I ran into a similar problem a couple of months ago and never got it resolved. That time we just lived with the extra time. Can't do that this time. DDL and Data would be hard to provide, but here some SQL broken down to just the basics of the offending co...more >>

I have an application that enters employee timesheets. The start time and end time is entered into each record and the timesheet date and this time are stored in separate fields. I need to be sure that there isn't already time entered that falls within the range of times already entered for tha...more >>

I'm trying to update a variable conditionally based on the value of another variable. I've tried a couple of different things with CASE but can't seem to get it to work. Any Suggestions? --Jon DECLARE @cen_dtime AS datetime DECLARE @cen_count AS int DECLARE @cen_shift AS int SELECT @cen...more >>

Is there a SQL command which will kill or exit all batches in the query analyzer? For example I have this script: query1 query2 GO query3 query4 query5 GO Is there a way so that when I check @@ERROR after query1 that query2,3,4,5 do NOT get executed? GOTO's cannot see beyond the ...more >>

The following query returns rows where the time_id IS NOT NULL. This query seems to be breaking SQL Server(?) select bus_date, time_ordered, time_id from [vicorp\gillic].pmix_fact1 where bus_date = '2003-11-01' and time_id is null order by time_ordered The following query does...more >>

I am having trouble calling a stored procedure from my vb code. I am trying to call the xp_cmdshell extended stored procedure. I was successful calling it from query analyzer, but not in any code. I realized I was logging in as myself w/query analyzer. As myself, I have system administrato...more >>

Dear all, Now, I would like to insert data into one of the tables in the database. However, the error message "The log file for database 'DT_Data' is full. Back up the transaction log for the database to free up some log space." occurs. What should I do for the log file? Please help. Tha...more >>

Hi collegues, Just a several questions: First one: How can I reckon when a task will finish? I've got the following status: 51 RUNNABLE DW-E01\Administrator nt-ES06 . GERMANY DBCC 436080 4168914 12/17 15:23:26 MS SQLEM 51 If I launch this I don't...more >>

User changes the ID field from ProductID01 to ProductID5001. How do I programmatically update the associated recordset in the other tables to reflect the ID change? ...more >>

Hi all, I have just read an article in the Enterprise Server magazine dated December 2004. On page 23 it recommends for optimising your database that you can set up indexes, and in addition keep these on a seperate disc to the database... I have not used indexes in the past, but having ...more >>

How can you get the application to check for a cacasding relationship when a user attempts to delete a record from the parent table? 1. User attempts to delete a customer record from the main table 2. The parent record has five records in the order table. 3. Insert a message that says "No,...more >>

I need to expand this stored procedure which is already beyond my current tsql skill level... which is pretty darn low. hehe. I'm working on my first project that utilized stored procedures... The one below is actually the first one I had to create. I use the following stored procedure to bind da...more >>

I'm trying to update a partitioned view, updating all the records in the view from a staging table -- updating the records from the staging table that don't exist in the view already. The view is updatable -- I know the rules, and I can open the view in EM and actually change the data in t...more >>

Declare curr_notify cursor for select RTRIM(SERVICEEMAIL)+';'+RTRIM(OTHEREMAIL) AS Email, 'Call number'+' '+RTrim(callnbr) as subject, 'Call number'+' '+RTrim(callnbr)+' '+'for'+' '+ RTRIM(custnmbr)+' at '+RTRIM(adrscode)+', '+RTRIM(svcdescr)+', '+' has had the status changed to '+RTRIM(ST...more >>

I am working with an existing billing situation where changes to accounts are posted in a "journal" with the change and effective date. I need to select a record for each account between two dates... which I can achieve with this: "..WHERE effective BETWEEN date1 and date2.." Thats ea...more >>

Hi! Can I manage what table give the sort order of rows what are results of two joined table. Exists a hint, clause or command what able to select the wanted table? Regards, Imre ...more >>

Hi collegues, Just a several questions: First one: How can I reckon when a task will finish? I've got the following status: 51 RUNNABLE DW-E01\Administrator nt-ES06 . GERMANY DBCC 436080 4168914 12/17 15:23:26 MS SQLEM 51 If I launch this I don't...more >>

I haven't received any real hits on this when I have been searching online. Does anyone know what the following runtime error means. I am running it from vb6. I assume this is an sql thing and not really a vb thing. The request for procedure 'xp_cmdshell' failed because 'xp_cmdshell' is a ...more >>

Please help!! I have two stored procedures and I want to merge the result of both table in one based on the month , for example: Stored_proc_1 displays: Month | SaleTotal 1 | 100.00 2 | 200.00 3 | 300.00 ----------------------------- and Stored_proc_2 displays: Month...more >>

Can I move the .ldf from my E: Drive which has 200 mb left to my F: drive that has 18 GB free? If so How and there any issues. ...more >>

Is there any way to copy Enterprise Manager Settings from one machine to another machine. I need to do it on 4-5 machines and it is kind of a pain to do it manually. Thanks in advance. ...more >>

Hi all. newbie here, The value in the database Field is "Car" The String being submitted is "CarModel" Is there anyway that if I search using "CarModel" that Car would be returned SELECT * FROM VehicleDetails WHERE Vehicle like 'MMColVehicle' AND Manufacturer = 'MMColManufacturer' AND M...more >>

I'm new at this so hopefully someone can help. I've seen a few examples but I can't get the correct result to return. Here is what I have. But it doesn't quite work...Somewhere I'm dropping the Contracts SELECT p.Contract , MIN( p.MNTRVU ) AS CommonTRVU, p.Div_Cat FROM ( SELECT p1...more >>

Hello, I am a bit of SQL server rookie. I currently have a spredsheet with data that I want to import into my database. The data will need to be transformed in somewhat of a complex way, splitting it up into different tables. The way I envisioned the process was: 1. Import spreadshe...more >>

I am new to sql server & DTS; I would like to accomplish the following: table A has 3 columns ( id, priority, name ) I need to extract all priority 1 records, checking every 2 minutes. I would like to only extract those that have been inserted since the last check. 1) select current_max...more >>

Is this an undocumented stored procedure? I can run it, but it doesn't show up in enterprise manager with the other stored procedures. Am I doing something wrong? Thanks...more >>

Hi I am trying to update a partitioned view within a stored Procedure. When I run the update statement manually it suceeds without any problems, however when I try and call the stored Procedure, I get a message saying that the view is not updateable because it references a table in the defi...more >>

Hi. I have a table column as follows... Name - Footage DataType - Decimal Scale - 6 Although the scale is 6, I need to select only 3 digits to the right of the decimal. I'm trying to use the following CAST statement but this does not work. How can I select 3 spaces to the r...more >>

I need to return the most current entry from a table. I'm not sure what would be the most efficent way to do this: here is my query: select top 1 crtRow,crtCol, crtChr, crtType,crtBrR, crtseq,crtDate from crt where crtcsiID = 1003 order by crtDate DESC I guess i'd like to know if there is...more >>

What do I need to do to allow 1 stored proc to perform an isnert/update/select on 2 physically different servers? Same domain, same LAN. ...more >>

I created a trigger (for Insert, Update) to calculate two columns in a table and insert the result into another column in the same table (checks/balances). The trigger I created works on each insert and update but does not fire when I update multiple rows. How to write the query to catch m...more >>

Hi, can anybody tell me the perfect situation where we have to use UNION instead of join. i will be really thankful if i get a small discription abt the main difference between these two. thanks in advance -- Deepson Thomas...more >>

Hi i was reading a small note written abt the difference between delete and truncate in sql. I have some doubts in that 1) "The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the ...more >>

Hi all, I have this table: pid [int], ptitle [varchar], pdup [bit] There are some duplicate ptitle records which I don't want to delete. Rather - I want to update their pdup with 1 for all duplicate records, but 1 (any one). So in the end I'm left with only 1 ptitle that does not have a ...more >>

Hi Is the foreign keys automatically create index or we need to create index on the foreign keys also. ...more >>

Hi, I've got a problem with a stored proc using the FOR XML AUTO, ELEMENTS clause. It's returning the following message: [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server However, when I run the select statement in the proc, it returns the XML string ok. Any ...more >>