How to Debug the Stored procedure in SQL 2005. I thnk its thru VS, pls let me know the details or any references. Thanks -- RKNET...more >>

I've a Bill of Material table that looks some what like this: Table BOM: Part# Component# 1 A 1 B 1 C A X A Y B M B N B O B P B Q B R R ...more >>

Hi. I am trying to set a trigger to send an email notification. is this possible in SQL 2000? What i am trying to do is send an email saying that a client has been here for 12 months and would like to raise the rent. Regards Wilbur...more >>

Hi, I wonder If I can have both SQL2K and SQL2005 installed on my windows XP box. TIA, Jorge Luzarraga C ...more >>

Hello Everyone, I would like to know if there are any major changes in client connectivity when connecting to SQL Server 2005 vs. SQL Server 2000. I know about a few of the new things, such as using Native Client, Shared Memory, and the Dedicated Admin connection. Are there other big change...more >>

Hi All, I ran the following sql statement in the command line : osql /Usa /Psa /Sjpham-pc -l60 -Q"select version from master..sysdatabase where dbid=1" -o file and the error message return back is :Invalid object name 'master..sysdatabase'. It worked on MS...more >>

I am storing financial data (stock prices, profit and loss figures, etc..) in a SQL 2005 database. The database will be updated with a high frequency. I am debating whether to use decimal or double/float to store these values and I am concerned that using decimal will slow down the database. S...more >>

Here is a sample Stored Procedure: Create PROCEDURE spSample AS SET NOCOUNT ON DECLARE @ErrorMsg varchar(8000) BEGIN TRY --the following error will be caught and returned to vb.net 2.0 --declare @var int --select @var = 1/0 --the following error will be caught but will not be retu...more >>

I have a requirement that I need to extract person's data from multiple tables, along with checking to see if they are twins. The 'twin' logic is if they have the indicator of 02, 03, etc. as the dependancy code and they have the same sex and birthdate are the same. so my query looks somethin...more >>

Thanks Dan, I alread tried = and got the same error. Where would I find an update trigger (on the Inventory table)? -- Keith Kubicek ------------------------------------------------------------------------ Posted via http://www.codecomments.com ----------------------------------------...more >>

Hi, I'm accessing a pair of databases with ASP.NET 2.0 (ADO), and using stored procedures on the first database access. SQL server 2005 is local: Client and server are on the same box. The first access works OK - everything gets written to where it's supposed to be. On attempting to wr...more >>

If I understand what I am doing .... I can run an unnamed parameter query in Query Analyzer SELECT au_lname, au_fname FROM dbo.authors WHERE (state = ?) However, that is about all I can do with it. I have not been able to do anything with named parameter queries. I gu...more >>

I'm using VS2005 pro to develop one windows form and one Mobile5.0 app , they are simple apps and just connect to SQL server to get data. The SQL servers include Win2K + SQL2K, Win2K3 + SQL2K5 std and Win2K3 + SQL2K5 Express. All works fine until one day I updated Win2K3 patches to the sql se...more >>

Hi, I'm trying to round a very small negative number, e.g. -.024, to a string. If I round -.024 to 1 place, I get 0.0 However, when converting to string, I get .-0 Is there some combination of functions to get rid of the minus sign in such a situation, or do I have to put in an IF condi...more >>

Hello, I experienced extreme slowness on performance when I did multiple joins on global temporary tables, I checked the query analyzer plan and found out that multiple table scans were occuring. Does anyone know why the system behaves like that? The following is a sample of my query af...more >>

I'm trying to build a query that I'd like only run on records with an odd number in a specific field. Using the "MOD" function, I'd simply throw a criteria in that says where "Field Mod 2 <> 0" Is there a mod function in SQL Server 2K? I can't find it... If not, what's my alternative? ...more >>

I am trying to incorporate error handling into a SQL script that creates several database objects. Those objects are referenced later in the script by other blocks of code. It is my understanding that I need to use a new batch to reference an object that was just created. I can do this by...more >>

Hi, How can I run a script in a job and call it from a drive location? ie. the script file will be located on a network share. The script is more than 3200 chars so I cannot call it in the job step. Thanks....more >>

Greetings, We are trying to use sp_executesql to perform integration of SQL Server 2005 with a .NET application. We are receiving an error "Incorrect syntax near <sp_name>" which we have been able to verify is working via direct query. So in other words, ... sp_name ....succeeds, wher...more >>

