Hi anyone, my question is I wish to use ASP coding to develop a calendar which allow my user select specific date and enter the date into the SQL database -- regards seowhua...more >>

Hi, I am a new comer to sql server. I could write simple procedures. I have a table like this Field1 Field2 Field3 1 one name-1 2 two name-2 1 one name-3 I have to write a procedure to return the values of the r...more >>

There may be some tools out there already developed that can handle this but I haven't had success in finding them. Essentially what I am trying to do is create a data model that can accomodate the creation of a variety of forms to be filled out. The end user should be able to create a quest...more >>

Does anyone know if there's a way to debug T-SQL user functions using sql server 2000 sp3 on Windows Small Business Server 2003 from a client computer running an Access 2003 mdb front-end on Windows XP SP2? Jay...more >>

Hi, I'm attempting to insert a new row into an SQL table using ADO written with c# and stored procedures. The ADO code is running OK, and i know it should work as i have used equivilent code succeffully for other tables. However i am getting the following error: {"INSERT statement confli...more >>

Hi I have a fairly complex access frontend/backend app which I need to upsize to SQL Server. At this stage I would prefer to use access as frontend. I have the following questions; 1. Should I keep using the mdb as frontend or switch to an adp (access project) instead? Any reasons? 2....more >>

There is not a field named as 'CRSID' in the table TMatch but the SQL Server would return all the records in table tcrsmgr: SELECT * FROM dbo.TCRSMGR WHERE (CRSID IN (SELECT CRSID FROM TMatch WHERE tDATE = dbo.fDateOf('2005-7-20'))) ...more >>

Hi I have a sql that return about 35 rows If I execute that sql in the analizer it spend 4 seconds (with variables) If I execute the same sql in a store procedure it spend 35 seconds (with parameters) The size of the variables or parameters are the same as the column...more >>

Hi, I have the following query which takes 12- 15 seconds to return almost 900,000 rows. I would like the query to return in less than 4 seconds (1-3). I have added indexes where needed but was not successful. I am wondering if this query can be rewritten in anyway to respond in lesser t...more >>

I know how to get the text for various database objects (like stored procedures) using sp_helptext or through direct access to the syscomments table. One thing I have not been able to find is the text associated with creating a table. Are programs that dynamically display create and alter t...more >>

Greetings folks. I've got a stored procedure reading data from the database that runs in about 2 seconds from query analyzer, and takes 50+ seconds run from ADO in asp classic. I'm using SQLOLEDB. I'm totally baffled, any ideas what I could check? I'm getting the 50+ seconds time from Sql...more >>

CREATE TABLE [SalesForecast] ( [SaleDate] [datetime] NOT NULL , [CustID] [varchar] (10) NOT NULL , [F1] [money] NOT NULL ) ON [PRIMARY] CREATE TABLE [Sales] ( [SaleDate] [datetime] NOT NULL , [CustID] [varchar] (10) NOT NULL , [S1] [money] NOT NULL ) ON [PRIMARY] CREATE NONCLUS...more >>

I came across an article which states the differences between ANSI-style JOINs & old-style JOINs. This was one among them: ---------------------------------------------- The ANSI-style JOIN supports query constructions which the old-style JOIN syntax does not support. ------------------------...more >>

I wanted to write a select query that returns a list of user-defined types only (without returning the system types). In other words, I can't just do "select * from systypes". Does anyone know if this can be done? ...more >>

