Hello, I try to install SQL Server 2005 Dev Beta2 on Win 2000 Pro SP4. In installer, I select all possible options to make sure that I don't miss anything. It appears that everything is fine (no errors reported), however the Workbench is not installed. SQL Profiler is installed and it has an ...more >>

I'm trying to get how many times each table is used in a collection of views. Run this against pubs for example: select type, count(type) from titles group by type Somewhere I'm getting some whacked out numbers. There query ran fine and gave me correct record sets until I added the count a...more >>

I am having trouble returning an error parameter to a VB 6.0 program. When I execute the below stored proc in Query Analyzer, it returns the 2 output param's fine. My problem is when I run it in VB using: With cmd .ActiveConnection = CNAD .CommandText = "CT_test" ...more >>

i have 3 columns in sql server .. all of them are numeric value when a user enter my site i take the value of userid (numeric one) i assign it as session("userid ") after a query i take 2 value (both numeric again) from my table and write this code if towhom=session("userid") then tow...more >>

I am developing crystal report on both database oracle and sql server When I migrate my report from oracle to sql server My problem is that in store proc we have to add @ before parameter name in sql server and in oracle it is a simple string , so how can I define parameter without @. Th...more >>

My question: Is there a way to get the value of an exec statement into a return parameter in a stored procedure?? The details: I have a stored procedure that is a simple query, but I want to apply it to multiple tables, so I created this statement: exec('select proj_outlinecode_id from '...more >>

Hi, This is my first post here - I hope you can help. We have an application that is written in Cobol, with embedded SQL. We are able to operate with Btrieve or Oracle databases, but we now want the ability to use our application with MS SQL Server. I am looking for a good precompiler to ...more >>

Hello All, I'm trying to build a stored procedure that will allow me to return all days of a current month, with the Weekday name as well. i.e- 10/01/2004 Friday 10/02/2004 Saturday 10/03/2004 Sunday 10/04/2004 Monday .... .... .... I'm trying to do this on the database tier so I...more >>

Hi I have a two tables, one TABLEA, one TABLEB. TABLEA id INT linenum INT thetext VARCHAR(255) TABLEB id thetext TEXT Example Data TABLEA id linenum thetext 1 1 HELLO 1 2 WORLD TABLEB id ...more >>

How can I stop DTS execution conditionally?...more >>

Thank you for your time and any help on this matter. /* Here a definition of my problem Let's say we make cars. We have several car features and their options that we can choose from but some options are incompatible and cannot be made by manufacturer for whatever reasons. I need to c...more >>

Do I have to go through install/setup again to change the default language over for the whole server? I know I can change the date format/language per session (SET DATEFORMAT) and (SET LANGUAGE) but I can't find a way to do this for the server. Thanks ...more >>

I am trying to access an Access Table. As suggested by someone in this newsgroup, I exectued the following in Query Analyzer: sp_addlinkedserver @server = 'Test' , @srvproduct ='Acces Db' , @provider = 'Microsoft.Jet.OLEDB.4.0' , @datasrc = 'C:\mydata\db1.mdb' When...more >>

I need to write a trigger to not allow an update on a column if it is set to 'M'. I think this is going to be an INSTEAD OF UPDATE trigger, but every example I've found of this, I haven't seen how to specify a specific case for the trigger to work or not. Could someone give me a hint or a bi...more >>

If you create an insert , delete or update trigger and ask it to write the original values of a text, ntext or image type field to another table you will get an error message saying that you can't use the text, ntext or image values in the trigger from tables 'inserted' etc.. Does anyone know ...more >>

I have a stored procedure that I am excuting via a job. The job is = only: exec my_StoredProcedure In the stored procedure I test @@ERROR and if not equal to zero I do a = return(12), for example. Everything works. The stored procedure = returns when there is an error, etc. However, the...more >>

How do I reference a global variable that was created in DTS package properties In "Execute SQL Task"? ...more >>

I am creating an application where the user creates a the forms and places the fields they want to use on this form. I need to dynamically creating the corresponding database. In addition it is possible they will want to modify the forms by either adding or deleting a field. I will need to rem...more >>

Hi Guys, I have a column in table [Modifiedstamp]. I need to set the value to current date and time every time a record is created in the table. What do i need to set the default value field. Thanks in advance. Manny Singh...more >>

sp_help (Select * From BlahBlah) doesn't give me the result I want. Basically I want sp_help to give the structure from a derived table. Is there something else that can give me structure from a derived table?...more >>

Table design question. I am dealing with measurements of buildings. All measurements are divided into area types (A..G), totaling 7 different area types. The area types may change (become fewer or additions), but this will rarely occur (say once every third year or so). If they change, prio...more >>

I get the following from a SQL Trace log on our UPS system communicatiiong with a SQL2K DB: ============================================== ShipUps 3a-e2 ENTER SQLExecDirect HSTMT 01D3DEA0 UCHAR * 0x01E9CB90 [ -3] "INSERT INTO tblShipLog (TotalFrei...more >>

Hi, Look at this simpe XML file (included below) and assume it's been exporeted out of SQL server. I would like to import this data (from XML file) into another DB (same tables, SP etc., just different DB). Now, OrderID (PK in Orders table) is certainly going to be different in a new DB so, w...more >>

I want to Dyanmically Choose the table and then Get the information from that table and update an another table My code looks like 1. Get the required information Create Table #Temp (Name Varchar(255), Salary Varchar(255), County Varchar(255), CountyCode Varchar(255) ) Insert into #Te...more >>

I have a stored procedure that calls a COM (third party) object method. The COM object connects to a Btrieve database. The stored procedure works fine when the Btrieve database is on the same machine as SQL but has a permissions issue when the Btrieve is on a different machine. What user do I...more >>

Hi there, I have subtotal1, subtotal2 in my table Test, I would like to sum(subtotal1) and sum(subtotal2) into one total based on the condition, if subtotal2=0 then sum(subtotal1) as total, if else then sum(subtotal2) as total, but all the sum need to return one total. Please give me some...more >>

Hi, I have a table containing the following data machine varchar(25) code varchar(10) m1 vvv m2 dbd m3 gdh m3 th64 m2 vvv m5 vvv m4 ths m4 66g m1 kk8 m3 j88 I want to search on a specific code (vvv) by machine. Basically I require...more >>

I'm trying to call a UDF on a linked server and I'm having issues! Firstly, the UDF takes 2 parameters and returns a table type. Microsoft Knowledgebase Article KB319138 tells me that I can't call a UDF in a four part linked server query. ie. I want to do select * from Linked_Server.Da...more >>

Starting with a statement like this one.... Select Name, Departement, City from A union all Select Name, Departement, City from B I whish to get Name, Departement, City, TableName Helene, Software, Denver, A Paul, Hardware, LA, ...more >>

I want to import data from an external source. However when I run the import wizard I get prompted for a usernmae and password when doing the import. However I wish to script the import to run at a given time, but will not be around to run the script and therefore will not be around to enter u...more >>

Hi, Can anybody help me with the following problem? I have a query that starts to run very slow as soon as I do a GROUP BY, but it should not. If I store the results temporarily in a table-variable than the GROUP BY isn't slow. Some more details: The following query runs very fast (<0,5sec...more >>

I would like to form query like this: SELECT Account, Name FROM ( SELECT BankAccount AS Account FROM BankAccounts WHERE BankAccountID = ( SELECT BankAccountId AS Account FROM OrderDetails WHERE OrderID = 1005 ), SELECT Authority AS Name FROM Author...more >>

We are in the process of designing a database with a number of tables, However we wish to create two table that ref another table for a listing of departments. Therfore we need to create a dropdown list within 1 table from another. Can anyone help....more >>

I have 5 tables wich contains the same kind of data: Name, Departement, City, etc.... I cannot change the design of this database since this is my customer datanase, and the table do not use any foreign keys. How do I query do get all the names, department and city from all tables: i.e.: Se...more >>

Hi I'm looking to write an extended stored procedure, the job of which will basically to read data from one table, process it using a COM object, and write (insert) rows out to another table. I don't really know where to start with finding the functions necessary to read from an existing tab...more >>

I need to pass an array from an Excel VBA routine to a stored procedure that will create a temporary table and then insert the desired into the appropriate table. I have created the stored procedure and tested it using local variables. I also have a routine in VBA that generates the ar...more >>

hi, I have a column in my table that has either 1 or 0 as values. The reason why it's not a bit field is a third option may be added later. I wish to update it so that all the 1's become 0' and all of the 0's become 1's. Could anyone point me to an example i could use to do this as i am a be...more >>

Hello, I'm having difficulty joining a table variable and a table in a select statement. The problem lies with the fact that the column I'm trying to join the table variable on has the same name as the column in the joined table. My TABLE variable is defined as follows: DECLARE @dis...more >>

I see a frequent response to post's here - something like "well, if you'd just Google this group you'd find many threads...." Can someone tell me specifically what it means to "google this news group"? I know there area a bunch of great tricks for making google focus on one specific area - how...more >>

Hello All, I pose this challenging situation to see if anyone has any suggestions as to my solution: PROBLEM: Text files with dynamic name are stored on one of several web servers. Each web server accesses the same database. On the database there is a stored procedure which is called...more >>

Here is my update sql UPDATE [TimeOffSQL].[dbo].[tblEntitlement] SET decNextBorrowed = decYearDurationTotal - 28 WHERE (28 + decPreviousRollOver - decPreviousBorrowed + decExtraDaysTotal + decNextBorrowed - decYearDurationTotal) < 0 But I need another condition on the WHERE ie How do I ...more >>

Hi All, I need to design a series of database tables to hold information from a treeview control. The treeview control holds information regarding a series of discussions. For example - Root Topic '- Child Reply '- Child Reply '- Child Reply '- Child Reply ...more >>

I need to determine the differential (increase/decrease) between a record and its predecessor/previous record in a table Lets say I have the following records: col1 col2 00 40 10 60 20 85 30 95 25 110 The table i need is the following: col1 col2 NULL NULL +10 +20 +10 +25 +10 +...more >>

In the last few days I spent on newgroups I saw maybe 10+ questions about this above mentioned subject on how to do it and speed it up etc, one of the questions by myself. I don't have alot of whitepaper behind my name but I can get anything I require from almost any language, it might take...more >>