Rating Thread / Thread Starter	Last Post	Replies	Views
Different where clause depending on parameter values The following SP had 3 parameters. The first one is never NULL, but the 2nd and 3rd may be NULL. I do not know how to it other than the illustration... larzeb	12-26-2004 06:59 PM Adam Machanic	3	43
How to drop distribution database? After disabling publishions and distribution on a server there still is a database "distribution" which cannot be dropped or deteached due to... Przemo	12-26-2004 04:56 PM Mary Bray	1	48
SQL Syntax Help I need some help with a SQL statement (SQL Server 2k). I have three tables, an Artists table which holds user info, a Types table which holds the... NathanV	12-26-2004 04:48 PM Tom Moreau	4	56
Combining rows Need help writing a SQL command to do the following I have two tables, TableA and TableB Table A has three columns: code sequence description and... RickN	12-26-2004 04:15 PM Pike	2	50
Newbie: joining a table to itself Hi, I have the table structure below: CREATE TABLE . ( NOT NULL , (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , NULL ) ON GO John	12-26-2004 03:55 PM --CELKO--	3	41
Transaction replication problem Hi, I am configuring transaction replication on 2 computers, using no-doman accounts. Account I use is the same on 2 machines, same are... Przemo	12-26-2004 12:31 PM Przemo	1	50
Copy records from one database to another remote database Hi, I have two servers, each one has Database "Clients". Database # 1 is connected to a web application and it updates database # 1 every day. I... Carlos	12-26-2004 10:58 AM Carlos	3	50
Changing account for SQLServer problem Hi, I cann't change account for sqlserver service as well as for a sql agent to different than System. I get a message that such a account does not... Przemo	12-26-2004 07:49 AM John Bell	3	45
Query Analyzer: displaying errors immediately Hello all, Quick question: how can I display all returned SQL Server errors directly when they occur? Thanks in advance. Kind regards, Freek... Versteijn	12-26-2004 06:05 AM Erland Sommarskog	1	45
How to read specific outlook email attachments from SQL Hi! I hate to bother you all with this, but I don't know how best to approach a particular task. Here's the deal: Once a month I personally (that... Karen Grube	12-26-2004 05:35 AM John Bell	3	48
Suitable alternatives to using CURSORs Many a book mention the evils of CURSORs and how to avoid them. Yet, for a specific problem, I have gotten the best benchmarks out of one. The... shripathikamath@hotmail.com	12-26-2004 05:22 AM Erland Sommarskog	2	52
Executing a string Hello How can I code it so that not only do I get the name from sysobjects but also having an additional field next to it. The code so far declare... Steve Read	12-26-2004 05:06 AM Erland Sommarskog	8	66
View Diagram Pane - how save layout after I change it? 2000 Hello -- Is there a way to configure 2000 so it will save a view layout after I change it in the diagram pane? Thanks for any help. Larry Mehl L Mehl	12-26-2004 04:37 AM John Bell	1	55
Efficiency of IN statement I wonder, waht would be more efficient: WHERE code IN(14,15) or WHERE coe = 14 OR code is 15 This example is for 2 values; suppose there are 5 or... hansje	12-26-2004 12:49 AM --CELKO--	2	46
Database Design Hi, I'm designing a database with this scenario: Our application will be used in big organization that each organization has some sub-organizations.... Leila	12-26-2004 12:41 AM --CELKO--	9	54
UPDATE with UNION T-SQL Problem I can't UPDATE my table with UNION statement as below UPDATE OrgChart SET lft = ( SELECT COUNT(*) FROM ( SELECT lft FROM OrgChart UNION ALL SELECT... Joel Leong	12-26-2004 12:34 AM --CELKO--	4	49
Trigger question I have the ProcessDate field in the table. When this field is updated I want to set a trigger, which will update Process1Date field on the same... MichaelK	12-26-2004 12:27 AM --CELKO--	6	48
Need sql gurus' help with this sp!!! In sql2k, I'd like pass a dynamic where clause to a stored procedure. Here is an example using the Northwind database. Can anyone tell me if there... === Steve L ===	12-26-2004 12:17 AM --CELKO--	4	47
cardinality I am a beginner at designing sql databases. Please define 'Cardinality'. RJ	12-25-2004 06:41 AM John Bell	2	61
How to clear memory usage after executing queries ? ( 1 2 ) We have a SQL Server 2000 database that has about 10 million records. The database has 1 table, and the table has 3 columns. CREATE TABLE . ( NOT... Paul fpvt2	12-24-2004 11:55 PM Paul fpvt2	16	77
SQL 7.0 sp4 Hi, I am attempting to install SQL SERVER 7 sp4. The installation starts ok, I choose windows authentication as the connection mode and then the... Martin	12-24-2004 09:37 PM	1	65
Tricky CASE statement I am so close but can't quite nail this one down...I hope someone can help me. This is the query I need except that I need the distinct ssn count... Susan Cranford	12-24-2004 06:34 PM Susan Cranford	6	44
How can I prevent undesirable conversions done by ADO.NET? Hi, I have a simple command.ExecuteNonQuery() to insert some data into the SQL DB. The data can be inserted, but the characters like '\n' are... TomTom	12-24-2004 05:10 PM Dan Guzman	7	60
Double inserts how can I have transaction over more than one procedure on the same database? one idea is to create new procedure, which runs all other... simon	12-24-2004 04:48 PM Hugo Kornelis	4	60
Seasons Greetings Merry Christmas/happy holidays to all those that are aware of it. For those that aren't consider it a minor reality check :) Pike	12-24-2004 03:56 PM Hugo Kornelis	5	60
<<filegroup>> files from different hard disks:: tables(s) storage Hi I am feeling very ignorant on these matters, so please help out a technologically disabled woman !! I want an easy way to store table data on... Tania	12-24-2004 01:37 PM Andrew J. Kelly	7	40
UniqueIdentifier Data Type I am trying to pass a UniqueIdentifier as a parameter to a SQL Server stored procedure from a .asmx webservice. Whenever I try to run it, I get... Jeff Cobelli	12-24-2004 09:45 AM Adam Machanic	1	59
Partitioned view on tables with text field Is it possible to create a partitioned view on a table that has a text field in it (obviously not as a partitioning field)? I tried but I get the... Buddy Ackerman	12-24-2004 09:36 AM Anith Sen	9	43
Stored procedure date time format into date only Iss it possible to change the stored procedure date time parameter format into date only? A Crystal report is created using stored procedure and... Hamada	12-24-2004 05:39 AM John Bell	1	49
Where condition How you can see, which condition is better for executing query? ................ WHERE datepart(yy,dateInsert)=@Iyear AND... simon	12-24-2004 05:03 AM Hugo Kornelis	1	50
Temporary Tables Hi, BOL says that a local temporary table is available to current connection. But it seems that it is not available to batches higher than where the... Leila	12-24-2004 04:36 AM avnrao	1	51
Tricky select , help needed There is a table: create table tmp (id1 int, id2 int) and some data in there: 1 2 1 3 1 4 1 5 2 1 alex	12-24-2004 03:29 AM John Gilson	3	46
Holidays I am designing an HR system and have the following solution for calculating duration of working days for absence. Please advise any obvious problems... CJR	12-24-2004 03:25 AM CJR	3	53
How to get tree by OPENXML? Hello! There are two tables to organize a tree structure. I need to populate these tables by data from XML-file. OPENXML would work fine, but what... Sergey Bogdanov	12-24-2004 02:07 AM avnrao	5	44
Application Pool Hi , I get this error on my server event log "The identity of application pool, 'TestAppPool' is invalid ..." .. I donot have any idea about this... Anu	12-24-2004 01:08 AM avnrao	1	49
building an alter view statement dynamically within a cursor I am currently trying to automatically perform and alter view by using a cursor. I know that most of the people that will reply is going to... asptodotnet	12-23-2004 11:05 PM Max	1	40
Inserting line breaks (\n) in SQL DB Hi, I am trying to insert the text below to the SQL DB using ADO.NET. I have trouble inserting the '\n' character to the database as it is, meaning... TomTom	12-23-2004 07:10 PM Dan Guzman	7	52
Reading Execution Plan Hello World, May I ask how to reason the following: I have two queries which return exactly the same results (and 220 rows). I place the two... C TO	12-23-2004 04:16 PM Hugo Kornelis	2	46
better way to write this query Ive got a Proc that takes way too long in Production. (30 seconds or more) It contains temp tables. The only way I could figure to get rid of them... ChrisR	12-23-2004 04:08 PM Hugo Kornelis	2	59
No. of fields in a table A table can have 1,024 columns.But taking into consideration speed and design of the database, how many fields do you think a table can have? Thanks... Preeta	12-23-2004 03:47 PM Anith Sen	7	55
Classification crosstab query - 2000 Hello -- I think this is the term for what I want (something that could be generated in ACCESS using a pivot table, or, maybe Yukon). We have data... L Mehl	12-23-2004 03:32 PM L Mehl	3	38
DMO, sp_OA and Jobs Hi all, Using SQL2K sp2. Assuming I already have handles for SQLServer, JobServer, Jobs collection, and Job object below, what is the corresponding... Paul	12-23-2004 02:15 PM Paul	0	51
How can I assign the result of dateadd to a variable ? ( 1 2 3 4 5 ) We have a SQL Server 2000 database that has about 10 million records. The database has 1 table, and the table has 4 columns. CREATE TABLE . ( NOT... Paul fpvt2	12-23-2004 01:53 PM Paul fpvt2	47	178
Questions about stored procedure I have a VB program that calls a SQL Server stored procedure that insert to the database. This is what I do in VB: adoCon.execute "exec myInsertSP "... Paul fpvt2	12-23-2004 01:49 PM Paul fpvt2	4	52
Search inside a XML string Hi, I have a TEXT field called XMLString where I'm storing an XML string. For example, I may have this: <Company>Thorn Corp</Company> <Address>101... Star	12-23-2004 12:59 PM John Kane	4	46
Connection performance issue ( 1 2 ) From a front-end application point of view what is a more efficient way: Create a connection to SQL and keep alive reusing every time it needs to... Mark Goldin	12-23-2004 12:54 PM David Gugick	10	75
[OT] How do you pronounce "varchar"? In my country almost all programmers read "varchar", "char" etc as "vartschar" ("ch" is pronounced like in "chair"). As I suppose "varchar" comes... Miroo_news	12-23-2004 12:27 PM Ross Presser	9	58
how do you run a SQL script a ''.sql'' file Gidday, there are several programs which give you a script to write a table - eg aspupload (createtable.sql) to include in your database, or indeed... Ron	12-23-2004 11:52 AM Bill	3	50
runtime rocessing of rows and cols Hi, Working on a t-sql project that will process a table prepared by a front end. The front end: 1) processes a spreadsheet whose contents vary each... gtr	12-23-2004 11:48 AM Anith Sen	2	46
Permissions in tempdb As I understand the issue of disappearing permissions in tempdb has been discussed widely however I failed to find a solution to my... Michael Per	12-23-2004 10:37 AM Michael Per	2	44

Page 1047 of 1545

1047

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