Rating Thread / Thread Starter	Last Post	Replies	Views
Need help / suggestion Hey guys I have to implement a dynamic Parent - > Child Scenario ... but the catch is as Follows : I need to create this Table Design so that I can... lighthammer	02-28-2005 01:02 AM lighthammer	3	54
Security and access rights using local and global groups We've set up an SQL Server 2000 (build 8.0.761 - I think that's SP3) access control scenario like the one described in this... Clifford Heath	02-27-2005 10:49 PM Clifford Heath	0	45
sp_executesql vs. stored proc. Greetings All, currentley there is a heated discussion in my place of work over which method is better/more efficient for simple... LineVoltageHalogen	02-27-2005 07:39 PM Greg Gilman	1	49
Tempdb gets out of control when inserting records I have a very big table with 20 million records DistinctProjectionKey which i join several times to different tables in this query. select distinct... AG	02-27-2005 04:40 PM Erland Sommarskog	2	43
2 Questions: license Installation and Speed Hello, I have two questions, first some background info: We are running SQL 2000 on a Windows 2003 server for out aircraft parts database... aaron	02-27-2005 11:44 AM Andy O'Neill	2	37
How to create a new serverinstance but with old datafiles? Hi group I want to make a new serverinstance, but based on some old files from a previous instance I once had from a SQL I scrapped. I only know how... Adrian Hjelmslund	02-27-2005 10:58 AM Dan Guzman	1	50
Conditional summaring ( 1 2 ) Hi all I'm trying to create a summery table of rain data that holds a record for every 0.1mm of rain in the following format: Station Name, Time,... Ilik	02-27-2005 08:44 AM Ilik	10	112
Efficiently joining same table twice My main table has the following structure: t1 (id_primary, id_secundary, name) i.e. I want to join this table with the following second table: t2... honda	02-26-2005 05:52 PM Erland Sommarskog	3	48
forcing dbsqlexec to exit cleanly I am developing a simple DB-Library program in C calling SQL Server 2000 on windows 2003 and NT 4. I have some T-SQL code that checks for the... Gary	02-26-2005 05:43 PM Gary	3	51
Stored Procedure and multiple keys which could be NULL I have a table which has 10 columns which make up the secondary key. 1 or more of these columns can be set but the remaining columns in the secondary... Gaz	02-26-2005 05:43 PM Erland Sommarskog	3	46
BCP Utility - Skip rows.. Hello All, Does the BCP utility enable you to selectively import rows from a flat file to a table ? For example: The first column in my flat file... hharry	02-26-2005 05:17 PM Erland Sommarskog	4	64
BCP Format File I am new to BCP. Can anyone help me understand this? I tried searching the BOL but it doesnt show much help on syntex. Lets say I have a simple table... Query Builder	02-26-2005 02:41 PM John Bell	1	66
Converting Decimal to String W/O Decimal Point I'd like to convert a Decimal value into a string so that the entire original value and length remains intact but there is no decimal point. For... JD	02-26-2005 12:20 AM JW	5	45
Problem Installing SQL 7 or SQL SERVER 2000 on Laptop Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following... AlessanBar	02-25-2005 11:29 PM AlessanBar	0	56
Importing CSV files Hello, I need to import a bunch of .csv files. The problem I am having is the "non data" information in the files creating bogus rows and... tgru	02-25-2005 07:14 PM David Rawheiser	4	50
Parameterized order by clause: doesn't work Can someone tell me why SQL seems to ignore my order by clause? I tried to run through the debugger, but the debugger stops at the select statement... JJ_377@hotmail.com	02-25-2005 06:33 PM JJ_377@hotmail.com	7	52
error 7965 not a valid recordset property Dear All, (No aswers on access newsgroups) Access2000.adp connected to SQL-server 2000 MainForm unbound: seachform on companies meeting a complex... Filips Benoit	02-25-2005 05:13 PM Erland Sommarskog	1	51
How to check when a stored procedure was last called/executed Hi Our SQL server has a lot of stored procedures and we want to get some cleaning up to be done. We want to delete the ones that have been not run... bajwa	02-25-2005 05:13 PM Simon Hayes	7	49
Assigning column types in select into Group, Is there a way to assign nullability on a column when using a select into? I've tried some of the usual things like coalsce, isnull, and... Ray	02-25-2005 04:28 PM Erland Sommarskog	3	48
orphan recods Hi, Say, a database has all the FK constraints created properly, would sql server 2000 save this kind of meta data into sysforeignkeys table? Or it... NickName	02-25-2005 04:18 PM Erland Sommarskog	7	87
Datatype I am using Visual Studio .NET 2003 with SQL Server 2000. I am trying to insert the date and time into a SQL database by using hour(now). I am having... c_bowen@earthlink.net	02-25-2005 03:18 PM DH	4	104
data transform and compare with in a query Okay all I have a problem. I have two list of adresses and phone numbers. I do not have control over the contents of the lists The only unique... Dan Gidman	02-25-2005 02:35 PM Dan Gidman	3	50
Simple select question! Hi, I feel so stupid to ask this question, but here it goes When I select a column from a table, if the column has a null value I want the select... DBC User	02-25-2005 02:25 PM DBC User	4	46
Date query question! Hi, I've a problem with making a query. I need to get out a result where a date for example 25-02-05 is in a table. The problem is that the dates in... news.wanadoo.nl	02-25-2005 02:17 PM Simon Hayes	1	56
SQL-problem Dear All, Tables: ORDER, ORDER_PROPERTY relation ORD_ID = OP_ORD_ID ORDER: ORD_ID, ORDT_ID, ORD_NAME, .... ORDER_PROPERTY: OP_ORD_ID, OP_PRP_ID,... Filips Benoit	02-25-2005 01:53 PM Filips Benoit	2	100
Backing Up the Database (Newbie Question) I have a Database on a MS-SQL Server wich was at the beginning 55 MB (size). Every time I Backup the database the size increases (50 mb each time)... George	02-25-2005 05:26 AM Erland Sommarskog	1	45
Syntax error in update? Chris Cheney (cjc1@nospam%ucs.cam.ac.uk%no%spam%please) writes: This should be the same thing. The advantage with the syntax I used is that you can... SG	02-25-2005 05:20 AM Erland Sommarskog	4	56
Spinning Image Hi, Does anyone know how Reporting Services displays the spinning image while a report is being generated? I want to do something similar with CSV... bungle@wizardbuy.com	02-25-2005 04:39 AM bungle@wizardbuy.com	0	63
Update using an Inner Join Hello, I have two tables (table1 and table2). I want to set a flag in table1 for each common row with table2. I use the following syntax UPDATE... indabert	02-25-2005 04:19 AM NewSqlLad	3	50
2005 Express - Concurrent Connections Hi all ! Does someone know how many concurrent connections 2005 Express can accommodate ? The limit on MSDE was 5 before performance drops... Sebastian	02-25-2005 03:50 AM Simon Hayes	1	43
IF (SQL server) How can I make something that in MS Access query looks like this: SELECT IIF( Is Not Null,Amount,0) AS PayedAmount ... Regards, Markonni Markonni	02-25-2005 03:44 AM Markonni	2	77
Delete rows in Excel From DTS package I have a DTS package that needs to refresh data in 3 separate Excel spreadsheets on a daily basis. The problem is that unless I manually delete the... smonczka@hotmail.com	02-24-2005 05:38 PM David Rawheiser	1	48
Need help in log shipping I am attempting to set up log shipping from my primary dell clustered 2 node sql server to a backup quad xeon server in case of a failure. When... smyers1972	02-24-2005 05:32 PM Erland Sommarskog	5	50
Query to tranform rows to column Hi Your help for the following query will be highly apprecaited. I've wasted alot of time on it. Data definition is at the... muzamil@hotmail.com	02-24-2005 05:29 PM Erland Sommarskog	2	48
Sql Server Developers Licence Hi, I have just started a business and I was wondering if I could get some advice about product selection. I am currently buiding my website using... Jack	02-24-2005 04:34 PM Erland Sommarskog	1	53
Key Lock Hashed Resource Text Value not unique? I have a deadlock situation, part of the problem looks like this; spid ecid dbid ObjId IndId Type Resource Mode Status ------... Jake	02-24-2005 03:43 PM Jake	1	53
[mssql][ant] Failed to execute: GO Hi, I am trying to execute a simple sql file thru ant task. The file is: use GO However I get the errror message: Failed to execute: use GO maciek zywno	02-24-2005 03:04 PM Craig Kelly	1	52
Syntax problem Hello. I hope I have choosed right group. I have problem preparing SQL syntax. I think it is quite simple but I haven't tried to do this till... Dominik	02-24-2005 09:15 AM Dominik	2	74
Auto-increment PK - Use MS or Grow your own ? ( 1 2 ) SQL 2000 I thought I would throw this out there for some feedback from others. I'd like to know if you feel using MS auto-increment field is a... csomberg@dwr.com	02-24-2005 09:11 AM --CELKO--	11	97
access data in remote SQL server with trusted authority I have two win2003 servers. One is IIS and the another is SQL server. I can use... jingsheng.zhou@gmail.com	02-24-2005 08:36 AM Simon Hayes	1	56
Using SELECT LIKE with ADO Parameter in ASP Page Is it possible and how do I do use a select like query with an ado command's parameter object? For Example: Instead of this: command.CommandText =... codeurai	02-24-2005 05:25 AM Erland Sommarskog	3	50
restore db stuck loading ( 1 2 ) Hi I am trying to copy a 20 GB database from server 1 to 2. I took a full backup, copied to server2 and restored ( ready for use) using EM. After...	02-24-2005 02:29 AM Erland Sommarskog	13	96
list schema's of a sql server hello, what is the sql server 6.5 equivalent for: "select catalog_name from information_schema.schemata" i would like to see a list of available... clogwog	02-23-2005 09:20 PM clogwog	2	64
open query help Adding numerical field to filters in openquery is as easy as typing the number but I am having major problems using strings. I have tried a few... david.good@stramit.com.au	02-23-2005 05:24 PM Erland Sommarskog	1	65
Question about SUM and Nulls I'm doing what I thought was a simple GROUP BY summary of fairly simple data and the my numbers aren't working out Some results are showing up... mike	02-23-2005 05:01 PM Erland Sommarskog	6	59
Date Compare in SQL Server Stored Procedure Hi, i have "req_date" column of "datetime" type in Database table besides other columns. From my Web page, i am calling the Stored Procedure with... mhk	02-23-2005 04:48 PM Erland Sommarskog	3	52
SQL DATEADD function I need help in T-SQL. I am using DATEADD function and I want to add 6 months to a date. But it does not return me the rusults, which I want e.g.... Abdul N K	02-23-2005 04:39 PM Erland Sommarskog	2	60
user defined functions & default parameters Hi, I am trying to call a user defined function(UDF) from a stored proc, using a default parameter in the called UDF (e.g. @bid_price_type int = 0... Vic Y	02-23-2005 04:30 PM Erland Sommarskog	2	50
Group by Problems I know when you are using group by functions you have to include all the columns in the GROUP BY clause. But what I am having problems when using a... ree32	02-23-2005 04:04 PM ree32	4	77
"Hill Climbing" -- a More General Question on Systematic SQL Skill Upgrade I'm wondering if someone has thought about this, one desires to enhance his/her sql skills proactively vs. skills gained over a period of time merely... NickName	02-23-2005 01:24 PM NickName	2	60

Page 161 of 283

161

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