Hello, In my web site I have 2 types of users: students and professors. All users need to login but the personal information for each user type has different fields. So I create 3 tables: professors, students and authentication, "professors" will have all the personal data from professors....more >>

Hi, when i run this query select * from personal where phone > '40-8496-7223' it works fine, eventhough i declared phone as varchar type, it should not operate on > operator. what could be reason...more >>

In my sp,I want to get some data from a table which name is dynamic ,and insert the data to a table varialbe,in other words,look like below: StoredProcedure ( DECLARE @TABLENAME VARCHAR(255) DECLARE @MyTABLE TABLE (ID INT,NAME VARCHAR(255),AGE INT) INSERT INTO @MyTABLE ...more >>

Hello: I'm looking for a free tool or procedures to compare data content of two tables which belongs to different servers. Each table does not have any indexes or primary key. I need this as verification procedures for my log shipping process. Thanks, GB ...more >>

Hello, I use sql server 2000. I want to create the following stored procedure: I have a table with serveral field including the field "isqueued" I want to select one record (select top 1) from the table and immediatly update the iqueued field to "true" while locking the record. This to make...more >>

Under certain circumstances there seems to be a problem connecting a SQL Server 2005 (Final Release). The connection is done with a Delphi Application using an ADOConnection (SQLOLEDB.1 provider): - Setup a vanilla WinXP PC (Seems to also appear under Win98, WinME, and probably every versio...more >>

Hello, I have a table of product categories that looks like this (air code, so could be some typos, but it's basically right)... create table producttypes ( ptype int not null identity(1,1) primary key, typename varchar(50) not null default '', ParentCat int references producttypes(ptype)...more >>

I would like to run a script that takes some variables and creates a view and stored procedure. I keep getting an error saying "'create view' must be the first statement in a query batch". What is the correct way to do this? DECLARE @custview varchar(50), @custID varchar(10) SET @custview ...more >>

I can't debug SQL Stored Procedure on SQL Server 2005. I don't see any options in Management Studio and in VS.NET 2005 I see options but it is disabled. What should I do? Thank you, Shimon ...more >>

Hi, would anyone be able to point me in the right direction on how to save the electrical symbols for ohms and micro in a sql server field. Many thanks, ...more >>

Hello, I want to develop a small PDF Management System for our Web Insurance Systems and I´m wondering if I can use SQL Server to save my generated PDF Documents. Is it possible? If so is it suggested? Are there any other alternatives? -- Jorge Luzarraga C Fidens S.A. 321 7610 Anx 23...more >>

I have 2 tables. In the User Table I have a UserID and the CompanyID of the Company he belongs to. In the second table (EmailBlocked), are the users or company a particular user has blocked. If a user blocks a company, then all users in that company are blocked. If the company is not b...more >>

I am writing a program in vb6 to move a database and its log file from one directory to another using sp_attach_db and sp_detach_db. I used 'sp_detach_db mydb' to detach the database, moved it to the new directory location and then tried to attach the database using the command: 'sp_attach_db...more >>

Hi, am after a book or two on TSQL and Stored Procedures, any recommendations would be much appreciated. Cheers ...more >>

I'm writing a stored procedure that updates a record in a table which is keyed by [ID_No], [Sub_ID] and [TimeStart]. I can easily find the record to update by finding the Top 1 Where [ID_No] and [Sub_ID] are the IDs I want and I Order By [TimeStart] Desc. I am wondering if there is a more ...more >>

I'm just learning to use the new CLR integration features of SQL 2005 and I created the following simple function: [Microsoft.SqlServer.Server.SqlFunction(IsDeterministic=true, SystemDataAccess=SystemDataAccessKind.None)] public static SqlString Foo(DateTime dtStartDate, DateTime dtE...more >>

Hello. Could somebody please tell me which is more efficient: 1) To declare a variable and set it to a value and then use the variable thoughout the SQL code. E.g. DECLARE @PL Char(2) Set @PL = 'PL' When Left(MyColumn,2) = @PL Then When MyColumn2 = ...more >>

Hello. I need help with using CHARINDEX. I have a column in a table (Discount_Specification) that could hold the following values: LF(I03U,CHA-14,ALL-0) MR(I05U,I06U,CHA-5) etc. I'm inserting into another table and need to pick up the value following "CHA-" in that column. I've c...more >>

I need a select that sums the same column, but with different criteria. I also need to "roll up" the sums into a "higher level" sum based on some other tables. This is an accounting database, where subaccounts roll up into a single account (i.e. subaccounts 101 and 102 roll up into account 100)...more >>

Can anyone advise how i resolve this in SQL, I have the following Stored procedure : CREATE PROCEDURE sp_jp_report_won_lost_open_test @datestart as varchar(12), @dateend as varchar(12), @Region as varchar(25), -- e.g. Scotland @Territory as int, --ie 901232 @ReportType as Varchar(7)...more >>

Hello: I have a web application from where I need to execute a DTS, my platform is SQL 2000 and .net 2003. From a Vb.net module I want to execute the package, my question is: does the package need to be STRUCTURED STORAGE FILE or could it be SQL SERVER package (local to the server)...more >>

Hi, Is there a way to calculate the Default Value of a column with other data columns? Using "date_of_birth" column and "screen_date" columns, I would like to calculate the "age" automatically with the Default Value definition. Please let me know if it's possible. YC ...more >>

Here is the condensed version of my question: why do I get a deadlock when multiple threads are updating different rows in the same table? Details: I have a table with a clustered index spread across multiple columns. I run multiple threads, each of which accesses a separate row in the table....more >>

A vendor wrote a php script to manipulate date within SQL Server, basically process data from 1 table and copy the data to multiple tables within the same server. He said the preformance for others client run really fast, except for ours. Our process run about 1 record (40 fields) per second...more >>

Is there any free download tool that I could use to script out table definition along with the data? There is a tool by vyas but it was not scripting out correctly. I don't mean to say wrong things about the tool but may be it was "my bad"!! When I used that tool, it was chopping out some ...more >>

hi, ist there a way to retreive the name of the procedure i am actually in, to send an email with error/name of the procedure? CREATE PROCEDURE xyz as begin if @error<0 sp_sendMessage @error ??@getName -> xyz?? end thanks, mike ...more >>

Hi, I got a stored procedure which is as following: CREATE PROCEDURE sp_parmSailorRanking @ClubCode varchar(50), @Rank varchar(10) AS SELECT People.PeopleID, People.PeopleNameLast, People.PeopleNameFirst, People.PeopleProfessionalClass, People.PeopleClubCode, Rank.Year, Rank.Month, R...more >>

I need to get rows without dupicate ProductID. In the below query, the subquery return 1 row, which is fine. But the query itself returns 2 rows because the TransactionDate has two same date. I want the quesry to return only one row if it has the same ProductID. For example the records: ...more >>

One of the databases I work with has several triggers and one of them is throwing an error. I thought I knew which table it is on, but that table has no triggers. Is there an easy way to identify all the triggers in a database? Much obliged, Geoff. ...more >>

I was reviewing our logs from yesterday and today and I have probably 100 errors: 12/21/2005 08:30:26,Logon,Unknown,Login failed for user 'ApplicationUser'. [CLIENT: 1.1.1.119] 12/21/2005 08:30:26,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16. This is the login that we are u...more >>

Hi I have this code below it gives me the right results but there are load of null values. Is there a way to group by on a case statement to elimiinate these nulls to smarten up ther report select ,c.name ,c.custno,c.salesno, case catno when 'n' then sum(qtyshp* netprice) end as 'Cat-N', ca...more >>

what is @dialog_handle? i assumed it was the same value as conversation_handle in my dbo.MyQueue table but looking at these values they are different. when i do SEND ON CONVERSATION @dialog_handle... i see the message appear in dbo.MyQueue, but conversation_handle holds a different value....more >>

Hello Everybody, We have arround 10 reports, i have written store procedures and i have created proper indexes on all the required columns. When i run specific report, it takes around 40 secondes but when around 20 users log in to the system (we have microsoft reporting server as a reporting ...more >>

We have SQL2000 and Exchange server 2003 I have been trying to send out an email from the SQL server using the XP_smtp_sendmail stored procedure. If i address it to an email address within the company ie me @mycompany.co.uk it works fine, however if i try to send it outside of the com...more >>

Hello, I have several archived filegroups that have data in them partitioned based on the date. These filegroups have been removed from database after archival. For example two months ago. Meantime my production database is populating everyday. Now I would like to restore one of my old arch...more >>

I'm writing a select statement to to show products which have been sold in the past 6 months and those not sold recently. SELECT ShopID, PTypeID, ProdID case WHEN MAX(Trandate) < '20050601' then 1 else 0 end as Unused FROM tblShopSales GROUP BY ShopID, PTypeID, ProdID for each prod...more >>

Hi , i am new to msolap , i want to make an application that will update data or insert data in msolap. Any link , help ,book,sample program will be helpful . thanks in advance . kjangir...more >>

Dear all, I''ve got a database which own sql1_latin1_General_cp1_ci_as. That's fine. I'd like to change the current collation for 'Traditional_Spanish_CI_AS' using the following statements: 1-ALTER DATABASE bdtestman SET SINGLE_USER with rollback immediate 2-ALTER DATABASE bdtestman COLLAT...more >>

Hi all I seem to have a problem with an indexed view, the count returned by the view is not the same as the actual record count in the database. The table definition is as follows: CREATE TABLE [dbo].[CursusBijdrageAanvraagCursist] ( [CursusBijdrageAanvraagCursistID] [bigint] IDENTITY (...more >>

Hello guys I have to do a demo and I need to bring my database with me...how can I do that. I have ms sql server 2000. Is there a way of executing a script or something? Thanks...more >>

hai i have a requirement Is there any query available to set identity increment value to '2' . at present it is '1' without using table design mode. Thanks in advance for any help...more >>

Hi, I am a newbie using SQL Server 7 with Access 2002 I have a DB with 2 tables. The first table is called EVENTS, and it's primary key is EVENT_ID (field type is UniqueIdentifier). The second table is called Z_EVENTS (field type is UniqueIdentifier) and it's primary key is Z_EVENT_ID (f...more >>

In SQL Server 2005, when using INFORMATION_SCHEMA.VIEW_COLUMN_USAGE I get a row for every column in a view including those that might not be visible but used only in the WHERE or ORDER BY clauses for example. Is there an easy way to reduce the list to only show the columns that actually appear...more >>

Hi, i have a general question about stored procedures. If have a procedure and call other procedures within, do they always wait for each 'line' to finish or do they run parallel? say i have got an id = 9 exec sp_insert 9 exec sp_update 5 is it save that the insert sp is always running...more >>