Rating Thread / Thread Starter	Last Post	Replies	Views
Join not returning records if one missing. How do I set up my query to get data from a 2nd file when there may not be any data? For example, the following select just gets some data from the... tshad	04-21-2005 12:30 PM tshad	5	46
inserting SQL statement in a table Hi, I want to insert an SQL statement in an sql table, i think i need an escape character for the single quotes in statement? declare @statement... MAQ	04-21-2005 12:30 PM Sergey Zuyev	3	37
DTS with Oracle How do I use DTS to execute a stored procedure in an Oracle Database?	04-21-2005 12:22 PM Ilyan Mishiyev	1	41
inserting records I am trying to insert records from one table to another and I get the following error. The conversion of char data type to smalldatetime data type... Munch	04-21-2005 12:21 PM CBretana	2	43
inserting records I am trying to insert records from one table to another and I get the following error. The conversion of char data type to smalldatetime data type... Munch	04-21-2005 12:19 PM CBretana	1	40
How to Query Question I have a table of Salesmen and as a child table, with PK FK constraint, the OrdersBySalesmen with a DateOrdered field in the latter. Table... RD	04-21-2005 12:11 PM Alejandro Mesa	2	40
replace Hi Guys Stupid question, How would I replace all euro signs with pound signs within a column in a database? would I use SELECT REPLACE? Jaco Wessels	04-21-2005 12:02 PM Jaco Wessels	4	50
SQLCE Push pb on VB.Net Compact Framework SQLCE Push pb I have a VB.net compact framework program written in VB. Net on a pocket pc 2003 that uses a SQL CE database. I'm using RDA to sync... fleurdefarine@hotmail.com	04-21-2005 10:26 AM Guest	1	74
Re: How to consolidate duplicate records You can use GROUP BY like: SELECT col1, col2, col3, SUM( col4 ) AS "col4" FROM tbl GROUP BY col1, col2, col3 ; -- Anith Anith Sen	04-21-2005 10:14 AM SG	1	46
Is this a bug? Interaction between REPLICATE and database collati I have the following reproduction script: ================ BEGIN ================ -- the default collation of the SQL Server instance is assumed to... Steve Shaw	04-21-2005 09:29 AM Steve Shaw	2	41
Retrieve Recordsets alogn with column name Hai , I want to get the column names along with the rows of a table as a record set is that possible? Thanks, V.Boomessh Boomessh	04-21-2005 09:26 AM Thomas	7	39
Deleteing Duplicates Hi, Does anyone have a useful way of deleting duplicates so that it leaves 1 in the table and removes the other. Currently I use a #temp table but... Steve Lloyd	04-21-2005 09:23 AM Alejandro Mesa	2	47
Use trigger to run activeX script and pass variable Hi, I am trying to write a trigger for updates and inserts on a staff records database that will run an activex script that populates active... Enterprise Andy	04-21-2005 09:16 AM David Portas	1	37
Information_schema and Procedures and logins Is there an information_schema view to check if a proc / login exist? Chedva	04-21-2005 08:12 AM Jacco Schalkwijk	4	34
Alter table db size getting increased. Hi, I am doing alter table and updating Nvarchar datatype to Ntext. AS there are almost 54,09,873 records installation is taking more than 3 hours... Sanjay	04-21-2005 07:47 AM Sanjay	4	37
Can Dynamic SQL be used to define a cursor ? Just wondering... marcmc	04-21-2005 07:39 AM Alejandro Mesa	5	45
help me out for a simple query I am sending a small scenario i have a table CREATE TABLE STUDENT_ANSWERS(EXAMID INT, MARKS INT); INSERT INTO VALUES (1, 20) INSERT INTO VALUES (1,... kamal hussain	04-21-2005 07:28 AM Itzik Ben-Gan	1	34
Deadlock detection My app uses ADO 2.8 with C++. Is there any way to retrieve sufficient information when a deadlock is occurs between two ADO connections to an SQL... Bae,Hyun-jik	04-21-2005 07:27 AM Alejandro Mesa	4	43
instead of trigger to accomplish on delete set null for foreign key in sql server 2000 i guess there is no on delete set null option for a foreign key I have seen many postings when searching about you have to do... Chris M	04-21-2005 07:24 AM Alejandro Mesa	3	34
SQL-92 Multiple OUTER JOINS How can I express these joins using SQL-92? select .... from tbl1,tbl2, tbl3 where tbl1.col1*= tbl2.col1 and tbl1.col2 like '%MyStr%' and tbl1.col3... Adam Sankey	04-21-2005 06:47 AM Itzik Ben-Gan	3	32
Verifying dynamic sql before sp_executesql Hi. Is it possible to verify/validate a dynamic SQL string before using sp_executesql to execute it? This would be used to avoid everything... NeilDJones	04-21-2005 06:23 AM David Portas	2	38
Recovery model setup using Tsql hi, i need to change my recovery model to SIMPLE but using TSQL and once installationn is finished i need to revert back to FULL can anyone... Sanjay	04-21-2005 04:53 AM Tibor Karaszi	2	41
SQL Print Statements hi , Does anyone have any knowledge of print statements within a storedprocedure crashing IIS or causing other serious problems?? cheers ian Ian Oldbury	04-21-2005 04:38 AM mark baekdal	2	45
coalesce Hi, How can i display a integer value to it's description i a lookuptable? I did something like this, but i still got the integer value. select... Jason	04-21-2005 04:18 AM Uri Dimant	4	45
Asynchronous ADO procedure invocation? Is there any way to send several ADO Command.Execute asynchronously at once? Please reply. Thanks in advance. Regards, Hyun-jik Bae Bae,Hyun-jik	04-21-2005 04:09 AM Jens Süßmeyer	3	93
Getting names from RID: db_id:file_id:page_no:row_no Is there any way to retrieve table name and record data from RID: db_id:file_id:page_no:row_no, for example, RID: 1:1:1253:0 in my program? Please... Bae,Hyun-jik	04-21-2005 04:07 AM Razvan Socol	1	46
Odd behavior when calling a user function within an aggregation function While debugging a code on the sql server 2000 debugger, I have encountered a strange behavior while calling a user function from whitin the...	04-21-2005 03:25 AM Razvan Socol	2	38
User-Defined string Functions Transact-SQL Free User-Defined string Functions Transact-SQL http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 Description GETWORDCOUNT()... Igor Nikiforov	04-21-2005 01:09 AM Igor Nikiforov	0	40
Free User-Defined string Functions Transact-SQL http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 Description GETWORDCOUNT() Counts the words in a string GETWORDNUM() ... Igor Nikiforov via SQLMonster.com	04-21-2005 01:02 AM Igor Nikiforov via SQLMonster.com	0	40
Help needed in an Updation Query Hai , Can any one of, out there help me in the following query. I have two tables, one table has to get updated with sum of another tables value.... Boomessh	04-21-2005 12:48 AM Boomessh	2	37
nested loops join ( 1 2 3 ) Hi, I have a select statement that gets data from only one table. When I write OPTION(LOOP JOIN) after this query and run it, the execution time is... Malin Davidsson	04-20-2005 09:45 PM Michael C#	23	89
Need help w/ Deleting records Hi, I have two tables Tasks and TaskTeam. One of our employees wanted me to bulk delete all her tasks. We have relationships defined between the two... Sam	04-20-2005 09:18 PM Sam	3	42
Can someone helpl me write this query to create a crosstab(pivot t Hi. I am trying to write a crosstab or pivot table, but I don't think the syntax that I'm writing is very efficient. It is using a union statement... David Reynolds	04-20-2005 08:38 PM Rob Farley	4	49
How to get specific number of rows from each group I need a SQL query to get 2 items from each catergory. And if possible, 2 items with price < $100 and 1 item with price >= $100 from each... Geevi	04-20-2005 08:11 PM Geevi	5	44
Opinions desired on using table as mechanism to serialize access to generic resources. So, I'd have a stored procedure that is something like: CREATE PROCEDURE . @LockName varchar(64), @MachineName varchar(64), @UserName... leov@orrtax	04-20-2005 06:07 PM leov@orrtax	1	41
converting interbase/firebird trigger to sql server in an interbase/firebird trigger i can do this for select col1 from table1 into :tmpCol1 do begin insert into table2(col1) values... Chris M	04-20-2005 05:22 PM oj	1	47
Identity columns and instead-of triggers I am sure this has been dealt with many times by others, so I'm hoping someone can provide a clue. Lets say I have a table (SQL 2000) with... Neil W	04-20-2005 05:16 PM oj	1	41
Date information I am trying to create an sp that will be put into a report that allows me to pull information based on the last day to day year. E.g. today is... DBA	04-20-2005 05:00 PM Sergey Zuyev	2	42
Inner Join question I'm doing join of Table A with Table A That have 3 records every record has an 1 MS 1 2005-04-18 12:30 OUT... Silver	04-20-2005 04:51 PM oj	1	42
Stored procedure syntax question I am a seasoned veteran of MS Access, and have recently begun migrating my skills over to SQL Server. In an MS Access parameter query, if you want... Joel	04-20-2005 04:48 PM Joe Webb	7	38
table alias Michael Keating wrote: Chris M	04-20-2005 04:41 PM Chris M	3	46
Saving query result into a temp table I have a subquery that gets the max of quote_date and requery the result to get the max of quote_id for the same part_id, vendor_id and quote_date. ... danlin	04-20-2005 04:35 PM oj	1	37
How to test existance for an index How do I test for the existance of an index with in a specific table? Thanks, Bryan BDB	04-20-2005 03:51 PM BDB	3	69
Updating fields in another database with triggers? I know this is a basic question for database design but Donald Trump said 'know a little about a lot' so here's my question. I have two databases. ... Matt Sonic	04-20-2005 03:29 PM Matthew Barbour	8	40
table CHECK constraint firing order Hi all, I ran into situation where domain integrity is implemented through table CHECK constraints with UDFs. But I have some concerns about how it... Alex	04-20-2005 03:27 PM Gert-Jan Strik	3	42
Query Tuning Hi, I have a query that selects 4 fields. One is of type Varchar(500). When I execute the query, the response is about 9 seconds (very slow). When... Rafael Chemtob	04-20-2005 03:17 PM Gert-Jan Strik	9	38
Hard Stored Procedure? I'm writing a stored procedure that will look for 'string' in the 'n'th column. For instance, exec QueryTable 1,'aString' ....should look for the... Ken	04-20-2005 02:59 PM Alejandro Mesa	4	40
inner query not joining before outer query uses convert Please refer to the following code for MS SQL Server 2k. This is an example of an issue that I'm experiencing on a much larger query. Let's say that... Nick Nack	04-20-2005 02:58 PM Nick Nack	6	42
sql server agent error log Does anyone know why an agent would in the agent error log turn itself off? This is an interesting situation as all backups and all log backups and... Bill Orova	04-20-2005 02:55 PM oj	1	39
FOR XML Explicit Greetings, How do I insert the XML document returned from the usage of FOR XML Explicit into a different table within a Stored Procedure. I have... Kayode Yusuf	04-20-2005 02:53 PM oj	2	52

Page 947 of 1545

947

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