Home All Groups Group Topic Search About

Score Clustered Index Not Working
Mary Fetsch - 18 Dec 2006 5:47 PM - 8 messages
I have a unique clustered index on a table in SQL Server 2000.  Its columns are Year (descending), Grove, Ticket.  The table's primary key is different than the clustered index. It was my understanding some time ago that if I created a clustered index on ...
Score Top 100 ... Order by in views SQL 2005 problem
James - 24 Oct 2006 9:30 AM - 8 messages
The following Microsoft article says that use of Orderby in views is now ignored in SQL2005. [link] There seems to be a work around: [link] ...
Score How to concatenate strings from a column into a single row (with NULL value)?
Cylix - 15 Sep 2006 9:07 AM - 9 messages
<snip> CREATE TABLE Colors (     Color VARCHAR(32) ) GO SET NOCOUNT ON INSERT Colors SELECT 'red' INSERT Colors SELECT 'orange' INSERT Colors SELECT 'blue' INSERT Colors SELECT 'green' GO DECLARE @colors VARCHAR(1024) SELECT     @colors = COALESCE(@colors + ',', '') + Color ...
Score Update Statement
Anonymous - 14 Sep 2006 7:28 PM - 9 messages
I have 2 tables in SQL Server 2000. Table1: ID           Field1      Field2       Field3 111 Table2: ID         Field         Code ...
Score Single to Multiple columns
Rob T - 15 Sep 2006 1:32 PM - 6 messages
I have a large table filled with product serial numbers.  Similar to how a datagrid in .net works, I would like to be able to query the single column, but have it return the data in 3 columns.  I have no problem having 3 unique ...
Score Explain this please!
MackS - 13 Sep 2006 9:59 AM - 8 messages
Hello, I am a beginner in this SQL Programming and trying to learn everything as quick as possible. I came across a query below and have a very hard time in understanding it. Specially the WHERE part of the clause. ...
Score Need Consecutive Query
rajalapati - 13 Sep 2006 1:28 PM - 9 messages
Hi Every body I need a query on table which looks like Date Unit Status 2006-07-12 Unit1 S 2006-07-13 Unit1 F 2006-07-14 unit1 F 2006-07-15 Unit1 F 2006-07-16 Unit1 S ...
Score sorting problem
aidanc - 14 Sep 2006 8:19 AM - 6 messages
I'm trying to write a query to sort a table by a column containing both numerical and alphabetical values. The values are stored as strings. The problem is that I need to sort numerical values numerically and sort anything with alphabetical characters in it alphabetically. ...
Score Help with query...
New to SQL - 14 Sep 2006 10:09 AM - 6 messages
My table is defined as TABLE PERSON id, int Name varchar(500) Table PlacesOfTravel Personid(fk from table PERSON) Place sample data for PERSON 1 Manmohan singh 2 Sonia Gandhi sample data for PlacesOfTravel 1 New Delhi 1 New York ...
Score SQL Select using parameter
nospam - 12 Sep 2006 2:29 PM - 7 messages
I have a rather simple select statement that is driving me mad!  Here is what currently works: SELECT     EntiyId, Source, LDAP_DN, EntryType, Message, EventTime FROM         dbo.ONT_LDAP_LOG ...
Score Different result from Script and SP
Svein Terje Gaup - 13 Sep 2006 2:28 PM - 8 messages
Hi, I have an SP that gives an incorrect value for one of the columns in the result set. I have been debugging, and so I copied the text from the SP, removed the CREATE Procedure part, and declared/assigned the parameters their ...
Score SQL query
BK-Chicago - 14 Sep 2006 8:04 PM - 8 messages
Hi I would like help with the following query. The table: CREATE TABLE [dbo].[MyTable] ( [ID]  [char] (5) AS NOT NULL , [period_date]  [datetime] NOT NULL , [value] [numeric](18, 6) NULL ) ON [PRIMARY] Sample Data:             0004N   9/30/1989                 67.309 ...
Score Query help.... with CASE
DL account - 14 Sep 2006 12:21 PM - 7 messages
--DDL create table systems ( sysid int primary key, sysnme varchar(30) not null, sysuser varchar(40) null, ) create table software ( swid int primary key, sysid int references systems(sysid), cmpny varchar(30), prod varchar(30) ) go --Data inserts insert systems values(1,'sys1','user1') ...
Score Query help
Ami - 15 Sep 2006 12:03 AM - 9 messages
Hi All I need a query help. How to display the record(only record) that has maximum occurrence of a particular value in a column? Say, I have a Table called Table1 with columns Col1, Col2, Col3 and Col4 and Col5. I want to display the record details that occurs maximum ...
Score Win Server 2003 SP2 - SQL2k5 Performance Improvements
tcs - 14 Sep 2006 4:52 PM - 7 messages
I have read that there will be SQL Server 2005 performance improvements in SP2 for Windows 2003.  Does anyone know the specifics on what will be improved? Thanks ...
Score how to do this
L.Peter - 14 Sep 2006 1:27 PM - 5 messages
Hi Group, I have been struggling this case for two days but still could not proceduce the desired result. I have student table: studentid studentname 001        student 1 002        student 2 ...
Score xp_cmdshell - works with string in one format but not in another -
smaas@newsgroups.nospam - 14 Sep 2006 9:06 PM - 5 messages
We are using xp_cmdshell in a trigger to call a VB program and pass to it required parameters.  The call with the parameters in the desired structure is below (code stripped down to bare essentials): declare @sDirectory varchar(200), @sBartender varchar(200), @sOutput ...
Score Case-sensitivity and LIKE - not working in 2000?
Paschott - 14 Sep 2006 6:43 PM - 4 messages
Ultimate goal - find all addresses that are either all lowercase or all uppercase.  Running SQL 2000, hotfix level between SP3 and SP4. Created a new table of address data that is case-sensitive. CREATE TABLE Address (Address_ID int , House_ID int ...
Score INSTEAD OF TRIGGERS DO NOT SUPPORT DIRECT RECURSION
Dimitris Ioannou - 13 Sep 2006 8:13 AM - 11 messages
3 months ago i posted a question about SQL SERVER 2005 I was migrate a SQL Server 2000 to SQL Server 2005 and the back-end code is not function well. I get from SQL Server 2005 the message "INSTEAD OF TRIGGERS DO NOT SUPPORT DIRECT RECURSION. TRIGGER EXECUTION ...
Score Trigger logic - this ok
Rob - 10 Sep 2006 12:24 AM - 16 messages
If I want the row inserted into the table regardless of whether or not the Stored proc completes successfully, then is there any problem with employing the following technique (placing a "commit  transaction" on the first line) ? CREATE TRIGGER testtrigger ON dbo.Orders ...
Score Need help with self-join
Terri - 14 Sep 2006 9:50 PM - 3 messages
I am using a self-join to add amounts with different dates in the same table. CREATE TABLE #Testdata ( Account char(1), AmountDate datetime, Amount int ) INSERT INTO #Testdata (Account, AmountDate, Amount) VALUES ('A', '20060801',5) INSERT INTO #Testdata (Account, AmountDate, Amount) VALUES ('A', ...
Score Deleting a record dynamically
Michel Racicot - 13 Sep 2006 7:29 PM - 8 messages
Hi there... I have some tables and their copy: RHUM010P and ##RHUM010P_Inserted which is basically a copy of the inserted record in RHUM010P Now, for each record in ##RHUM010P I need to delete each and every records who are presents in ##RHUM010P_Inserted ...
Score Bulk Insert To Temp Table - Security Issue
MG - 13 Sep 2006 9:49 PM - 11 messages
I have a stored procedure that dynamically builds a BULK INSERT command and load data into a temp table. I can run it fine. Of course I am the dbo and sa. The user has BULK Administration rites setup in SQL. ...
Score Linked Server Error: Login failed for user NT AUTHORITY\ANONYMOUS LOGON
Jay - 14 Sep 2006 3:24 PM - 4 messages
I have a SQL 2000 instance and a SQL 2005 instance on a 32bit Win 2003 Servers. Both systems are using the same user id & password. Both instances use windows authentication mode. In the SQL Server Enterprise Manager on the SQL 2005 instance I created ...
Score Managed Stored Procedures
rocket salad - 8 Sep 2006 10:45 AM - 8 messages
I would appreciate hearing some different points of views on this subject. Are / how are you using them? Are you avoiding them? Why? Are these so different to the extended stored procedures of 2000? I'm looking into what's new in 2005 before we start migrating our software - ...
Score Date Range
wnfisba - 14 Sep 2006 7:27 PM - 15 messages
Why would the following SQL return different rows??? SELECT    CQTLOAN.LOAN_NUMBER,     CQTLOAN.LOAN_CREATED_DATE FROM    CQDS50.dbo.CQT_LOAN        CQTLOAN WHERE    MONTH(CQTLOAN.LOAN_CREATED_DATE) = '06' ...
Score How best to create a unique identifier across two or more tables...
Jesse Aufiero - 14 Sep 2006 5:10 PM - 6 messages
I have a table that has an ID column set as an int type with identity set to 'Yes', so that each number that is auto-generated in this column will be unique.  However, now I need to add a second table to the database which ...
Score UNDO
catsailor - 14 Sep 2006 3:49 PM - 12 messages
Greetings, I am looking for a way to implement UNDO in my database apps.  We have several SQL 2005 Standard Ed and SQL Everywhere database apps.  Some are connected to web forms and a few others connect to Windows forms.  What I ...
Score Computing Medians The Joe Celko Way
JLS - 7 Sep 2006 7:48 PM - 5 messages
I have been researching the best way to calculate median values using SQL.  Most of the threads I come across include a semi-canned response from Joe Celko which I have some questions about. First, Celko says, I adapted this SQL to my situation but, unless I am mistaken, it ...
Score problem with synonyms
bajopalabra - 13 Sep 2006 12:13 PM - 7 messages
hi i have a problem when i try to EXEC a stored procedure thru its synonym that is :  [exec synonym_to_sp] this only happen when i do that inside another [sp] in another db that is             create proc [sp] as ...
Score sql statement (how to)
sampras - 12 Sep 2006 5:59 PM - 9 messages
I have a table with following sample records, How to select the desired result by sql statement, any suggestion ? Thanks in advance. Sample records number        Year        qty ...
Score Update Information in SQL from a VBS script
Matthew - 12 Sep 2006 5:38 PM - 11 messages
I have a vbs script that calls a list of systems inside a SQL database. It then uses that list to go out and collect additional information on those systems and inserts the collected data into another table. My question is what is the best way to remove redundant date.  Should I ...
Score Problem with repeated use of temp tables
Dmitriy Antonov - 14 Sep 2006 5:26 PM - 4 messages
Hello all, Following is a sample script for sp: Create Procedure spTest      @Flag Bit As If @Flag=0 Begin      Select *      Into #tmp      From tblTable1 ...
Score SQL Syntax - Incorrect Syntas near '1'
Greg P. - 14 Sep 2006 12:08 AM - 7 messages
I have created an insert statement by concatenation in VS2005 going to SQLSwerver 2005.  If i copy the string out of my watch window and run it as a query on my Database it works fine.  If I do an execute non-query on it I the ...
Score Small problem with NOT EXISTS...
kollatjorva - 14 Sep 2006 4:23 PM - 5 messages
Hi all I have this table guid      datecreated    account      dateremoved 5DC40536         1.8.2006  9574DAAD    30.8.2006 ...
Score Tool to compare SQL Schema?
DotNetDev - 11 Sep 2006 2:34 PM - 5 messages
Hi, Can any one recommend a tool (Free lisc, preferred) to compare SQL Schema (and may be data)? Thanks ...
Score Time recording query
dotnet dude - 14 Sep 2006 1:07 PM - 6 messages
Here is an interesting problem: Lets say I own some imaginary company. Like for all companies, my employees report their time to some time reporting application. Following table stores these time recording activities: EmpId    Date    Project    No_of_hours ...
Score XP_SENDMAIL Overload in SQL 2005
Dr. Network - 14 Sep 2006 1:51 PM - 8 messages
Not sure whether this is a setup or a programming issue. I tried setup and got no response. I'll try programming. In SQL 2000, I could drop system extended stored procedures without any problem and replace them with my own extended stored procedures or stored ...
Score Statistic Problem
tho - 14 Sep 2006 2:30 PM - 4 messages
Hi all, I'm searching for a simple sql statistic solution. I have 2 tables: 1st table: website-visits   |  department ---------------------------------- 5    |  A&B CD Z1 30  |  A&B AD Z0 ...
Score What am I missing with this simple query?
MarkT - 13 Sep 2006 6:35 PM - 13 messages
I am trying to add the results of this query to a new table using the procedure below: INSERT into db.TempCheckHistGN (EmpID,GrossPay,NetPay) SELECT EmployeeID, SUM(GrossPay), as Expr1, Sum(NetPay) as Expr2 FROM dbo.tblPACheckHist WHERE (CheckDate Between '11/1/2005' AND '12/31/2010') AND (EmployeeID >='' ...
Score hierarchical query 2005
eladla - 30 Aug 2006 7:19 PM - 27 messages
I am working with visual studio 2005 and sql server 2005 workgroup edition. I have three tables where each row has an ID and a PID. What I want to do is create either a hierarchical query to fill a data set ...
Score SQL 2005 slower than 2000?
RobbMichel - 12 Sep 2006 9:18 PM - 9 messages
We have an application that initially used SQL 2000.  We have a client that insisted on SQL2005.  Now when our application runs (for example) a stored procedure (and most other parts of the program) on the SQL2005 database it takes a lot longer than (3 or 5x longer) it does on the ...
Score Union with the results of two SP
Robert Bravery - 14 Sep 2006 2:08 PM - 7 messages
Hi all, I've been asked the question of one can peform a union with the results of two or more SP's Thanks Robert ...
Score I have no blog
--CELKO-- - 10 Sep 2006 2:27 AM - 67 messages
PUBLIC NOTICE: I have no blog.  I have never had a blog.  I have no idea who is using my name, postings and likeness on that "SQL Apprentice" blog. ...
Score get autogenerated id after insert
Sam Jost - 14 Sep 2006 10:30 AM - 9 messages
I got a table created something like this: CREATE TABLE dbo.MyTable (   [ID] uniqueidentifier NOT NULL ROWGUIDCOL CONSTRAINT [PK_MyTable] PRIMARY KEY, [...] )  ON [PRIMARY] ALTER TABLE dbo.MyTable ADD CONSTRAINT [DF_MyTable_ID] DEFAULT (newid()) FOR [ID] Now I INSERT a new row, and would like to know the ID SQL Server ...
Score How to implement transactions
Stephen K. Miyasato - 8 Sep 2006 11:01 PM - 12 messages
I'm new to implementing transaction and can you help in this manner. I have the sp below. I use @@Rowcount to see if the name is already present in the database and if so pass a message to the program. ...
Score XP_CMDSHELL Problem
Jinx - 13 Sep 2006 7:10 AM - 5 messages
Good people, I've searched through the Newsgroups but have not been able to find a solution to this particular problem. We have a number of SQL servers used by developers who claim ignorance when things go wrong.  As a consequence we now take a snap shot of who is using ...
Score Is it possible to trace all statements to a specific table?...
Roz - 13 Sep 2006 8:38 PM - 6 messages
Hello, all.  Using SQL 2005.  My developers feel their app is slow due to either non-indexed columns that should be indexed, or improperly indexed columns.   What I'm wanting to do is trace the workload against this table ...
Score UPDATE TOP 1
rzaleski - 13 Sep 2006 9:26 PM - 8 messages
In SQL Server 2005, you can use the following command: UPDATE TOP 1... SQL Server 2000 does not have this feature.  Is there a way around this?  I tried using a WHERE EXISTS clause, but that didn't work. ...
Score SQL Challenge
Itzik Ben-Gan - 11 Sep 2006 2:11 PM - 7 messages
[link] Cheers, ...
Score get counts for each unique value in a column
mahalie - 13 Sep 2006 10:59 PM - 5 messages
I'd like to get the count for each of 24 distinct values in a table with 3,200 records in it without having to explicitly query for each of the distinct values.  Is there some sort of "short cut" for this, ...
Score Dynamic SQL load into dynamic table
Scott - 12 Sep 2006 3:42 PM - 7 messages
First, I welcome any alternate solutions to this problem, but please, no lectures on proper SQL or how a database works. The problem: I am using SQL Server 2005 Std to gather data from multiple data sources (SQL, Oracle and DB/2) for reporting needs.  I have many, many reports that ...
Score Passing username to sql server from an app
JimLad - 13 Sep 2006 4:57 PM - 9 messages
Hi, I have an ASP/ASP.NET app that is connecting to SQL Server 2000 with login 'APP'. Users are logging into the app using Windows Authentication. What is the most generic way of passing the username through to sql ...
Score Set Database Context inside a stored proc
frankkirchner - 13 Sep 2006 1:55 PM - 6 messages
I need to use a SQL Server instance where there are about 100 databases, all with the same schema, but each relevent to a local operating company. The databases are named something like this, OPCO001, OPCO002, etc. My Web App needs to call a proc that will retrieve data using the same ...
Score Strange blocking problems
DC - 5 Sep 2006 9:44 AM - 3 messages
Hi, we are seeing increasing apparently not logical locking chains on two of our SQL Server 2000 installations (SP4). sp_who2 will reveal results like: SPID      HostName   BlkBy -----     ---------- ----- 930    WWW01       960 ...
Score **SORT THE PHYSICAL ORDER ON A TABLE'S COLUMNS**
M - 13 Sep 2006 8:14 AM - 15 messages
Hi I'm working in SQL2000 . how can I move the physical position of a column  in a table by script? for example: select * from table1 f1    f2    f3 ---- ----- ----- desired result: f3    f2    f1 ...
Score For insert trigger problem
Nader Shahin - 13 Sep 2006 4:33 PM - 5 messages
I have something weird happening with one of my tables. After inserting any new record in the table and jump to the next one, a totally different record appears instead of the one I just inserted. After that, when I retrieved all the records again I can find my record their ...
Score SQL search for similar records with different dates
Stanhelp - 13 Sep 2006 3:54 PM - 10 messages
I've created a query that joins 3 tables that needs to display only similar records that are in year 2005 and 2006. Current Example Results Data: Year    Name      Address ------------------------------------------------ 2005    ABC       95 Main St. ...
Score xml file into table
UA - 9 Sep 2006 10:40 PM - 7 messages
I have a xml file which contains nested data. for ex. each Order has multiple order details records. The data should go into Order table and Order Details table. How should I parse the xml file data so that it loads into two tables using ...
Score A .NET Framework error occurred during execution of user defined r
gaharlan - 12 Sep 2006 6:14 PM - 7 messages
The below message is returned on my Development Server. I am running the same version of SQL Server on my local machine Local connection is Windows, Dev Server is SQL Server Auth. The same T-SQL Script ran against local works. ...
Score Little bug in sql2005?
checcouno - 13 Sep 2006 1:31 PM - 15 messages
I found a strange behaviour in SQL 2005. In my soterd proc i've got something like this: /* My Code (wrong???)*/ ... if @MyVariable1 = 1 set @proD = @proD - @nCurPro + 1 +              ISNULL((SELECT SUM(ISNULL(TIP_PROFTOT, 1)) ...
Score Return a City in a column on max count from another column in a group by
gv - 12 Sep 2006 3:41 PM - 12 messages
Hi all, Trying to return the city that has the most switches in market             SELECT      SA.A_MARKET, SA.STATE, l7.[sw city], sa.switch ...
Score Help me performance optimize
Rasmus Lynggaard - 12 Sep 2006 9:30 AM - 13 messages
Hi all hope you are in for a challenge. I have the following query in a stored procedure. It takes a lot of time to run (hence around 2.5 million records to select from) Can anybody help me optimize this? ...
Score Table Design
george - 13 Sep 2006 1:14 PM - 6 messages
Hi, I am trying to design my database to handle dynamic user input. Currently, there is the standard order and order details design.  In order details holds the product id and other product data.  Each product could have user ...
Score Pulling data from Access database into Intranet?
Stewart - 28 Aug 2006 3:42 PM - 5 messages
Hi there, I have an Access database, which contains the details of company staff and services.  The plan is to extract data from this database onto our forthcoming Intranet (no inserting, updating or deleting at this point).  The Intranet itself has been created in ASP.NET, using ...
Score Passing tableName as parameter to SP
Ann - 13 Sep 2006 12:51 PM - 5 messages
Hi all, i am trying to retrieve the records based on certain column,where the tablename as well as columname is passed as paramater.Below is the SP.It works when i omit the where condiiton.Pls tell me where i am going wrong. ...
Score Strange result
simonZ - 12 Sep 2006 9:19 AM - 16 messages
I have something strange happening on SQL2005. I have 2 tables, orders and products. Now, I would like to see, if there is any order with productID and countryID which not exsists in product table. So, I created join: select distinct o.productID, o.id_country from  orders o LEFT JOIN products ...
Score How do I run a DTS package from vb.net
Gordon - 11 Sep 2006 9:56 PM - 5 messages
Hi; I am trying to execute a DTS package from within a vb.net module using VS 2003. I understand that you must add a reference to a com library. I tried using a reference to Microsoft.DTSPackage.Object Library ...
Score URGENT - Cannot find bad data in table
MartyNg - 11 Sep 2006 2:28 PM - 6 messages
I have a small table in SQL 2000 that has < 5,000 records. All of a sudden, I cannot run most queries against it...always get a time out. This is a CRITICAL production table, and I need to get this fixed ASAP. ...
Score Trigger ID
Joy - 11 Sep 2006 2:32 PM - 6 messages
Hi All, I am faced with a situation where i want to know the ID or name of a trigger that fires another trigger. For example say i have two tables namely tblSource and tblDestination. Now i have say one trigger(called ...
Score error-checking in dynamic SQL?
Rick Charnes - 11 Sep 2006 3:47 PM - 8 messages
When using dynamic SQL in SQL Server 2000, how do I confirm that my SQL statement executed successfully?  I have my statement in var @sql, and execute it with: EXEC @ck = sp_executesql @sql N'[...parm defintion list and values list...] ...
Score The opposite to DECLARE..
Man-wai Chang - 12 Sep 2006 11:44 AM - 10 messages
DECLARE instantiates a variable. How could I release a variable? ...
Score Generate intervals
dragos.hilbert - 13 Sep 2006 8:41 AM - 4 messages
In SQL Server 2000 I have a table: Place Id    Place  Date 1    10       2006-01-01 2    10       2006-02-01 ...
Score TABLE FUNCTION
SalamElias - 13 Sep 2006 9:49 AM - 5 messages
CaN i USE A TABLE FUNCTION IN A sp and USE THE TABLE RETURNED BY A FUNCTION INSTEAD OF THE TEMPORARY TABLE that I declare in MY SP? IF YES? HOW I can do this PLEASE, I mean do, mainipulate ...
Score Dynamically flattening a table
AlexT - 13 Sep 2006 7:25 AM - 4 messages
Hello Probably pretty trivial and classic problem but I can't figure it out... I'd like to design a view to "flatten" a 1:n relation, where n is unknown but say less than 100. So I have Parent  1:n  Child ...
Score validate statement before execute with sp_executesql
newbie - 12 Sep 2006 6:53 PM - 8 messages
Is there a way to validate or prepare a sql statement built dynamically. By validating it I mean making sure the table and field names are correct, the data types match, but not actually execute it. Ideas, suggestions ... much appreciated. ...
Score Programatically Accessing Maintenance Plans through SMO
Brad Baker - 12 Sep 2006 1:40 AM - 8 messages
Can anyone point me to any resources on how to programmatically add databases to maintenance plans through SMO on SQL 2005 preferably using VB? Thanks! Brad ...
Score SQL statement increase question
Pauljh - 12 Sep 2006 12:47 PM - 8 messages
Hi All,    Firstly appologies if this is the wrong group but I couldn't find a comp.lang.sql or any such one similar.    My question is probably a simple SQL question for experts among you, ...
Score Converting Orcale DECODE stmt to T-SQL
Rob - 12 Sep 2006 4:25 PM - 6 messages
Hi, I've been asked to convert some Oracle code to SQL. As I begin my journey, the first stumbling block I've come across is with this Oracle stmt: Select..... decode(ft.from_resv_id,null,''(Group)'',rn.guest_last_name||decode(rn.guest_first_name,null,'''','', ''||rn.guest_first_name)) "Guest" ...
Score Need CheckSum Algorithm
ManDev - 12 Sep 2006 3:37 AM - 8 messages
Hi, We have checksum function in sql server 2000,i would like to implement same in .Net.Can some one provide checksum algorithm. Thanks ManDev. ...
Score UDF that take a UDT as a parameter (CLR)
Andy in S. Jersey - 7 Sep 2006 7:10 PM - 6 messages
I have a feeling that I can't do this, but thought someone might have a way to work around this. I have a UDT type, called interval, that I want to be a parameter to a UDF. Let's say interval 1, i1 is [2:4] and interval 2, i2 is [3:5].  ...
Score Timeout expire
fniles - 10 Aug 2006 12:49 PM - 25 messages
When running a query in SQL Server 2000, I got "Timeout expired" error. How can I increase the timeout time ? Thanks. ...
Score c sql server library?
c19h28o2 - 11 Sep 2006 11:25 AM - 7 messages
Hi, I'm trying to connect to a sql server 2000 box using c but cannot find a library for it, any ideas the best way to connect to it? Cheers c19 ...
Score Dynamic SQL and column-values
Michael Schwab - 12 Sep 2006 8:06 PM - 8 messages
Hi, one question where I can't think of an answer - - imagine I had a variable that accepted simple SQL statements, like @test = 'SELECT col1, col2 FROM table ORDER BY col1' If @test was executed I'd like to loop through the data set and retrieve the ...
Score Re: Connections List
mason - 12 Sep 2006 7:58 PM - 7 messages
Another thought. If OLE DB driver does not provide a parameter for applications to submit a program identifier, is it possible to set this information into a system table from an app after the database connection is established? Thanks. ...
Score About Cursor on Dynamically created Tables.
amit - 4 Sep 2006 1:06 PM - 9 messages
DECLARE @SID Varchar(10) SET @SID = '00260AMIT' DECLARE @STR VARCHAR(1000) SET @STR = '' SET @STR = 'CREATE TABLE RD_'+ @SID +' (RESPID INT PRIMARY KEY, FLAG BIT)' EXEC(@STR)   DECLARE @FIELDCODE INT, @FIELDNAME VARCHAR(20) SET @STR = 'DECLARE CURTABLECREATION CURSOR LOCAL STATIC FORWARD_ONLY ...
Score Other ways to run this query?
Ian Boyd - 12 Sep 2006 6:54 PM - 2 messages
/*It's a long post, and it can all be copied and pasted into QA. i have a "TransactionEntries" table, that has multiple entries for a single transaction. Example#1 TransactionID,     CurrencyCode,     Bought,    Sold ...
Score Setting up the SQL Server alias programatically
Chris Dunaway - 12 Sep 2006 4:22 PM - 4 messages
In our corporate environment, the data services group, for some reason, does not run SQL Server using it's default ports, they always change. For my application, I have to install the SQL client tools on the machine where the app will be run and then set up an alias to that ...
Score Need help with select statement
jdemerath2 - 12 Sep 2006 3:35 PM - 8 messages
I have a SQL database and am having problems with a SELECT statement. I have an application that date and time stamps entries into the database.  I am trying to create a SQL statement that will return all records that are like 8/31/2006.  I don't want it to look at the time. ...
Score Cannot see system views?
JP - 11 Sep 2006 9:49 PM - 15 messages
Im trying to access the system tables for SQL 2005. I understand I can no longer access the tables directly, and I’m fine with that. But I cannot see the System Procedures folder or System Databases folder that several sites ...

Developed using NextGeneration, the .NET Code Generator Try AdSense Reporter, the charting tool for AdSense publishers