Rating Thread / Thread Starter	Last Post	Replies	Views
IS NULL not working in WHERE clause. ( 1 2 ) The following query returns rows where the time_id IS NOT NULL. This query seems to be breaking SQL Server(?) select bus_date, time_ordered,... Earl	12-20-2004 03:04 PM Steve Kass	17	84
Is this join possible? Ok, Heres a little bg info... I've got one table thats got phone number in this format: AreaCode \| Prefix \| Suffix -------------------------- xxx ... Weston Weems	12-20-2004 02:28 PM Max	2	55
Triggers Currentnly I have one trigger on a table in Database A that populates a table in Database B. The table in Database B also has a trigger that does... Miles Cousens II	12-20-2004 02:23 PM Miles Cousens II	2	61
Report slows down other applications Hello, I wrote a report in COBOL using embedded SQL. This report opens 5 insensitive cursors (to avoid locking) sometimes one within the other... Helen Stein	12-20-2004 02:18 PM Max	5	48
Security context used for DBPROP_MULTIPLECONNECTIONS sessions We had tried to open a second rowset while an existing rowset was open and had a problem (which is the subject of this message) which we solved by... Laszlo Szentendrei	12-20-2004 02:16 PM Laszlo Szentendrei	0	65
Security context used for DBPROP_MULTIPLECONNECTIONS sessions We had tried to open a second rowset while an existing rowset was open and had a problem (which is the subject of this message) which we solved by... Laszlo Szentendrei	12-20-2004 02:15 PM Laszlo Szentendrei	0	48
How to join two tables and only display the values on the first row? Hi all, I need to join two tables but the joined table must be displayed only in the first group's row... Table 1 FieldID Value1 Value2 ... Alfredo Becerril	12-20-2004 02:15 PM Alejandro Mesa	3	60
Updating SQL table from front-end Access I'm using Access as a front end to SQL. Our product ID (key field) in the Product Name table sometimes changes. I need all of the associated... SharonInGa	12-20-2004 02:14 PM Max	3	48
security context used for DBPROP_MULTIPLECONNECTIONS sessions We had tried to open a second rowset while an existing rowset was open and had a problem (which is the subject of this message) which we solved by... Laszlo Szentendrei	12-20-2004 02:11 PM Laszlo Szentendrei	0	52
Tablock option in bulk insert -- BOL confusing For Bulk Insert and BCP, the Tablock option is described as such in Books Online for SQL 2000: "Holding a lock only for the duration of the bulk... DWalker	12-20-2004 02:10 PM Gail Erickson [MS]	7	52
Security context used for DBPROP_MULTIPLECONNECTIONS sessions We had tried to open a second rowset while an existing rowset was open and had a problem (which is the subject of this message) which we solved by... Laszlo Szentendrei	12-20-2004 01:51 PM Laszlo Szentendrei	0	66
Cross Tab Question Well, I'm getting better at this thank's to all your help, but i've got another question. I need a little help with constructing a Cross Tab... Kurt Schroeder	12-20-2004 12:47 PM Kurt Schroeder	2	52
Bigint fields and Access I am using Access 2002 and connecting to SQL Server 2000 using ODBC attached tables. I have to change one of my SQL Server table fields to a BIGINT... David C	12-20-2004 12:40 PM David Gugick	2	45
Converting Access "SQL" Can anyone please help with converting the SQL below, I just can't get real T-SQL to handle the IF part. Thanks. SELECT... James	12-20-2004 12:27 PM Bob Barrows [MVP]	2	49
How to identify all tables in certain filegroup All tables belong to Primary filegroup by default. Are there any SQL commends to list tables in a certain filegroup? Thanks in advance, Mike Torry	12-20-2004 11:53 AM Mike Torry	4	55
Retrieving Data in XML Format Hi, I use nested loop with inner joins to retrieve organization's chart from EmployeeID-ReportsTo columns. Our client uses XML and I must send the... Leila	12-20-2004 11:45 AM Bob Barrows [MVP]	4	47
64bit insert delays ( 1 2 ) we a system fed by various sources (foxpro,dotnet,ado) and we are seeing delays in the data being available, there are no insert errors, but the... Paul Durrant	12-20-2004 11:30 AM Tibor Karaszi	10	99
SQL Server 2005 Service Broker, transactions & scalability Hi! I'm currently reading through some whitepapers of SQL Server 2005 Service Broker. It seems that this will be a very great technology to... Klaus Aschenbrenner	12-20-2004 11:08 AM Stephen Dybing [MSFT]	1	57
Swapping field data randomly Hi all, I have a table that contains name, address etc. I want to use the data in this table for a demo and obviously, I don't want real names and... John Smith	12-20-2004 10:59 AM Alejandro Mesa	1	52
Iterate through the inserted table in an update trigger... I am trying to check every field in the inserted and deleted tables in an update trigger. I want to compare each field value between tables because... Matthew Wells	12-20-2004 10:58 AM Matthew Wells	8	61
Setting Table dynamically Hi: I have a DTS package that first brings in data from another database into SQL Server. In the source database, the database tables are... shop@pacifictabla.com	12-20-2004 10:28 AM Jacco Schalkwijk	1	45
Simple Problem - Simple Solution? I want to execute a stored proc. multiple times with the least amount of code. For example, I want to execute: "sp_delete_maintenance_plan @plan_id =... DBA72	12-20-2004 10:13 AM Brandon Lilly	3	62
Hierarchy Problems Hello, I'm having a problem with hierarchies. I've got a simple parent child relationship as defined below and I'm wanting to return rows from a... Kevin Munro	12-20-2004 09:53 AM Kevin Munro	5	57
Day of the year i hav a datetime field and i need to know the day of the year the date represets ie 2004-12-20 00:00:00 = 355 Peter Newman	12-20-2004 09:41 AM Alejandro Mesa	1	55
Timeout when inserting BLOB records Hi I have a problem with a VB application that is adding tif images as BLOBs to rows in a table in SQL2000. At present the system is failing as the... Mike Green	12-20-2004 09:35 AM Kevin Munro	1	39
concatenate function ( 1 2 ) Hi, I like to know if there is concatenate function available in SQL script. I like to combine two columns together as a unique key. Please... sg	12-20-2004 09:13 AM Tom Moreau	12	93
Restoring DB** Hi I restore my db backup in different station by following the same steps .but in some of them it restores successfully and in the others folowing... maryam rezvani	12-20-2004 09:07 AM Andrew J. Kelly	5	53
Select column names + values in query analyzer Hello, all. We need to copy the results from Query Analyzer into Excel, but when we do, it doesn't show the column names. Excel can connect to... dw	12-20-2004 08:57 AM dw	2	41
VB & SAL Date/Time Problem? I've written an ASP app that requires users to login - normal stuff. As is typical with users, sometimes they just close the browser which teminates... Richard Gutery	12-20-2004 08:33 AM Alejandro Mesa	3	59
I need your help, thanks in advance!! CREATE TABLE . ( (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , NOT NULL , NOT NULL ) ON GO ALTER TABLE . ADD CONSTRAINT PRIMARY KEY ... BFG2000	12-20-2004 08:27 AM Pike	2	52
update multiple values UPDATE Customers SET ( CompanyName , ContactName ) = (SELECT 'Name ', 'Sora' FROM Customers ) WHERE CustomerID='ALFKI' it does not work on mssql... Emre Guldogan	12-20-2004 08:14 AM --CELKO--	4	46
Difference between insensitive and fast-forward cursors. Hello All, We know that both insensitive and fast-forward cursors do not reflect changes in the recordset if the base tables data changes. But, can... SQLCatz	12-20-2004 07:32 AM Dan Guzman	2	66
Finding out all the Nested stored procedures within a stored procedure. Hi All, Is there any way to find all the stored procedures call from one stored procedure. For Example, The Main sp is sp_Main. Inside this sp... Peri	12-20-2004 07:11 AM Wayne Snyder	2	42
Advice needed Say in a sproc definition we have Create proc x as declare @abc int set @abc = 1 select col1,col2 from table1 where col3 =@abc So the question is Hassan	12-20-2004 07:10 AM Wayne Snyder	2	56
SPID Hi, Is it possible to force SQL Server to check that if a particular SPID is alive or it has been disconnected(maybe crashed). assuming that no... Leila	12-20-2004 06:54 AM Wayne Snyder	6	56
Using ADO for locking a row for Dpecific Time Hi All I am posting My Prob again I have a situation I am using Access 2003(MDB) as front end & sql server 2000 backend Seneria is that I want to... AM@Yahoo.com	12-20-2004 06:30 AM AM@Yahoo.com	3	48
Problem with Output param for stored procedure ( 1 2 ) Hello, I'm trying to get an error code back from a sqlserver stored procedure; I'm using an Output param to do it. I set up the call to the sp like... Developer	12-20-2004 06:24 AM Bob Barrows [MVP]	10	91
How do I detect the SQL Server 2000 / MSDE 2000 installation Hi, In my installation, I need to check for the SQL Server 2000 installation and if it is not there, I need to install the MSDE 2000. Can anyone... Arun	12-20-2004 05:55 AM Kevin Munro	2	59
Stored Procedure enhancements Hi, What are the possible enhancements one can make in stored procedures. At the moment I'm using SPs to add/edit/delete and select purposes. We... AKG	12-20-2004 05:47 AM Kevin Munro	1	51
Syntax for setting primary key I have an existing field which i wish to alter to being primary key. I can't seem to get it right. This is what i'm tumbling with: ALTER TABLE... Morten Snedker	12-20-2004 04:48 AM Jacco Schalkwijk	2	44
Composite Key Quesion I am creating a new SQL2000 database (Imagine that ;)). After quarreling with our Purchasing Department, I must create a composite key instead of a... Russell Mangel	12-20-2004 03:43 AM Hugo Kornelis	8	45
SQL Express manager 2005 Connection problem Hi, My sql server instances are named as Server\Instance e.g srv1.abc.corp.com\PSE1 I'm not able to connect to such server instances using the SQL... Kalyan Krishna	12-20-2004 03:35 AM Kalyan Krishna	1	39
How to GET The Name of the Default? Hi All, Is there any way we could find out the NAME of the default that is binded to a column on a table? Ex: - Create Table EMP ( EmpID int... Prabhat	12-20-2004 03:30 AM Prabhat	8	72
usage of updlock I see a lot of our sprocs developed by developers have select statement with the updlock. Why would they be doing that ? I know you might be... Hassan	12-19-2004 11:34 PM David Gugick	2	65
Theoretical minimum and maximum values for UNIQUEIDENTIFIERs Does anyone know what the theoretical maximum and minimum values are for UNQIUEIDENTIFER fields. A string of... Geoffrey Barnes	12-19-2004 10:04 PM Dan Guzman	2	41
What are filegroups and how are they used? I know the definition of a file group in sql 2000 is that they allow you to group/organize database objects. However, I have yet to see an example... Ed_P.	12-19-2004 08:38 PM oj	1	66
Conditional SQL Hi, I need to write a conditional sql, so that if the value of one field in a recordset is say = 1 then the sql runs Select * from table where ...... Carlos	12-19-2004 08:31 PM oj	3	51
Server doesn't return dataset unless SP is recompiled I have a web app that calls a SP. Twice in the last month the app has locked up. The first time we ran a SQL Trace which showed that the SP had... Dewey	12-19-2004 06:59 PM Brian Brown	3	47
How to concat select results in SP Hi, I would like to write a stored procedure that select all the values of one column and concatenate them to produce an output string. something... David Scemama	12-19-2004 06:47 PM Max	7	55
DB Normalization Hello, I have just taken my first stab at trying to normilize a testdb that I have created in SQL 2000. I want to get feedback and or tips and... Ed_P.	12-19-2004 06:36 PM Max	3	48

Page 1051 of 1545

1051

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