Hi All I have a visual basic application, which uses SQL Server 2000(sp3a) as the database, MDAC 2.8 library. I open one connection to the db on the application start, and the applicaiton works fine for few days, then suddenly it gives this error [DBNETLIB][ConnectionWrite (send()).]General n...more >>

I tried and came up with no solution. I need to use Stored procedure and no dynamic sql. I ma using ms sql 2000 service pack 3 I am using three different tables. How I can make it to run union statements only for those table where passing values for the variable is 1 Thanks Tanweer D...more >>

Hi all, I am running an INDEXDEFRAG on all tables in the database and am receiving the following error: DBCC INDEXDEFRAG (msdgen, 279500991, pmshr_iv_inventory_trans_init) Server: Msg 7999, Level 16, State 8, Line 1 Could not find any index named 'pmshr_iv_inventory_trans_init' for table ...more >>

Hi I am trying to populate a Temp table with dynamic SQL but it does not seem to work and the error message returned is that is it an invalid object, leading me to believe that it does not get created: --************************************************ USE Pubs GO SET @SQLString = ' SEL...more >>

I have a table in which a field named DateCreated has the default value (getdate()). THis has always worked before in other apps, it would naturally write the computer's date time whenever a new record was created. I can't figure out why all of a sudden the field in this table no longer get ...more >>

I just joined a new company which uses Progress and 4GL. I come from a SQL Server VB/VBA environment. An in-depth "discussion" has come up several times regarding Progress verses SQL Server and I'm always told that Progress/4GL can do anything SQL Server/VB/VBA can do so why should we switch. ...more >>

I have two tables, Table A which contains house property information and table b which contains viewing info about the properties. I need to write a query which will show all properties that have had no viewings for 3 weeks and then show the whole months viewings. for example, assume "1 high s...more >>

Hi, I am trying to get my VB program to recognize milliseconds when it is returned as a datetime field from sql. I can format it to the seconds but can't find out to include the milliseconds. Any help would be appreciated. Ellie ...more >>

here is my query in sql server 2000 that returns length of text field as 2147483646: select c.name,d.length,d.ss_dtype from syscolumns c join sysobjects o on c.id=o.id, master.dbo.spt_datatype_info d, systypes t where o.name='customer' AND t.xtype = d.ss_dtype AND c.xusertype = t.xusert...more >>

I am having an interesting problem I haven't seen. First, here's the code that sets up the cursor, with a select statement where the exec should be, and the results: DECLARE @order_id int, @row_id int, @qty_rtn int, @invoice_id int, @date_shipped datetime DECLARE or...more >>

A medical office for which I'm designing a database receives many many referrals from other doctors offices. A small subset of these referrals become patients. These referals and patients must be represented in the new database. The data collected for referrals is minimal, while the data fo...more >>

Is there a way to Reference an alias field name in an SQL Statement? Example: Select 1 + 1 AS F1, F1 + 1 AS F2 ...more >>

Sorry for my newbieness: I have a table (Cases) where Case_Number is the unique id field. Another table (CommentsTable) contains these fields Case_Number Comment_Date Comment As users enter comments to the database, the comment gets a date/time stamp (Comment_Date) and is recorded in th...more >>

How do I represent a one to (one or zero) relationship? This is a puzzle to me. The purpose of having the relationship this way is I want Table1 to be able to accept an insert of a PK even when there is not a related FK in Table2. I can set the FK as a unique, but when I create the relations...more >>

There are two stored procedures. One calls the other one time. It works. create procedure nestedSP @p float as declare @q float set @q = @p select @q go create procedure CallingNestedSP @p float as exec nestedSP @p go exec CallingNestedSP 111.11 How do I get the ...more >>

Hi, I have a case statement that has been giving me hell for the past day, can anyone suggest another way of validating is those field have zeros or not. The field types are numberic, looking at the table their is no Null values in there a few hundred zeros (0, .000). I have tried this sta...more >>

can i use an unknown column in an ORDER BY clause with t-sql? i know it will always be an identity field and it is in the first column. it is also the primary key. can i depend on a recordset always being in this order without the the clause? ...more >>

