Hello, I'm trying to figure out a way to join three tables together using Transact-SQL in SQL server 2000. I'm new to SQL and am not sure how best to proceed. _______________ Table1 |ID| |Document| 1 docname1 2 docname2 3 docname3 Table2 |ID| |Page| 1 page1 1 page2 ...more >>

Hi all, I'm kind of newbie in SQL programming and have a small problem. I'm trying to fill in test database through SQL Server Enterprise Manager. I opened a table, put some value into one of the columns and then I'm trying to get rid of that value and want it to be <NULL> (not blank). Ho...more >>

I'm currently auditing logins and logouts on our SQL Server. Is there a way that I can include extra data, such as where the login attempt is coming from, in an alert? -- Jason ...more >>

Recently in a project we had to filter rows retruned to a datagrid. problem was, that sometimes a search result into a ASP.NET datagrid resulted in 70,000 rows. it made our sersver go as good as dead.. This SQL-Server code can help. With this one can indicate what page (as in a book) one wa...more >>

Hello, Is there a 3rd party tool or a way to check how often tables or stored procedures have been used in SQL Server 2000. Any help will be appreciated. HL...more >>

Hello, Wondering if anyone can tell me where triggers are found in INFORMATION_SCHEMA? I don't think they're in routines.... Thanks in advance.... B. ...more >>

Don't have the code right now (when I go back to the office I'll post another msg w/ it), but essentially I'm building a temp table with records meeting certain criteria. They are keyed by Agent Number, and in this scenario Agents are in a hierarchical structure, and I want to compute totals fo...more >>

Anyone used WMI to get stats back on MS SQL Server? Any good articles anywhere? -- Ian (Freebasing On Boredom.......) BEING IN THERAPY And yet, having therapy is very much like making love to a beautiful woman. You... get on the couch, string 'em along with some half-lies and evasions,...more >>

I'd like to be abe to dynamically build a tsql command to execute a stored procedure that takes parameters. Is this possible? ...more >>

Hello Friends, Situation: I have been charged with cleaning up a large legacy database. During this process I have identified tables no longer used and removed them from the schema. Question: I now have may stored procs that reference these tables and are no longer needed. How can ...more >>

I have a stored procedure that I would like to be able to pass a table or cursor into so that it will process whatever records are contained in the input data. Is there any way to do this in T-SQL? If not, can somebody suggest a good workaround? Thanks very much in advance. ...more >>

Hello all, We are experiencing a problem with DTS on SQL Server 2000 SP3 running on Windows 2000 (i believe all SP are installed) We have what is called a RealTime DTS package that runs every few minutes bringing data over from DB2/AS400 via HiT Software ODBC Driver. This has been running f...more >>

Hello all. If I index an integer column and have a query like this: Select abs(IntegerColumn-120) as Expr1,* from ATable Order by Expr1 then, does Sql Server use indexing? (I want to know which approach has better performance). Thanks....more >>

Hello all, I know this may be a basic question, and that the short answer is probably "Yes"; but the File menu on the Computer Management console doesn't have an Add or Remove Snap In choice. When I run MMC (from the run command), I get a new/blank console, the Add or Remove Snap In choice i...more >>

Hello all, I'm currently facing a performance problem. I tried different things without finding the problem... I have two machine on which I have installed sql server 2000. The first machine (A) is running windows server 2000, it has 1 Pentium 4 processor and 1Gig of memory. Here is the ...more >>

This seems like it should be simple, but I haven't been able to come up with the magic. I have a query like: ------ SELECT * FROM tblSMSchedule WHERE (strUser IN ('Kevin', 'Bob') ) ------- this works as desired. What I need to do is put this in a stored procedure l...more >>

Hi I'm not very experienced with SQL, so plz bare with me. I'm busy developing a C# app that is accessing SQL Server 2000. I have to check a table and update my screen if something in the table has changed. How do I check if anything inside the table has changed? Kind Regards Nick ...more >>

I have a strange problem with restoring files. I have one SQL server installation that does not show any .BAK files that no longer have the archive bit set. Is there a switch somewhere that I can throw to change this back? I have 3 other SQL server installations in different places that do ...more >>

Does anyone know where to find or how to write a quick user defined fucntion that will return a table object when passed the string name of the table object. The reason why I want dynamicallly set the table name in a stored procudue WITHOUT using concatination and exec a SQL String. Hence ...more >>

Hello everyone. I am brand new to the "SQL" and SQL software, and don't know very much about it. I am considering purchasing an network enterprise application that requires Windows SQL Server 2000, but a single user version of this application will work with MSDE (desktop) on a standalone ...more >>

Hi, In my databases list there is one database with an empty name. I don't know how it got there, but I want to get rid of it. My whole SQL Server is messed up now, I cannot even add a table or something like that. I cannot drop it from Enterprise manager. I cannot drop it with SQL, beca...more >>

I have a need to use the "single-user mode" of SQL Server 2000. I run the command as instructed and the database starts up, but I cannot run the DBCC CHECKDB with the REPAIR_FAST option as it says there is more than one connection and it must be in single-user mode. So the question is, After ...more >>

Which edition of SQL Server is required to Create and edit tables and fields from a workstation. -- Gregory M. La Due Twin Tiers Technologies, Inc. Senior Programmer gml@twintierstech.com (800) 480-6467 ...more >>

hi all i've got a stored proc that looks like this: CREATE PROCEDURE spRecordUserAccess ( @iUserID INT, @sViewSource nvarchar(100), @sDateTime datetime ) AS Declare @iViewCount integer if (not exists(select viewCount from recordAccess where userID = @iUserID and viewSource = @s...more >>

Hi All, I just installed the Analysis Manager and was stepping through the tutorial. I created a cube and the Dimensions witout a problem. I did the Process Data and that completed witout errors. The problem starts when I right click on my cube and select Browse Data. At that point I get a ...more >>

Posted - 08/04/2004 : 14:23:14 -------------------------------------------------------------------------------- I have a basic qustion that for some reason I can't figure out. Below I have 2 tables, Table UserGroup's ID column is a FK from Table Users. I'd like to get a result set...more >>

Hi, My application can store bmp and Jpeg type pictures to SQL2000. Would anyone can tell me ,how to know the saved image in SQL2000 is bmp or jpeg type file? Thanks Silas ...more >>

Hi All, I have searched everywhere (that I can think of) to find out how to create a table using a variable IE: declare @Wk varhcar(9) select @wk = 'testtable' Create table dbo.@wk Would someone point me in the right direction? Thanks a lot, Roy ...more >>

Do any versions of SQL Server support the following functions, as they appear in the Oracle Database:- 1) XMLElement 2) XMLAttributes 3) XMLForest Thanks in Advance for your reply s...more >>