Hi, I have a numeric column which I need to conevrt to a ###,###,... format. select convert(MyColumn,money,1) does not add the commas as it should. I have seen another post on that matter but with no resolution. (I am working with SQL2000) Can anyone help? ...more >>

If the sql server is located in western time zone of usa and has its time set correctly, and I am at my computer on the eastern time zone of america, shouldn't getdate() ALWAYS report the LOCAL time for me? assuming my local clock is set correctly and the server clock is set correctly, shouldn...more >>

is this really true? that you can not install a sql 2000 on windows 2003 web edition? ...more >>

I'm embarrassed to even ask, but is there a consensus on how to pronounce SQL? Is it 'squell'? 'squeal'? or do most people spell it our S.Q.L.? Just curious. Thanks! ...more >>

Hi, I noticed from the logs that, my sql server 2000 Standard Ed (runs on a windows 2k Advanced server) is starting up the databases over and over again every second. This goes on and on without stopping, like a nested loop. each time it does it with a different SPID. When I check the SP...more >>

Hi everyone, I'm creating a web application to keep track of user skills. Each user can have 1 to 100 skills where they select by clicking on checkboxes. Also, is must be searchable? Can anyone recommend a good approach for this? Instead of creating 100 columns? Thank you Maz. ...more >>

Greetings. I noticed that if I go into enterprise manager and and alter the length of a column (make it longer), it warns me about related modifications that will occur and asks if they are OK. They are fine.. but is there a way via a script file to automatically get whatever related change...more >>

I have a column in a table that has many numbers then a hyphen and then many more numbers. I would like to remove all values, including the hyphen, from the hyphen to the left. Examples: today: 223-999 desire: 999 today: 2321-0092112 desire: 0092112 Can anyone help? Thanks, Doug ...more >>

Hi, Does anyone know if it possible to use client authentication when using a SSL connection, with the Net Library, to the database? I have not been able to find any information about this. /Johan...more >>

I'm trying to do something like this: select field1, field2, field3 = exec spTest parameter1 from table 1 but of course this doesn't work, I need field3 to equal the result from a stored procedure or function, can this be done? ...more >>

I'm trying to add a full text index using the wizard however I receive the following error; "The name 'mydatabase' was not found in the Databases collection. If the name is a qualified name, use[] to seperate various parts of the name, and try again." The problem I am having is that the a...more >>

I am not able to start the MSSQL Server service on my system ever since I shifted my house and got a new network provider. Earlier, I was on the local cable hub, now my computer is on a DSL network. I don't know if the network would have something to do with it, but I am just providing informati...more >>

Hi, I have a table with following structure ID int identity SomeData varchar(30) I want to write queries which can run parallel take 10% of the data Suppose there are 99 records in the table so first query will processess on records 1-10, second 11-20 and so an and so forth an last que...more >>

I didn't think this would be a problem, but my UNION view is not concatenating the two recordsets I'm asking it to ... it only returns one OR THE OTHER. My statement reads like: SELECT x, y, z, FROM MyView UNION SELECT x, y, z, FROM MyTable Is there a problem with this syntax? The funny ...more >>

is it possible via some system table query to see if the instance of ms sql server 2000 is case sensitive? Thanks Jeff...more >>

I've tried installing both SP4 for SQL Server and for Analysis Services and both the installers hang. After uncompressing the downloaded files...when execute setup.bat and setup.exe (respectively for SS and AS), I never get any GUI displyaed for the install. The hour glass shows for a few seco...more >>

Ok, I have a bit of an issue at a job I just started and it's been a while since I've used SQL to this degree. We have about 40 Million records that are sitting in SQL Server for an outside firm. Each row contains what should be 50 records of 5 columns. I need to take the extra columns and conve...more >>

Dear friends, I wonder if exist a way to make crosstab queries in SQL Server like those in Access without "external" programming. Does the SQL Server supports the "TRANSFORM" SQL-extension? Thanks in advance, Sotiris. ...more >>

Hi. I realize that ms sql doesn't really have sequences like Oracle and some other db's. I was wondering, given sql server 2000, and the restrictions placed upon writing user defined functions, is it possible even to do this: I'd like to write a function that I can call from the db layer ...more >>

I have a table with columns c1, c2, c3, c4 I want to determine the status of the data assigned. i.e. if none of the columns are assigned any data, the status will be 0, if c1 is assigned then status is 1, if c2 is assigned then status is 2, ... SO, I am trying to do some like: SELECT Stat...more >>

I was wondering. Does the new SQL Server have a completely in memory (either transactional, or non transactional) ability to apply indexes, updates, deletes, inserts and selects against ADO.net datatables? Rad development need never be the same again. ...more >>

I have a table that has fields called InvoiceID, FundingSourceID, InvoiceDate. I'm trying to write a query that would return all duplicate InvoiceIDs within the table for each group of FundingSourceIDs after InvoiceDate 06/30/2004. Is there a simple way to do this? I'm using the COUNT fun...more >>