Hello, Underlying table has the following fields and values Barcode Item Pass 1000 x YES 1001 x YES 1002 x NO 1003 x NO 1004 y YES 1005 y YES 1006 y NO Iam trying to create a...more >>

I was trying to write this MDX but I am getting errors so maybe I should create a stored procedure against my CUBE. I want to return two values : Revenue Avg and Product Price Avg by a specific time and Sales Region. can someone provide an example? My cube provides the total revenue for...more >>

I guess that it is OK to call a stored procedure from another stored procedure for reuse purpose. Please advise with your opions, sample code, help information. Thanks Peter...more >>

I understand that a SQL Server can slow down if TempDB runs out of space and must be resized. So, towards keeping TempDB "big enough" I'm wondering if it would be a great idea to do the following: 1. Create a stored procedure that checks the size of TempDB and causes it to increase in size ...more >>

I am trying to execute the following T-Sql snippet and it gives an error: IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'ExpData') CREATE SCHEMA [ExpData] AUTHORIZATION [dbo] Error = Msg 156, Level 15, State 1, Line 26 Incorrect syntax near the keyword 'SCHEMA'. I can't fo...more >>

Can I make a Synonym for an entire Database ? For example something like.... create SYNONYM syndDB FOR [YourServerName].YourDatabaseName] and then select * from [syndDB].sys.sysobjects TIA ...more >>

Hi Following is the code to get data From xml file located at E: Now the file path will get changed in future there for path will come by one parameter @strPath in this case declare @hDocA int,@xmlDocAsgt XML,@strPath set @strPath='E:\Temp.xml' --- Parameter value any path set @xmlDocAs...more >>

Hello all, I'm designing an application and writing stored procedures for it. I'd like to have one stored procedure for each table that handles the UPDATES. Depending on what parameters are passed in, those fields will be updated. Sometimes it might be all the fields, sometimes maybe just ...more >>

Hi to ALL I have created a function using followinf statement CREATE FUNCTION [dbo].[fncLocCount] (@ID as smallint) RETURNS smallint AS BEGIN declare @iReturn integer set @iReturn = (select count (distinct locationid) from tbl_employees where locationid= @ID ) Return @iReturn END ...more >>

Is there a way to Reference an alias field name in an SQL Statement? Example: Select 1 + 1 AS F1, F1 + 1 AS F2...more >>

Is there a maximum limit the WHere clause in sql server? How about when you use the like operator? where can i find this information? ...more >>

Can some recommend a few good books for sql 2005? Thanks...more >>

I have an SP which performs about 75,000 logical reads on a table with 78000 records in a Test database. The same SP performs about 39 million logical reads (for the same parameters supplied), adds index/lazy spools, etc to the execution plan in PROD and the PROD replica (replicated version of P...more >>

Greetings, I would like to konw if Sqlserver 2005 supports Geographic Information System (GIS) data, i.e., supports spatial data, like Oracle? MTIA, Grawsha ...more >>

I would like to use a select that gets the top two per group I would like to do the following. I know it is not as simple as the select I have as an example below but you get the idea of what I am trying to do. SELECT TOP 2 <pr group> * FROM SCORETABLE GROUP BY CODE ORDER BY SCORE Rec...more >>

Is there a way (script, tool, whatever) that I can monitor sql servers and services on multiple different servers. Basically I want on screen that can display that status of many sql servers and services on multiple servers. Thanks ! ...more >>

I'm using SQL Server 2000. What's the command to insert a picture (.bmp, .jpg. ...) into an Image type column? Regards, -- Pedestrian, Penang. Message posted via http://www.sqlmonster.com...more >>

Hi All I have a visual basic application, which uses SQL Server 2000(sp3a) as the database, MDAC 2.8 library. I open one connection to the db on the application start, and the applicaiton works fine for few days, then suddenly it gives this error [DBNETLIB][ConnectionWrite (send()).]General n...more >>

who can tell me! thanks...more >>