I have been migrating an MDB to SQL and have had to rewrite many of the queries into SQL Views. The problem I am having is that SQL doesn't seem to be able to use progressive formulas. Here is what I mean: I have a commisison calculation that requires about 20 differnent variables. Example ....more >>

I am the owner of a database. I am listed as an owner as is dbo. All of the stored procs were owned by dbo. There is a user on the database named EDUser. EDUser was granted execution rights and everything was good. That is until I created a stored proc. EDUser was granted execution righ...more >>

Hi, Do you see the following sample as "smart". ---------------------------------------------------------- | ID (int32) | Code (uniqueidentifier) | Title (nvarchar) | ... | ---------------------------------------------------------- ID is the key. I use this key also as foreignkey in other t...more >>

Hi I have a table1 which hold a field (amount) with 1000 rows The amount in the 1000 rows is consumed by clients during the day The next day the amounts have to return to their original values (at this time I’m doing that by hand) Now I’m going to save the original values in anothe...more >>

Hi, When I use insert/update/delete statements in UDF I get error: CREATE FUNCTION FOO(@DUMMY VARCHAR(128)) RETURNS BIGINT AS BEGIN INSERT INTO MY_TABLE (MY_FIELD) VALUES ('xxx') ... ... ... END "Invalid use of 'INSERT' within a function" Is there any way to use ins...more >>

How do kill all the processes in a database? Here is my situation; I copy a database called “Active” into a database called “Training” once a week. If there are still students logged into the Training database the job fails and I have to go and kill all the processes related to the T...more >>

I know one way (but it is complicated (using fetch)) copiing all data from one table to another table with the same fields, but with different table name. Could you tell me the easiest way to do that ?...more >>

How to interprete the result set from this query (the filter: AND E.deptno IS NULL in the ON confuses me): Result: Deptno deptname empid empname deptno jobid salary ----------- --------------- ----------- ---------- ----------- ----------- --------- ...more >>

I tried to attach mdf file without ldf file. However: "Error 1813: Could not open new database 'GJIRB'. CREATE DATABASE is aborted. Device activation error. The physical file name 'C:\ ...\db_name.LDF' may be incorrect." Then: "Attaching database has failed." If one has not have ldf file is ...more >>

Hi, I am executin a stored procedure which contains a sequence of Stored procedures. One of these stored procedures is a cursor-stored procedure (basically a cursor). At the end of the execution of this Stp(cursor), it gives me "query batch completed with errors". I tried to capture the er...more >>

Nilkanth Desai nsdesai@tis-world.com I am using SQL Server 2000. In this case database size is 750 MB and since last 10 days its logfile is constantly increasing its size. Since last 2 days it has crossed 14GB. Thses logfiles are having extension of .ldf. I have tried shrink database optio...more >>

What is the SQL for dropping a table on a linked server? Using: DROP TABLE LINKEDSERVERNAME..USER..TABLENAME doesn't work. ...more >>

Hi, I need to disable all the foreign key and primary key constraints in a table and reenable them at the end of my commands. I can use ALTER TABLE to do this but I was wondering if it is a good practise. It is not maintenance code but production code. Everything is done in a transaction b...more >>

Hi all My tempdb data file increased upto 45Gb and it is 99% free. I try to shrink it but it was not shrinking. But after some time suddenly it shrinks. Why this happens? Why it was not shrinking before? -- Thanks ...more >>

I have this code here that has its WHERE clause dynamically built... -- Calling Code DECLARE @matches INT SET @matches = 0 DECLARE @whereClause NVARCHAR(4000) IF @clmrKey IS NULL SET @whereClause = ' WHERE ...' ELSE SET @whereClause = ' WHERE ...' DECLARE @sql NVARCHAR(4000) ...more >>

Hi, I have a table like this: StringID,LanguageID and StringValue. The table contains strings in different languages. Strings with the equal meaning have the same StringID but a different LanguageID. Here is a example: LanguageID 1 - english 2 - german StringTbl 1,1,home 1,2,Haus ...more >>