Rating Thread / Thread Starter	Last Post	Replies	Views
Update query Hi I'm having update problem. Here is the senario I have to different db server (SQL Server) linked with each other In DB Server 1 I have 2 tables... sqlgoogle	03-08-2005 09:32 AM sqlgoogle	2	89
Using LIKE with underscore and forward slash.. Hello All, DDL Statements: CREATE TABLE . ( (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON GO hharry	03-08-2005 08:36 AM Hugo Kornelis	1	56
slow performance on specific query Hi, Can't post specifics at the moment but if this seems like a common problem any help would be appreciated. When querying with ~6 tables, using... Not Me	03-08-2005 05:32 AM Erland Sommarskog	3	61
Lock:Timeout events I am tracing a SQL Server 2000 production server that gets a query about every second. The Event I chose to watch was "Lock:Timeout". To my... john.livermore@inginix.com	03-07-2005 09:56 PM Dan Guzman	2	81
Design question: Nested views and functions? I am working in a project where the business model is complex enough that many common retrieval functions become difficult to develop and maintain in... Matt	03-07-2005 09:30 PM Serge Rielau	5	63
curious result How can I write a query to return non distinct results? William Kossack	03-07-2005 05:40 PM Erland Sommarskog	3	81
various working with dates issues I've got a table with some datetime fields in it. One field (call it field 1) is of the form mm/dd/yyyy and the other two (fields 2 and 3) are in... wireless200@yahoo.com	03-07-2005 05:16 PM Erland Sommarskog	2	65
Speed cost for using "or" clause and functions on join statement Select member from NameList Inner join Members on (Left(Namelist.NameID,5) = Members.ID OR (left(namelist.SSN,9) = Members.ssn OR... Phillip	03-07-2005 05:06 PM Erland Sommarskog	2	74
multiple foreign keys on same field, based on other field ( 1 2 3 ) I have a table called BidItem which has another table called BidAddendum related to it by foreign key. I have another table called BidFolder which is... pb648174	03-07-2005 04:56 PM Erland Sommarskog	26	186
Another DTS question Hello All, When using SQL*Loader I can specify a column default value in the control file - when the insert occurs, the default value will... hharry	03-07-2005 12:36 PM hharry	0	76
DTS Package and ASP.NET Hi all, I need to export tables out of a Pervasive DB and into SQL Server 2K. I have set up a DTS Package to do this when a user visits a web... Tony	03-07-2005 11:37 AM John Bell	3	89
Newbie Friends, I am a newbie in sql programming, I don't know much about the programming. I 've tried to make a trigger but it failed. Where can I learn... Michael Teja via SQLMonster.com	03-07-2005 09:25 AM Thomas R. Hummel	2	124
Anyone interested in getting Microsoftt, CISCO or any other IT CertificationzzzZ Hi there... Hope you will be doing fine. Actually, we offer Services regarding Testing of Certification of Microsoft, CISCO, ORACLE, CompTia... get.certified@gmail.com	03-07-2005 08:58 AM get.certified@gmail.com	0	59
Help, im new to MSSQL -- ============================================= -- Create table with IDENTITY column -- ============================================= create table... XunLing	03-07-2005 08:48 AM James Goodwin	3	77
Asking Email Address Up David Portas and Erland Sommarskog Dear Mr Portas and Mr Sommarskog, Cause I am a newbie in sql, can I ask for your email address? My email Address is mike (AT) ptmb (DOT)... Michael Teja via SQLMonster.com	03-07-2005 06:43 AM David Rawheiser	3	77
Stored Procedure Not Returning Recordset in ASP Hi All. My question is this. I have a complex stored procedure in SQL Server which works fine when I run it in Query Analyzer. However, when I... rhungund@gmail.com	03-06-2005 11:46 PM rhungund@gmail.com	5	60
SQL Server/PeopleSoft DBA Needed! Please send your resume and position to Cindy (AT) AtlanticResource (DOT) com! I CAN NOT accept candidates that ARE OUTSIDE OF THE US! NO PHONE... Cindy B	03-06-2005 08:19 PM Cindy B	0	60
MS SQL 6.5 Unable to connect. T Dubya (timber_toes (AT) bigfoot (DOT) com) writes: Good! I just wanted to make sure. Certainly an unusual way. It may not really resolve the... InProcess	03-06-2005 04:19 PM Erland Sommarskog	7	68
SQL Server on chared hosting with client connections www.shanje.com does sql server hosting, on shared servers, at a reasonable price. It seems. They also allow client connections. Just playing around... Jo Davis	03-06-2005 09:17 AM John Bell	3	75
Newbie Needs Help I have experience with MS Access, but I am an absolute newbie when it comes to MySQL. I was looking over the site, mysql.com and found the following... TheTamdino	03-06-2005 03:52 AM David Portas	1	81
Cannot Drop Database I am trying to drop a database, but keep getting the following error. "cannot drop database 'blah' because it is currently being used... tgru	03-06-2005 02:05 AM John Bell	1	74
MS SQL Server - User Rights Does anyone know if it possible to make a specific table invisible to a user when they are in Enterprise Manager? code2live	03-05-2005 12:09 PM John Bell	1	72
Database performance degrading (again) We have an application with a SQL Server 2000 back end that is fairly database intensive -- lots of fairly frequent queries, inserts, updates -- the... teedilo@hotmail.com	03-05-2005 11:57 AM John Bell	6	73
Get the field value after INSERT Hi, Problem: I need to get the value of auto-incremented field from just inserted record In Oracle this is INSERT .. RETURNING command. In SQL... Eugene	03-05-2005 11:04 AM Erland Sommarskog	2	62
Column calculations Hi, I have a select query that returns three integer fields from a table the values range from 0 to 5. On each row I would like to calculate the... Stevie D	03-05-2005 09:55 AM Stevie D	3	78
Permutate rows based on table Hi, I wish to create new rows of data based on a source table. Example: I have a file that contains a SESSION (time roughly a calendar quarter for a... rcamarda	03-05-2005 04:47 AM David Portas	3	75
Null & String Ops Again I don't know enough math to demonstrate that any numerical operation with a null should yield a null; although I would guess that it's true. I just... BlueDragon	03-04-2005 05:31 PM Hugo Kornelis	7	79
BCP Issue w/Right Truncation Hello All, I am attempting a bulk load of fixed position flat file data via bcp and I have noticed that I get a Right Truncation error when trying... hharry	03-04-2005 05:23 PM Erland Sommarskog	1	61
How to Backup Read-Only databases Hello, Can anyone tell me how to backup read-only databases? I want to backup the secondary databases in my log shipping pairs. Thanks, TGru ***... tgru	03-04-2005 05:18 PM Erland Sommarskog	6	64
Update Time Out? I am using ASP to insert/delete/update rows into a very simple SQL Server database (2000). When a certain amount of text (as little as 1000 chars) is... mbailey	03-04-2005 04:03 PM Erland Sommarskog	3	75
Report Containing Sequential Dates (removing date gaps) I have a table containing typed log entries. One log entry is supposed to be created every twelve hours, but sometimes there are gaps. I need to... christopher.secord@gmail.com	03-04-2005 02:56 PM dbmonitor	6	61
SQL 2000, AS400 and Client Access Anyone Anyone , please shed some light. We have upgraded our existing NT4, SQL 7 MIS server to a W2K, SQL 2K server On this I have install all the... seanvdv@gmail.com	03-04-2005 11:58 AM seanvdv@gmail.com	0	72
newbie join problem... Hello, I have 2 tables, software and waretype. The waretype table is a simple table with 2 fields wareid and warename So the table looks like... toedipper	03-04-2005 11:58 AM NSpam	6	68
Question on aggregate statement I have a location table that contains all North American zip codes, the city, county, state etc.. each record has a GUID. My problem is... mike	03-04-2005 10:55 AM mike	2	67
Problem backing up Database and Transaction Log due to disk space limitations I am having a problem backing up my database and TLog files due to a lack of local diskspace. The db file is about 30GB and the TLog is about 20GB... war_wheelan@yahoo.com	03-04-2005 10:50 AM Erland Sommarskog	3	59
good table design... ( 1 2 3 4 ) Hello, I am designing a table of vehicle types, nothing special, just a list of unique vehicle types such as truck, lorry, bike, motor bike, plane,... toedipper	03-04-2005 10:45 AM Pero Periæ	36	230
Query/Report Help needed Hello all, I need to do the following task repeatedly. I have been doing it manually until now and I am thinking if there is any way I... surenm@gmail.com	03-04-2005 09:03 AM Thomas R. Hummel	1	74
Concurrency issues with "Tree" structures. Hi, I'm currently implementing a database with a tree structure in a table. The nodes in the tree are stored as records with a column called... Robin Tucker	03-04-2005 08:48 AM Robin Tucker	4	64
What's a significant LockTimeout measurment in PERFMON? Recently, using PERFMON, I've been rather dismayed to find that our application is averaging 3 - 4 lock timeouts per second, and frequently has... Philip Yale	03-04-2005 04:21 AM Phil	4	66
Query - check for a string in stored procedure Hi, I would like to check if a string value exist in a string in sql server stored procedure, e.g. set @testString = 'this is my test document.' if... June Moore	03-04-2005 12:51 AM Madhivanan	1	62
Login Confusion Hi, I am Just beginning to get to grips with SQL Server v 7 security on a stand alone win 98 PC. I have created a login which only has access to... Stevie D	03-03-2005 06:57 PM Stevie D	2	74
Script to lock down a regular user? I don't like the fact that any user I create has access to system tables in the Master databases and the ability to issue 'sp_who' plus God knows... John Dalberg	03-03-2005 04:33 PM Erland Sommarskog	3	64
Database design question I have a series of database objects that represent things such as people, accounts, etc. I have a set of options (boolean) that I need to add... Tim Mavers	03-03-2005 04:22 PM Erland Sommarskog	6	71
ASP to SQL Connection Prob, Same Server, IIS Yes, it should be easy.... I have a single box hosing IIS and SQL Server 2000. In my ASP script I've tried using the following connection strings to... Chad Richardson	03-03-2005 04:18 PM Erland Sommarskog	3	59
How to remove WITH FILLFACTOR = 100 when Generate Sql Script ? Hello, I'm using Entreprise Manager (for Sql Server 2000) to generate my database's script. By mistake, i've changer FillFactor one time. And, now I... rabii	03-03-2005 04:09 PM Erland Sommarskog	6	50
SQL Query Help Thank you for taking the time to look at my question. Any help would be much appreciated ! Database: Microsoft SQL Server 2000 Database... cwwilly@gmail.com	03-03-2005 03:54 PM Erland Sommarskog	9	74
Re: SQL Query - Aggregate data select c.CustId, c.CustName, sum(case when o.PaidYN = 1 then o.Amount else 0 end) as TPaid, sum(case when o.PaidYN = 0 then o.Amount else 0 end) as... MADS	03-03-2005 02:54 PM SQL	1	61
get the description of a column Okay guys heres the senario. I have written a kick butt asp application that allows me to test sql statements and manage/display all my databases... Dan Gidman	03-03-2005 01:12 PM Thomas R. Hummel	1	63
Re: Complex query help needed.... Assuming that your id column is unique and does not allow NULL values, the SQL below should return a single record per name, using the record with... Thomas R. Hummel	03-03-2005 09:23 AM Thomas R. Hummel	0	59
Get list of files in directory using a SP Is there an XP/SP out there that will return a list of files residing in a specified directory? I'm looking for something simlar to Execute... jpasqua@gmail.com	03-03-2005 08:49 AM Thomas R. Hummel	5	57

Page 159 of 283

159

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off