Hi there. First let me apologize for attempting to post this message a minute ago and somehow posting it before I had finished writing it. I want to create a web based software rating database. I have a number of objectives that I would need to achieve to make this a useable tool and some ar...more >>

Hi there. Looking for some feedback before undertaking this project. My db knowledge and asp skills are beginner at best but with the assitance of an asp code generating tool I believe I could take a pretty good crack at this as long as I can get some help from time to time from the kind of ta...more >>

Im doing a select that should retrieve a name from one table and display the number of correct bets done in the betDB (using the gameDB that has info on how a game ended) I want the "MyVAR" value to be used in the inner select statement without too much hassle. As you can see im trying to get ...more >>

Hi, I know that physical order of a column is not important in tables but I like to know if it is possible to force column order when I alter a table to add column or change the order later. It seems that the orders are stored in syscolumns table but I think there should be a system sp/func to ...more >>

Hi, 1) I just wonder why I can execute sp_helptext stored procedure when I am in NorthWind database. sp_helptext is in Master database. 2) Information_Schema.tables is a view, but why I could not use sp_helptext to look at it is schema. Thank very much! George Meng ...more >>

I have a situation where I have a job master table (construction jobs), and two detail tables for job hours and job materials. So the data might look something like so... JobMast JobNumber 1 2 3 JobHours JobNumber Employee Hours Date 1 1 8 1/1/04 1 1 8 1/2/04 2 2 1...more >>

I have a situation where an application is being built where NULL values appear in foreign keys. (It's not my idea, I'm trying to convince them otherwise). The situation is a history file that has both a customer and a sales rep column. In some instances, both are populated. However, in ...more >>

How can I pass and declare a string into the stored procedure that its where clause like below: select ... from ... where xx in (@input parameter)...more >>

Hi, Please let me know the query to list all the table names in a given database in sql server 2005. Best Regards Raghu ...more >>

Hi. Is there any way I can turn off parallelism for one (or more) prosedures. I do have some prosedures I want to test without using prallelism. thanx all -gh ...more >>

I have a join like this select len(t.area,3), len(t_1.area,3) from Table1 t join table1 t_1 on t.id=id where len(t.area,3)<>len(t_1.area,3) The problem is that I get lots of records where len(t,area,3)=len(t_1.area,3) which contredict the where clause. area is a varchar(10). Does any...more >>

Hi, I need your help. There are a Function in Oracle and Fox that is PADL or PadR, this add a quantity of characters to the left or rigth, all depend which one you like, the parameters in this function is a string, the character that user likes to add (the normal are zeros and spaces), and...more >>

