Rating Thread / Thread Starter	Last Post	Replies	Views
asynchronous select statements We have an application deployed on two seperate machines both reading from the same database. The applications poll the database every few seconds... Jeremy Chapman	02-18-2005 02:05 AM oj	5	47
SQL7 and sending mail in a DTS I have a SQL 7 server which has a DTS package in it that sends mail using CDONTS. Basically, if an order is received, the customer's e-mail... Joshua Campbell	02-18-2005 01:37 AM Michael Cheng [MSFT]	5	48
enum for a column Is there a way to do something like an enum for a column? I have a column that should contain one of a fixed set of values. The set of values won't... Jonathan Dodds	02-18-2005 12:33 AM Brian Selzer	1	55
Datediff function select DATEDIFF(second, min (time_stamp), max(time_stamp)) AS responsetime FROM table1. Now, on this table1, time_stamp column is defined in... SQLWiz	02-17-2005 10:51 PM Steve Kass	4	53
Trigger Problem I have two tables, say Accounts and Customers that share a foreign key, say CustomerId. I need a trigger so that when the Account column of the... Mike Hubbard	02-17-2005 09:46 PM Mike Hubbard	0	54
deencrypt a value in master Hi fellows, I would need to know the contains the "password" field but data appears in hexa. Is there anyone here be able to show me how can I... Enric	02-17-2005 09:20 PM David Gugick	3	53
roll call SQL Many thanks to Nigel, Michael, Chris and Uri. All the examples did what I wanted and also taught me a little to. Cheers Dave :-) -- dave9469	02-17-2005 09:02 PM dave9469	0	69
Obtaining timezone offset in T-SQL. In MS SQL 2000, I would like to obtain the timezone offset from UTC for a given date. For today's date, I can do DATEDIFF(ss,GETDATE(),GETUTCDATE()).... yashgt@yahoo.com	02-17-2005 08:15 PM Adam Machanic	1	55
To retrieve a object Hi all of us, I'm trying to retrieve a table which has been deleted without bearing in mind... Is possible to restore .LDF file (the most recent... Enric	02-17-2005 08:14 PM Adam Machanic	1	62
newbie- SELECT DISTINCT I'm trying to get multiple columns back from a query, one of which I'd like to be distinct. Here's what I am trying to get: drop table foo create... Coffee guy	02-17-2005 08:03 PM Adam Machanic	1	65
Select a "range" of rows Hello, I am having problem with a query, the query returns more than 6000 rows and it takes a LONG time since the sql server is not local, so I would... Bruno	02-17-2005 07:59 PM Adam Machanic	1	60
Can you simplfy my SP : I will have 97 IF/ELSE statements I am working with an old legacy SQL 7.0 database (it has poor design), and I have to create a SP which does the following: Determine the largest... Russell Mangel	02-17-2005 07:58 PM Russell Mangel	5	56
Disconnected architecture and other issues 1. If ADO .Net supports disconnected architecture why do we have to close a connection after we open it? Isn't ADO .Net supposed to do that... Nab	02-17-2005 07:52 PM Dan Guzman	1	57
Attaching a file from a backup I have a backup file: tom.bak that is backed up from another Sql Server. I want to add it to my other Sql Server. Do I need to do a restore? Do I... tshad	02-17-2005 07:18 PM Dan Guzman	1	66
Inserting from a Excel file Hi there I'm trying to insert data into a table from a Excel file. After going through some past posts I've come up with this: INSERT INTO... Paul in Harrow	02-17-2005 06:42 PM Steve Kass	4	195
Multiple Instances of Sql Server on a machine. We are currently writing software that connects to Sql server 2000. We use a connection string that provides the name of the server machine... Ed Hawkes	02-17-2005 06:39 PM David Gugick	1	52
select row w max(val) from subquery? Hello, I need to select one row from a group by query which contains a max value: create table t(datefld datetime, metric char(1), val int) insert... Ron	02-17-2005 06:21 PM Ron	4	55
fixing orphan users Hi All, I'm trying to fix all the orphans users for all the databases in my sql server 2000 using the code above, but I'm getting an error that the... JFB	02-17-2005 04:42 PM JFB	4	66
Mixing dirived table and subqueries alltogether (long) Hi I'm building an application where the data structure is hierarchical, I have used 5 tables related with each other throug x.nodeid=x+1.parentid... Henry	02-17-2005 04:17 PM Henry	0	43
Ignore space and dash in search I need to search a field named PartNumber using a LIKE '%xxx%' to find any matching part. However, I need it to ignore a space or dash (-). ... David C	02-17-2005 03:58 PM David	4	52
Masking a table column I have a table that holds passwords, and the column is a varchar data type. Is there a way to mask the field so if someone does a select * from it... jaylou	02-17-2005 03:33 PM Alejandro Mesa	1	64
nested cursors? @@FETCH_STATUS Is there only one instance of @@FETCH_STATUS in T-SQL procs or triggers? If I have two nested loops and I am using @@FETCH_STATUS to see when I am... Al Blake	02-17-2005 03:02 PM Hugo Kornelis	2	67
Error select showed_up = case client_regist when (isnull(s.client_regist,'')='') and (s.clin_appt_status like '%cancel%') then 'cancel' ELSE... Lyn	02-17-2005 02:47 PM Alejandro Mesa	2	67
Debugging Does anyone know how to use the T-SQL Debugger built in? I need to be able to watch how a stored procedure executes but when I right-click the sproc... NewDBAGuy	02-17-2005 02:39 PM NewDBAGuy	0	68
Update an Entire Table Row using Update and Select Hi, I'd like to know if there is a way to update one table1 entire row from another table2, but table1 has less column then table2. Is... drisso@ortc.com	02-17-2005 02:32 PM drisso@ortc.com	3	52
Cannot obtain recordset from stored procedure that contains Exec c Hopefully someone can help. Using vbscript and ADO, I can call a very simple stored procedure that returns a recordset w/o any problems. However,... reedholm	02-17-2005 02:01 PM reedholm	2	54
Is the query using the cache How do i find out whether the query is picking the data and query plan from the cache. Neeraj	02-17-2005 01:55 PM Alejandro Mesa	1	63
Update Integrity ( 1 2 ) Looking for opinions: What are some of the preferred methods for maintaining data integrity during updates. In other words, how to prevent one user... Steven Lazan	02-17-2005 01:06 PM Steven Lazan	10	88
Insert Performance Degradation I am working with SQL Server 7 on win2k server. There was a vb6 ado ODBC application written accessing this SQL Server 7 db. Unfortunately, through... RG	02-17-2005 01:03 PM RG	4	55
Full Text Search Hi, I am wondering if Full Text Search is efficient or not (not too slow ?!) with a table having more than 200.000 records ? Thanks ! Lionel	02-17-2005 12:50 PM John Kane	3	58
How can i populate sql server db with data in french ??? I'm trying to do it , but i see only '??' symbols instead my data in french. When i retrieve it in .NET application i have '??' symbols in datagrid... Oxana	02-17-2005 12:47 PM mark baekdal	1	64
custom wordbreaker Is it possible to create a custom word breaker for SQL server? I've found documentation for sharepoint and other technologies but SQL server... Clyde Seigle	02-17-2005 12:44 PM John Kane	6	64
SQL Puzzle Here is a puzzle. Example Create Table #Temp1(lngDataID int, chrString1 varchar(80)) INSERT #TEMP1 SELECT... JD	02-17-2005 12:22 PM Anith Sen	3	53
SQL Query Tool Is there a tool in SQL Server that allows a visual development of SQL queries, similiar to that used in MS Access? jduran	02-17-2005 12:11 PM David Portas	2	60
Using COUNT in Stored procedure Hi, I have an appointments table where I would like to return the count of all appointments for each day. this is what i have... but how can I... Patrick Delifer	02-17-2005 11:11 AM Alejandro Mesa	7	49
How to lock only one row Hello everyone, I need to: 1. Get data from a table row 2. Lock a row for delete 3. Delete it Helen Stein	02-17-2005 10:50 AM Gert E.R. Drapers	5	55
problem with users Hi All, I just restore a database, fix the orphans users but if I give a new permission for a particular user for this datatase using T-sql it gives... JFB	02-17-2005 10:32 AM JFB	0	58
Eliminating Dynamic SQL I am refactoring stored procedures that use dynamic sql. The reason the store procedures use dynamic sql is because the data that is need comes from... John Dickey	02-17-2005 10:31 AM David Portas	2	56
Char compare to String hi I using C# to write a ASP.NET page and I need to compare a string variable to a Char field in the SQL table in SQL Server 2000 how can I write a... Lam	02-17-2005 09:53 AM Alejandro Mesa	3	55
Query question - Should this work? I'm using a query similar to the following example. To my best understanding, the subquery would return NULL (thus t1.AsOfDate = NULL). Should I get... Chris	02-17-2005 09:43 AM --CELKO--	5	54
passing table name as parameter for SP - asap Hi all, i have SP where i need to pass the tablename and the date as the parameter i started like this CREATE PROC SP_DEL_STG_TAB @TABLE_NAME ... sushma B V	02-17-2005 09:22 AM --CELKO--	4	55
Select command not working if date is null Why does the following not return records when the maximum counts_dt is null? set ansi_nulls off SELECT * FROM COUNTS WHERE counts.counts_dt =... Bernie Beattie	02-17-2005 09:22 AM David Portas	3	49
Output query results to text file What is the command in SQL Server that allows you to output query results to a text file. I know that you can save the results to text file from... ChrisB	02-17-2005 09:11 AM Alejandro Mesa	1	47
T-SQL: Changing the order of joins SQL server 2000: I have three tables - I'll call them A, B and C for simplicity. The join I wanted to achieve can be illustrated by the following... ian__@hotmail.com	02-17-2005 09:02 AM ian__@hotmail.com	4	47
Dynamic sql and variables Hi This may be a simple one. But anyway.... I would like to catch the result of a select statement executet as synamic sql in a variable. A simple... Klaus	02-17-2005 08:59 AM Klaus	3	56
Search with foreign keys Hi. If I have two tables connected with foreign key, is there any index build on "slave" table on column which contains foreign key for better... Milan Gottvald	02-17-2005 08:54 AM Uri Dimant	2	61
-- Class not registered -- sp_OACreate 'MSScriptControl.ScriptControl', @object OUTPUT,4 I'm successfully using the 'MSScriptControl.ScriptControl' from within a sql stored procedure. To enhance security and prevent that potential... Bart Michel	02-17-2005 08:51 AM Jacco Schalkwijk	3	69
Altering a Default- unknown name... SyetwemHi There. I'd like to alter a DEFAULT I have set up on a database table. Unfortunately, I don't know the name of the default as it was... len	02-17-2005 08:43 AM len	5	52
Stored Procedure Parameters: default values Hi, I need to know the default values of the parameters of an stored procedure for a db-wrapper I am doing. The information seems to not be in the... José Araujo	02-17-2005 08:31 AM José Araujo	2	49
Dynamic number of columns. Hi all. I do have a "simple" problem on my hand. I have one table containing PriceGroups. It could be 1 or many PriceGroups pr. produkt. When I list... Geir Holme	02-17-2005 08:28 AM Geir Holme	2	55

Page 1003 of 1545

1003

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