Hi, I'm creating a database that needs to check a value in a text field = = called JobCreate in a form called frmJobCreated against a table called = tblJobCreated which has a whole list of job numbers in a field called = JobNo, then come back with a message telling the user if there is ...more >>

Hi Guys, For the creation of a final output tbale for a report , I need to extract data from three tables temporarily. But to run the programme (written in VB) in a multiuser environment i need saperate tables for each session. How I can do this Thanks in Advance. Subhash...more >>

Hi, I am help a church (chinese) to look at the existing database. When I first look at it, I found out it is "Chinese_Taiwan_Stroke_CI_AS" under the database property for the sectin of Collation Name. I would like to know what is the major different between the default (SQL_Latin1_Ge...more >>

Hi, I've developed an ASP.NET application which uses MS-SQL Server 2000 as a backend. But as the site hits increase SQL server reponse becomes lower. At some stage after that SQL Server gets automativally stopped bringing complete web-application down to halt. i checked the Windows 2000 Even...more >>

tbChild ChildID | ChildName | Birthday tbVisitLog VisitID | ChildID |=20 I am trying to get the distinct number of 2 year olds, 3 year olds, = etc... and the total number of visits... Example: Age | # of Children | # of Visits 2 300 350 3 500 ...more >>

All, Can we count the number of substrings in a string and use it as a condition in the query without any temporary tables, etc? Example: a pretty simple table: SID, PK, INT, NOT NULL SomeString. varchar(250, not null We need to display the strings and their SID where the count of the...more >>

Hello there. I have a question somewhat related to this topic, and I don't know where else to go. I hope somebody can help. I've created a database in access, that I'd like to share with less than 10 users. I'd like each user to see only some of the records in the database. So for example...more >>

Using the following as sample data: Create Table #Work ( GroupId int, ProductId int, Qty int) INSERT #Work VALUES(6, 1, 25) INSERT #Work VALUES(6, 1, 40) INSERT #Work VALUES(6, 1, 50) INSERT #Work VALUES(7, 2, 10) INSERT #Work VALUES(7, 2, 20) INSERT #Work VALUES(7, 2, 30) INSERT #Work ...more >>

Hello, I could not reach a conclusion on this. Maybe someone helps me to understand better. I have a consolidated text extract from other systems and want to upload the data to an SQL table. Below is the fields in extract. OrderNo LineNumber SellingCompany PurcCtry FinalizeDt Ite...more >>

Hi. I'm attempting to write a Stored Procedure that creates an SELECT statement. Belwo is an example of what I am tryign except that my actually query have many more parameters most of which can be eliminated. @sQUERy NVarchar(2000), @sParams NVarchar(2000) @sQuery = 'SELECT * FROM Clients ...more >>

Hi, I am having a table which consists of 8 lakh records in it. I have removed 5 lakh rows from the table which are unused. Before removing the rows the pages are 8943 and after deleting the 5 lakh rows in the table the pages are 4520. After deleting the rows i have done the index fragmentati...more >>

This is probably something really obvious, but can someone tell me whats going on. I do daily full backups of a database to zip and looking at the sizes, they are growing at the normal rate but every other day halfing: day 1 4Mb day 2 7Mb day 3 4Mb day 4 9Mb day 5 5Mb day 6 11Mb etc ...more >>

Hi Everybody Assume a user (A) opens my application on one computer and moves to another computer and opens the same application with the same user name (A). This will result in the user login in twice. Is there any of preventing this from happening when using MS SQL Server? I am us...more >>

Hi there.. The target table got these two 'must be set columns', one called DATASET, and one called LXBENUMMER. Now, when I want to insert data into this target table I need to fill those two columns with the new records I'm inserting. DATASET is easy as it'll always be a fixed value, ho...more >>

Hi, Sample Application of Schema RowSets. Regards, Stephen ...more >>

Hi, Anybody tells me about sample application of XMLA. Regards, Stephen ...more >>