I have the following trigger on a table: ALTER TRIGGER INS_UPD_TRG1 ON dbo.tblInspection FOR UPDATE, INSERT NOT FOR REPLICATION AS DECLARE @OldVal char(1), @NewVal char(1) IF UPDATE (priority) -- We only want to capture updates to the priority column BEGIN SELECT @OldVal = (SELECT ...more >>

Hi everybody, I've a empty table with the column 'Id' as Primary Key. Can I modify it, setting Id as NO Primary Key ?? I need to do it because I decided to handle DB sync between peripherical DB and Server. After the first Sync, the server gives to the client its Location_Id and the Indentity ...more >>

Hi' Does someone have a script or stored proc that can copy a running database? i need to make a copy of it without shutting it down, so I guess sp_detach and sp_attach arn't an option....more >>

I'm in the middle of creating a stored procedure and I have a lump of code that is repeated twice but with a very minor difference... if the bit variable @UseCalc is 1 I want to include another field in the query's WHERE clause. (Full current code at bottom of email) I'm sure it's silly (not ...more >>

Hello there I have 2 dimentional query: 1. TreatmentPerson 2. TreatmentType 3. Treatments amount I need to show this query as crosstab: Person as Columns Type as Row and the amout as the value. The amout of treatmentPersons is not constant. How can i create dinamic crosstab query for...more >>

Can some please tell me what SQL doesn't think is right with my syntax: create function fConvInt2Date ( @input int) returns datetime as begin declare @return_value datetime set @return_value = cast(substring(cast(@input as varchar(10)),1,4) + '/' + substring(cast(@input as varchar(10)...more >>

Hello, I need a function that gets the first day of the current quarter. example : GetFirstDayOfQuarter(@date) must return the first day of the quarter Does such a function exists in sql server ? Can anyone give me some help how to create such a function ? thx!! Gene ...more >>

I am using the following in a stored procedure, the basis of which I copied from an SQL sample. RESTORE FILELISTONLY FROM DISK ='C:\SludgeXX.bak' RESTORE DATABASE SludgeTest FROM DISK = 'C:\SludgeXX.bak' WITH MOVE 'Sludge' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\Slud...more >>

Hello Gurus, I have a situation where i think only triggers can solve my problem. The other problem i have is that i have nere written any such thing and my deadlines where passed. I need to to update a table when a new row is insrted in an other table. How can this be done? The other ...more >>

I am trying to write a scrit that uses a while loop. Is there some special command I need to use in order to have it run error free? Here is my code: drop table #employee_dim go --first load before loop select distinct regimental as HRMIS_ID, ' ' as Given_Nm, Initials as Initial, ...more >>

sql 2000 I have DB that contain Stored Procedure and function, and some tables. How create a schedule job that scripting or backup schema only Without Data? ...more >>

hi, is it way to create ONE trigger for insert,update,delete which can apply for all tables? is it a trick with stored procedures? There is two field in every table: "last modified" and "created" datetime fields. I want a trigger what set the values automatically... ...more >>

How do i add two columns and always get a result - even if one of the columns is NULL. Is there some function I can use to this purpose? /Anders ...more >>

Here is an example of a table that keeps a list of tasks and the time it takes to complete them (in minutes) TaskID TaskName Duration_Minutes ------- ----------- ------------------ 1 Task A 100 2 Task A1 20 3 Task A2 ...more >>

I'm using XP_Sendmail stored procedure to run a query and mail the results as an attachment in the resulting email. The process works fine except that the attachment (whatever.xyz) is apparently in UNICODE and the application that subsequently consumes the attachment (when double-clicked in the...more >>

Hi I've a following trigger which is fired in update status and make all changes to a new table successfully,I've a question: I just want by changing the emp_name column in first table the emp_name in second table changes(this happen by login L1 which has permission to the destination table...more >>

This is a result set from a query that I need to find the LINE that corresponds to the MAX(BUILT) entry. IE for PART 48899 I need to return 8630. For PART 21908 I need to return 8650 ETC. Is there a way to do this without a cursor? The end reult set should be.... 48899 8630 21908 8650 ...more >>

Hi, I wish to obtain an incremented value while I am in a stored procedure. So I am trying to do this (sql somewhat simplified just to get message across). declare int @nextnumber set @nextnumber = select max((revisionnumber) + 1) insert into tblrevisions (revisionnumber) values (@nextnumb...more >>

Hi, Does somebody know how to make AUDIT with TRIGGER on BLOBs FIELD? Thank you for your help PaoloRi...more >>

Hi, I'm trying to create a baseline information of SQL Server consume using sysprocesses table. My ideia is to get one snap-shot of sysprocesses, after a few seconds (10 seconds) get a second snap-shot of sysprocesses, and get the diference of CPU, Physical IO and Memory Usage. But wh...more >>

Hello, i have very simple problem to ask.(I think). I have a table where I have next kind of data number end_date end_time 3734628 2004-11-23 10:03:50 3734628 3734628 2004-11-24 10:10:22 3738611 2004-11-25 13:06:50 3738611 3738611...more >>

Hi NG, I hope very much someone can help me or at least point me in the right direction here. I have a simple Stored Procedure and all it does is it adds 4 different indexes to a rather large table which is built daily. It has been running for 6 months now without problems, but today I foun...more >>

Hi, How do I find records for the previous month, taking the year into consideration. So when its 01-01-2005 my query will be looking for 01-12-2004. (British date format) Cheers...more >>

When I add a SQL Authenticated User, I get an "Error 2758" message - without any description. Any ideas? I am running SQL 2000 SP3a on my XP sp2 laptop. I am d/l the SP3a to try to re-apply the SP. -- -Kevin...more >>

I have a problem on doing searching in this huge table. I tried this statement - > select * from table_A where month(sales_date)='5' It took me quite long to retrieve the record, any help to increase the speed of the record retrieving? Cheers...more >>

I am building a system that has 10 tables. Each table may relate to each other in varying ways. For example, lets say I have the following tables: Users Companies Employees Documents The relationships I want are as follows: Users > Companies (1 or many to many) Users > Employees (1 or...more >>