Hi, My scenario is that i do a full join for check after duplicates name with the difference function. The problem is that i want to set a group value for each probably duplicates. After that i can set a distinct or something. Help. Here are the result i want to get help with (gro...more >>

I ever hear that visual can visual foxpro programming can connect with SQL Server 2000. Really? Can you give me its simple script? ...more >>

I just finished reading several articles on the SQL Server Security Checklist or Best Practices - and I could use some advise. Our ITS group is too small to have a full time [application] DBA for SQL Servers so only Networking has SA rights on the servers which in the past was not a problem. ...more >>

Hi I need to upgrade an access app to sql server, for the first time. In the first phase I would like to upgrade only the backend to save time. Are there any pointers for a newbie to help in the upgraded? I need to give a time/cost estimate to client for the upgrade (backend & frontend)....more >>

Hi, I have a query like select tbl1.f1, tbl2.f2, count(tbl1.f1) as YY from tbl1, tbl2 where tbl1.f1=tbl2.f2 group by tbl1.f1, tbl2.f2 for example, I can get the results like f1 f2 YY ----------------------- x1 y1 2 x2 y2 5 x3 y...more >>

Dear All, I need some help on this problem. I create a job on SQL Agent, the job had schedule as selected date and time, but I want to have a optional choise to user to allow them start the job at the web page, so I try to create a store procedure to start the job and return the outcome fo...more >>

am using Visual Studio 2003/C# I created a new xml schema/xsd file (Project Create new item->Dataset) I then added Elements to the schema using the designer From the toolbox I then created an instance of my dataset. I then dropped a grid (Infragistics UltraWebGrid) onto my form, and bound th...more >>

I have a column of starting times below (converted to seconds for simplicity): 500 505 510 535 910 939 944 977 I need to assign a Group ID to the above values, based on a time interval of 30 seconds, so the correct result would be: Group ID 500, 1 505, 1 510, 1 535, 2 910...more >>

We are on SQL Server 2000. I have a huge stored procedure (2000 lines) written by someone who has left, and we need to optimize it. This stored procedure uses Global Temporary Tables. Occasionally we get a timeout error, when this stored procedure is executing. We put in Lumigent’s Log exp...more >>

I’m relatively new at database design so forgive me if I’ve overlooked something stupid. I’m designing a teacher grading application on the new SQL 2005 Express. Right now I’ve got a Student table that lists info on each student. I then have a Grades table that lists grades for ...more >>

I would like to pass in comma delimted integer numbers in terms of string array from front end .net application as an input parameter to a stored procedure. Stored procedure would some how sort this input string into an integer array and qualify a simple select against the "in" filter clau...more >>

hello everyone, i'm looking for a solution that would generate the equivalent of a case-inspecific, alphanumeric identity column. which is to say a column that iterates through guaranteed unique values, but using case-inspecific alphanumeric characters instead of just an integer value. or, ...more >>

Consider the following TSQL code: ---------------------------- create table #t1 ( f1 int ) alter table add f2 int update #t1 set f2 = 5 ---------------------------- Such a code produces the following error message: Server: Msg 207, level 16, state 1, line 7 Invalid column name...more >>

Hi All, Here I have a view like this: create view vw_Lcustkeycode as select *, convert(bit,0) as IsArchived from dbo.Lcustkeycode union all select *, convert(bit,1) as IsArchived from DataEntryArchive.dbo.aLcustkeycode I created an INSTEAD OF UPDATE trigger like: CREATE TRIGGER tr_up...more >>

CREATE TABLE Sales1 ( varchar (10) CustID, varchar (10) TransID, datetime SaleDate, money S1, money S2, money S3, money S4, numeric V1 ) CREATE NONCLUSTERED INDEX Sales1_CustID ON Sales1 (CustID) CREATE NONCLUSTERED INDEX Sales1_SaleDate ON Sales1 (SaleDate) "m...more >>

Hugo, I replied with sample data and details you asked , related with Subject ' SQL HELP' on the thread started on 7/22/2005 10:18 A.M Do I have to repost as a New Request to get noticed ?? Thanks Again for all the help Mike ...more >>

how do i make this work? do i need a join? this works in access: UPDATE tblCaseProfiles, tblProviderInvestigatorProfile SET tblCaseProfiles.NewInvestigator = tblProviderInvestigatorProfile.PI_KEY WHERE tblCaseProfiles.Investigator=tblProviderInvestigatorProfile.IP_KEY; ...more >>

Hi everybody!! The title says it all!!! Joking aside, I need to build an SQL statement by concatenating fields and parameters and if conditions and then execute that sql statement within the same SP. Is this possible, and if yes, how exactly? Thanks, Ivan ...more >>

Is there anyway to get the system dateformat? What I am trying to do is get the dateformat, set it to a know format so I can run my script and reset it back to the original format. Psuedo code DECLARE @OrgFormat nvarchar(30) set OrgFormat = ?? SET DATEFORMAT "mdy" --Do something set D...more >>

Hi, I need an SQL statement help. I am trying to UPDATE a View table, and this is the error message: "Derived Table '________' is not updatable because it contains aggregates." Is there a way to update the table with aggregates? Onnuri ...more >>

actually 2 questions. a. Need to replace the string "server name" available on multiple stored procedures p1,p2....p19 with ""? can I do this with an update to system tables like syscomments? b. Can I create a linked server to itself?...more >>

This is a rather complex post in which I state my concerns about the performance of SWITCH() and JOIN. I'm writing a utility for use with MS Access databases, generating SQL executed via ADO. First I create a series of fact tables for most fields (but not every field). The objective is to...more >>

Hi, I have 2 tables namely table1 and table2 and 2 databases namely database1 and database2. table1 is in database1 and table2 is in database2. I want to define relationship between these 2 tables which are in 2 different databases. Is this possible? If so, How can I do this? T...more >>

1) Is the tables being created thread safe. If 2 users hit this function at the same time, do they each get their own copy? 2) Is there a reason to use 2 tables - One temp and one to return? Thanks, Dave Example from "CREATE FUNCTION" in Sql Server 2000 Help ===========================...more >>