How do I query the extended property of a column (like MS_Description property). I run the following query and SqlServer returns nothing. But I see the description in enterprise manager. Am I missing anything here please? SELECT * FROM ::fn_listextendedproperty (N'MS_Description', N'us...more >>

I'm trying to write a VB CLR stored procedure that will set the return status to 0 or 1 depending on whether the CLR was successful or not. How do I do that? Basically I want to use the following T-SQL code to call my CLR and set the @return_status declare @return_status int EXEC @return...more >>

Hello I have created a database that uses an int for the table primary keys. This database is being deployed at several sites. Each site has a unique site ID which is less than 100. There is another database that acts as a master viewer. This database holds a copy of all the site database...more >>

I have this select: SELECT [Category_ID], [Category_Cd], [Category_Dsc] FROM [PMO_TBL_EMP_CATEGORY] it returns me a nice small list (3 columns) whic is the easiest way to have a 4th column which contains Count(*) So basically i want to do this: SELECT [Category_ID], [Category_Cd], [Cat...more >>

In terms of performance which one is better? 1. SELECT * FROM table_name OR 2. SELECT column1, column2........lastColumn FROM table_name ? Thanks ...more >>

Does anyone know if there is a way to pass a record from a select to a user defined function in SQL Server 2000? The number and names of the columns in the record will vary depending on the upload temp table selected from... You should be able to see what I am trying to accomplish bellow... If y...more >>

I'm using SQL Server 2000. Suppose I'm in Northwind database and I execute the following query: SELECT Notes, Datalength(Notes) As 'Text length' FROM Employees The results of 'Text length' shows 2 X total characters because Notes is of type ntext (Unicode type). Q: How to form a query ...more >>

Arithmetic overflow error converting numeric to data type numeric. I'm getting this error when I'm trying to insert. this is my SQL insert into ABSCTRL ( ID, column1 ) values ('123',12) ID is char (4) Column1 is decimal(4,1) in the database table. Please let me know why I'm ge...more >>

Hi, SELECT amount, currencycode FROM Expenses (NOLOCK) We have to select the latest exchnage rate from other table EXCHANGE_RATE.. this table will contain exchange rate of every date. We have to take the exchage rate for the latest day and use for calculating amount in the expenses tabl...more >>

Hi, I want to build up a table with which hours my site is being watched, i have the data in a table and i can get it out. But what I get is just the hours that it has been watched and for the hours that haven't been watched I would like to get 0. Example 0 0 1 5 2 0 3 0 4 ...more >>

I got a field whose date is '2006-04-30' How can I update statement to change the date into '2006-04-01' thanks a lot ...more >>

How do you add leading zeroes to a string when converting a number? ie. Number = 300 CONVERT(varchar,Number) results in '300', but I would like to have '00000300' How? ...more >>

CREATE PROCEDURE Demo_FTS @SQL varchar(128) AS select * from openquery(demo, @SQL) GO Anyone knows what did I do incorrectly ? I got error: Incorrect syntax near '@SQL' ...more >>

In Oracle, there is a system packaged function that returns the DDL for a database object (DBMS_METADATA.GET_DDL). What is the equivalent in SQL Server? ...more >>

Hi, I have a query but I would like the result to be: sunday monday tuesday wednesday thursday friday saturday 44 157 153 222 74 455 22 how can i assure that it is sorted by day?? Always first sunday, then monday, ... Fré ...more >>

Hi, I want to use SUSER_SNAME() in my application, but I don't how does this function resolves the windows SID. In whose context it does the resolution? I have added a Windows group of a trusted domain to my SQL Server and then a memeber of that group connect to SQL Server, then how does SQL ...more >>

i want to a query. SELECT MAX(fNum) FROM tTable WHERE fDate IN (SELECT MAX(fDate) FROM tTable WHERE fDate IN (SELECT fDate FROM tTable WHERE fDate IN (SELECT fDate FROM tTable WHERE (fRegion="Califo") AND (fProduct="G274") AND (fColor="Brown") AND (fDate<=#5/13/2006#)))) unfortuna...more >>

Hi, I have a problem. I have two stored procs. One I am building currently (sp_load) and another that is already in the data warehouse and which I have no control over (sp_log_event). sp_log_event is for control logging. It accepts a process name parameter. It outputs 3 return parameters by...more >>

Hi All SQL Server 2k gurus, I got random error when I try to run the following sp (seems always has problem when Insert into table when run this procedure in a loop to join several tables into one big table): ---------------------------------------------------------------------------------...more >>

In goold if you type in ditionary It will ask you if you mean to type the word dictionary. Is this something that can be done easily with a sql query? If not can someone point me to the right direction as to how to write something like this? Thanks, Howard ...more >>

How do I write a SQL statement that can replicate table without specifying the data columns? For example, I have Table A with 12 columns, and I want to create Table B with exactly the same fields and data type. Is there an easy way out?...more >>

New to SQL. I'm trying to include 2 dates in a query. They query works, but not logically. I'm sure I'm missing something small. When the query runs, it doesn't include dates that have times later than 12:00:00AM. How do I get rid of that? SELECT dbo.Orders.OrderID, dbo.Orders.Cust...more >>

I have to change the result for Mats(who has the apparatus id of 3) to a score of 8 for the student with the id of 6415(this student has the school_id of 5) *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, I have to run through a list of tables and check for duplicates. The tables have no primary key setup but we expect that there should be only 1 record for a combination of fields. So for example if I keep it simple and imagine there is a table called customers with loads of fields a...more >>

I'm having problems with creating a UNIQUE constraint that references one normal column and one virtual/calculated column. The calculated column uses a user-defined function (UDF) to get its value, and the same UDF is used to create a CHECK constraint. Here's the code /* BEGIN CODE */ CRE...more >>

Hey What tool for T-SQL with Intellisense and other nice stuff will you recommend ? Preferably to use as add-on for VS 2005 but not as a must. Jarod ...more >>

Hi, We need to change all Int data types to Bigint. Considering the number of tables and View tables, changing manually one by one is not a option. Is there a nicer way of changing all (hundreds of them) in more automatic way? YC ...more >>

I'm looking for a query that can return a random sampling of records meeting the where clause criteria. For example I might have a total of 5,000 rows that match my where clause, however I need to retrieve only 250 of these records - but they must be randonly selected. I need to be able to ...more >>

To be brief, I need to copy a table (schema and data) from one SQL Server (2K) database and to another SQL Server database on the same PC. With MS Access, I was able to use a SELECT INTO statement to move data between databases by the use of the IN clause to a newly created table in an extern...more >>

I have the following table structure and would like to pivot the data below. The table was comprised of raw data grouped to find the count. count question choice question2 choice2 ----------- ---------- --------- ------------ ----------...more >>

Hello all, I have 95 records in room 1233 Code: -------------------- SELECT * FROM Inventory WHERE (Inventory.Room_No LIKE 1233) -- 95 rows- -------------------- I want to change them to room 132C: Code: -------------------- UPDATE Inventory SET Room_No ...more >>