I maintain a products module and have some issues in keeping prices updated. Our product records each have 6 pricing 'levels', each price level has an associated formula for calculating the price based on several cost factors, and has a set of rounding parameters for each level so that each pr...more >>

Is there a function to check if column accepts null values (nulls allowed or not)? SK ...more >>

Hi I have a table called "Member" as given below.. familyID memberID firstName -------- -------- -------------------- 0 7 Stuart 0 5 Kasey 0 1 Sally 0 2 Cooper 1 9 Rosemary 2 3 Lisa 2 6 Steph...more >>

Hi, I have SQL Server 2000 in my Windows Server 2003, there're 11 databases running my company's applications. I am thinking backing up the databases to my PC, in case a complete server failed and the server just dead. What do I need to backup from the SQL Server? If I installed another SQ...more >>

Hi All Haw can i Run (Select * From MyTable ) In Sp With Create SQLDMO.SQLServer Object Thanks ...more >>

How Can I Do This CREATE FUNCTION [test1] () RETURNS TABLE AS RETURN (Exec MyProcedure) ...more >>

Hi, I have a stored procedure that requires several input parameters. I would like to join the results of the stored procedure with another table but I'm having a tough time getting the syntax correct. For example: To run the stored procedure: exec usp_FetchPeople(@Gender = 'F', @City = 'Bost...more >>

One thing that I cannot find anywhere is a simple explanation of which one has more features. If I go with the Developer edition of SQL Server what do I give up over Enterprise, or what do I gain that Enterprise edition lacks? Thanks in advance, Joe in Florida ...more >>

Not sure if this is possible with SQL. I got a table invest like below investor_id invest_term invest_class amount 1 2 short 5.5 2 7 short 15.5 3 90 mid 20.0 4 ...more >>

Yet another one on this error. I installed Vista Ultimate, VS2005, SQL Express (.\SQLEXPRESS), applied SP1 and installed Management Studio Express. When I want to create a new database, it gives the following error: CREATE DATABASE permission denied in database 'master'. I am an admin o...more >>

Hi all; I have customerID ,order,orderDate......how to write a query to show what is the latest order a particular customer has ordered.... remember the same customer may have several rows in the table ,but they might not be organized based on the date. I need a query to select the lates...more >>

Very frequently, roughly every 10 seconds, I need to load data from a staging file. The data will not load directly into the destination table(s), but needs intermediary processing. The amount of data with each load will be smallish (dozens to maybe a thousand rows by ten or so columns), so id...more >>

Hi all i just wanted to know what are cubes and how do they help in optimiztion of a query.. what are their uses.. and how would a traditional query would turn out to be more effiecient with the implementation of cubes.. Thanks for replying me... ...more >>

I have checked with our DBAs and the default setting for the database I am using is SET ANSI_WARNINGS OFF. Several of the stored procedures and triggers I inherited were setting them OFF at the beginning and back to ON at the end. This was causing 2 recompiles every time any of these objects w...more >>

Hello NG, we have a store procedure in which we create a dynamic SQL statement in the following way: declare @myCommand NVARCHAR( 4000 ) SET @myCommand = N'SELECT ...' SET @myCommand = @myCommand + @param1 SET @myCommand = @myCommand + ... .... EXEC @myCommand + @mySubSelects + @...more >>