I have table tblArticles where I have stock of all articles. Some of them are reserved. The reservations are in table tblReservations. If I would like to see all available stock, I should select all from tblArticles reduced with reserved articles. example: tblArticles:(PS_SIF is the p...more >>

Hi, is it somehow possible to modify a stored procedure within another stored procedure? E.g. I would like to take the output of sp_helptext "sp_myproc" modify the proc text and ALTER the proc. Does someone have a clue how this could work if the proc is > 8000 chars long? TIA for an...more >>

Bug in Query Analyzer appears after installing SP4 (and maybe earlier SP's but I haven't checked). Create a sproc in the QA but, instead of a space between CREATE and PROCEDURE, use a [TAB]. In the Sproc add a CREATE TABLE statement - two or 3 fields will do it. Save the Sproc When y...more >>

Here is a bug - maybe. I have an access.adp that executes a sproc on SQL Server 2000. The sproc contains a correlated subquery that updates the table ExcelData. Works fine until someone other than the dbo uses the project. The sproc will not update a table owned by any non-dbo user. The spr...more >>

I have a number in a table. By example: 87 I need change this a varchar but with format, by example '00000087' I need to make this change in a procedure.... Please help me!!!! In oracle I used TO_CHAR!!!!!!! It was easy... Thanks.... ...more >>

Dear Sirs / Ladies In HQL their was a MAX Function that would compare a fixed value ( 1.95 ) with a Column. An example is MAX( 1.95, RegularBasePrice ) If the RegularBasePrice was 0.95 it would return 1.95 or If the RegularBasePrice was 2...more >>

Hi all, I was wondering if anyone could explain this apparent anomaly. I have a fairly large table (600,000 rows) into which some regular processes are inserting and updating rows. (Inserts occur by means of a transactional stored procedure which inserts into this table and a secondary on...more >>

Hi, Is there anyway I can change the startup parameter without using enterprise manager for -dC:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf -dC:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.mdf Thanks Ed ...more >>

Hi, I have a stored procedure that updates a single table. A bunch of params are being passed in, and then there is a single update against a table. The output in isql/w however shows..... (0 row(s) affected) (0 row(s) affected) (17956 row(s) affected) (0 row(s) affected) ...more >>

Gentlemen and Ladies Below is the complete query that I have convert over from HQL to SQL and I am getting one last error which is Server: Msg 170, Level 15, State 1 Line116 Line 52: Incorrect Syntax Near ')' I am running lines 65 thru 115 when I get this...more >>

Hi, I have a table: TABLE1 ------------- ID int primary FIELD1 varchar FIELD2 varchar and I want to insert this table with increment ID (max ID + 1). When I use with 1 record, there is no problem: ------------------------------------------------ INSERT INTO TABLE1 (ID, FIELD1, FIELD2...more >>

hi i have a huge stored proc in which i created a few temp tables (#temp, #temp1, #temp2 etc). when i see the tempdb databse the temp tables are still there even after teh SP has executed, and returned no errors. i can t even drop them using drop table #temp because it has some extra chars...more >>

Hi All I am using MSDE2K and an application written in VB6 After installing MSDE and my program on to a new computer I am having strange problems when saving data which I didn't get on the old computer My connection string is... cn.ConnectionString = "Provider=SQLOLEDB;Persist Security...more >>