Hi there I am currently using the SET CONCAT_NULL_YIELDS_NULL OFF option to concatentate three strings, one, two or all of which may be null. I would like to insert a ", " in the appropriate place between the three strings, ie. where two adjacent strings are non-null. At present I am using...more >>

Should every table have a primary key? What are the criteria for adding one besides distinction? Do integers make better keys? If there is no logical choice for a key on the table, should one create an Identity field in the table and assign it as primary key? Also, should the database alwa...more >>

I'm a normal resident of the vbscript/wsh/server scripting forums, as I'm more of a scripter, and don't know word one about SQL...so here I am - :) I'm attempting to query a MS WSUS database stored on our SQL server (SQL 2000) - one of the two fields I am querying is reporting back fine (the...more >>

HI. is it possible to use a Select expression as a parameter for an Stored Procedure. something like: DECLARE spTest @id as NVARCHAR (4) AS [....] -- some code using @id and later use it in this way: EXEC spTest (select id from myTable where X = Y) ...more >>

I have a txt file of 200mb elevation data. There are 3 Columns (latitude, longitude, elevation). I have created a db in sql server called Elevation and imported the data fine. I want to sort out the locations by elevaion (which is the primary key). In SQL Analyzer,I have entered the followin...more >>

MSDE2000 has been installed on my computer. In the Data Link Properties window, item 1 is "local" and item 3 is "contactsSQL" and "C:\Microsoft Press\Access 2003 Inside Out\SQL\ContactsSQL.mdf". I get "Login failed for user" when I select "Use Windows NT integrated security" for item 2. I get...more >>

SELECT DISTINCT INSURED, COUNT(INSURED) AS C_All_By_Insured FROM CCI GROUP BY INSURED ORDER BY C_All_By_Insured DESC I would also like to include somewhere in this state a count of everything, I can use WITH ROLLUP I think, but I can't put it on a label, would like to have it as a sep...more >>

Hi All, If I had two machines, one an application server and the other a Data server and the application server was running a whole lot of webservices and the data was shot through and stored on the data server ofcourse. If I used SQLSERVER as the data server, how many SLQ client licenses do I...more >>

I have very good luck with using the "Database Maintenance Plans" to build database and transaction log backups, but I find it works better for me to not use the same plan for more than one function - i.e., create a single plan that does nothing but create the task to perform all the database ba...more >>

Where can I find the best instructions for setting up Automated nightly Full backups with transaction log backups every hour or so during the day ??? I've seen a ton of theory and discussion about Simple, Full and Bulk Logged backup modes but very few complete examples of how to set up Autom...more >>

Hi groups,=20 which is the best one among JOINS..? Comparison of joins if any..? --=20 M=E4h=E9sh Kum=E4r. R=20...more >>

In my nightly maintenance routine I'm getting an error when 'reorganizing data and index pages'. I am changing the free space percentage to 10%. In the log, the error occurs each night after the same table being indexed. The error is something along the lines of: Error 1105: Server could no...more >>

I have a stored procedure that generates a temp table. During tha process, the temp table is altered to add a new column with NUL values; as follows ALTER TABLE #Temp2 ADD [LOS] int NUL The column is later filled with values When I try out the stored procedure code in a query window in SQ ...more >>

How do I change the Authentication for MSDE 2000 to SQL? I cannot connect using the sa login but I can connect if I say it is a trusted NT Connection. Help Please....more >>

People used to design database systems with date column as varchar or text in earlier days. Why was that ? Is this convention still used in todays world of Relational databases like MSSQL Server ? Is there any particular advantage in using varchar ot text over native Date datatype ?...more >>

I am trying to add another column into each subquery, but I am receiving the below error. Query is below Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. BEGIN SELECT (SELECT SA, sum(TimeSpent) FROM Problems WHERE (TimeSpe...more >>

We are running SQL-server 2000 Standard Edition on a W2K-server today and we are going to buy a new server for faster performance. My question is: Is it possible to change to SQL2000-server Enterprise Edition on a Windows 2003 Standard Edition-server or do we need another Windows2003Server ver...more >>

Hi, Can someone tell me an easy way to update all my views/queries that are dependant on a table after I alter that table? If I delete a column from a table, all my views that are dependant on that table become incorrect. I've been opening each view individually and simply resaving it to...more >>

I am not sure if this is possbile. I would like to create one record set, based on the count of say like 6 tables. Select Count(*) as RecCount from Table1 where User = 'John' (6 matches) Select Count(*) as RecCount1 from Table2 where Address = 'Boston' (3 matches) Select Count(*) as RecCou...more >>

I have a SQL Server with a fair number of databases and a large number of tables per database. I want to audit user inserts/updates/deletes, etc. I would also like comprehensive reporting features as well. Is there a tool for this? I would be willing to invest the money it would cost, but ...more >>

Please see my schema for this table at http://www.middletree.net/latest.GIF I want to do a query that returns to me the data from the BriefDesc field from row which, according to the TIMESTMP field, is the most recent row. I am doing a search by TicketID. That is, there will be several rows per...more >>