Dear all, I would like to avoid this time VB Code or any script out of SQL so then, the question is easy: Is it possible go across of a DTS, seeing its global variables, main properties and so on, using Transact-SQL? Has anyone ever user or have any experience with this? Thanks a lot,...more >>

If I have a table like below. Does anyone know how I write a delete statement to delete the Timestamps which are the earliest whenever a FromURN is the same? NO FromURN ToURN MoveDateMerged Timestamp ---- ---------- --------- -------------------------------- ...more >>

Hi, I'm creating a trigger that shall monitor a table on inserts and if certain conditions are met, it should send a mail the administrator. I do not want to use SQLmail for many reasons so I'm using the extended procedure sp_OACreate to create an instance of the CDO.Message object The ...more >>

Greetings all! I’m developing a web site where you are able to advertise your summer house for subletting per week. Visitors are able to mark there interest by clicking on a certain week in the interface. This being the background I have trouble deciding on how to design the database. ...more >>

Hi I have users in domain group who use application which uses sqlserve, they have rights to insert, update, delete. I want some of the members of this domain group to connect directly to the database using query analyzer but with right only to read and they still of course can use application...more >>

Hi, I have requirement to audit all the select that had happened to = particular set of tables. But I am not clear which apporach should I = follow. Currently I am trying through profiler and tracing stmt:completed event = in the profiler and then try to parse that query to find whether it wa...more >>

Hi, I have a table looking aprox. like this: OrganizationId, ParentOrganizationId, ManagerId My problem is that I would like to show all sub units which a manager is responsible for and not only the ones he is directly manager for. I have solved it like below. I can query it like this:...more >>

Hi all, I have the following sql statement (it's ugly and it's not my work!!!). UPDATE abo_tags SET locked = @PrimaryGroupFilter, locking_user = @user, lockingdate = @sDate FROM abo_tags INNER JOIN abo ON abo_tags.id_no_abo = abo.id_no INNER JOIN products ON abo.id_no_product = produ...more >>

Hi All I have a bug where a text field is saving text to a limit of 256 characters, which is no where near enough. The table structure is an ID with an identity Int, and a field called responseText. I cannot run an alter table as "alter table tempresponses alter column responsetext varcha...more >>

Hi all, I am wanting to add an optional and statement to a query. Not quite sure how to go about it. My attempt so far: SELECT bsc_assmnt_area_id, name, parent_id FROM bsc_assmnt_areas WHERE parent_id = @pid CASE WHEN parent_id = 0 Then And mine_id = @mid END Would...more >>

Hi, I have four different databases and I need to collect different types = of trace event for them. For example DB1 I just need to collect login/logout event. For DB2 I need to collect some other events and so on. Whether I should run a single trace and collect all the data or multiple = ...more >>

I need to create a program in VB that will full process cubes. This is to allow end-user to process cubes. Any helpful links or codes on how to do this? If the end-user will run the process on his machine, what type of access should he have at the server to be able to run the process? I ...more >>