Convert text to smalldate. I have a text field which is formatted as yyyymmdd and I'd like to convert it to a smalldate. For example, I need 20070116 to become a smalldate field which would display 01/16/2007 How do I do this? Then I want to add some days to a smalldate field For ...more >>

Hello All, I am planning to redistribute an application, which uses SQL server express. I have registered for redistribution rights at http://www.microsoft.com/sql/editions/express/redistregister.mspx It looks like, it should be enough, but I just wanted to be sure that I am not going t...more >>

I am trying to join these two select statements into a single result that would look like the following: Ticket Number, Issue, Email meeting this criteria from table "job_ticket" WHERE job_ticket.location_id = '5' and status_type_id like '[1-2]' Both select statements work fine by thems...more >>

Hello, the sql server service manager icon disappeared from the taskbar notification area. how de we get it back? It's sometimes hard to determine the state to of server when you don't see it. thanks timber ...more >>

Hello, Previously, I had the SQL Server Service Manager icon appearing in the notification area of the taskbar. But I seem to have lost it. How do I put it back? Sometimes its hard to know the status of the service - whether it is started or stopped thanks for the help! ...more >>

Hello folks, Is there an option in SQL Server to set all data case sensitive, but database/table/column name case-insensitive? I know it's possible to set column collation to a case-sensitive one when creating individual table. I'm looking for a system wide setting so that I need not specify ...more >>

Hi, How to write a one minute timer delay using SQL? TIA Ana -------------------------------------------------------------------------------- Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados. Ha eliminado 2103 correos spam hasta la fecha. Los abonados no tienen est...more >>

Hello, I was doing some research on the kind of churn SQL databases typically go through. Can anyone here please point me to a whitepaper/study etc that describes what would constitute high/medium/low churn for SQL DBs? (Say in terms of daily tlog backup size, OR MB of data that churned per d...more >>

Hi, I want to make a maintenance plan to remove old .bak and .trn files. (SQL 2005 on W2K3 R2 std edition) I have lots of databases which are all backing up into separate folders. The Maintenance Cleanup Task is not very versatile! It seems I have to set up a separate task for each folder ...more >>

I've searched the posts and found some useful code on updating one table with data from another however, when I created the following SQL statement, I get an error 'ADO error: The column prefix 'TAinvxSUBstatusNEW' does not match with a table name or alias name used in the query' Both tables...more >>

How can I install the Sample Database if I have already run the installation. New user, tried doing this today just re-installing, but no luck. I did make a new instance -- hopefully I didnt screw it all up. Any help is appreciated. Thanks!...more >>

I am having a heck of a time figuring out a good direction. I would consider myself a decent Database professional. Used Access and another MRP system for the past years and have done lots of development. I want to replace them both with SQL. I dont know where to really begin with training. We...more >>

Hi, I have thousands of xml files that an application is producing on a daily basis. Is there a way I can use SQL 2005 to access the contents of these files for reporting or data searching? Thanks S ...more >>

I want to run a Case statement. If the Exec Code is 1840, 1850 or 1880 then use that Exec Code. Otherwise, if the the Exec_Code is between 900 and 2000, use 1900 as the value. If none or the above, use 1800. How do I use < or > in the Case/When statement? Thanks Vayse SELECT LedgerKe...more >>

I am trying to run a t-sql script against a database named 'voInit2.2' Query analyzer keeps puking; erroring out that the db does not exist. Hopefully there is a working around for this? Thanks, H ...more >>

I need to create the equivalent to an Access crosstab query in SQL. Can someone help me with this? I'm new to SQL and need this report within the hour, unfortunately. The data table has four columns: Code, Value, Month, Year. There are 12 records per Code representing each month of the y...more >>

Hi, I like to transfer image records from a table into another table with similar structure in a procedure. Table1: date, photo_id, photo, tx_flag Table 2: date, photo_id, photo How to write a procedure call to transfer table1's records to table2? Thanks, Luke ...more >>

Hi I have a select statement, which works fine. SELECT dbo.ZZZ_MONTHLY_Pre.ISNewBusiness FROM dbo.ZZZ_MONTHLY_Pre INNER JOIN dbo.AAA_MONTHLY_Clients ON dbo.ZZZ_MONTHLY_Pre.Ref = dbo.AAA_MONTHLY_Clients.Ref Now I wish to an update, UPDATE dbo.ZZZ_MONTHLY_Pre INNER JOIN dbo.AAA_MONTHLY_Cli...more >>

Recently I have had the good fortune to come into contact with several server all using SQL, and I know >.< much about it so I have a few questions if you will all forgive my ignorance. SQL Version 8(2000?) on SBS 2003 Premium was installed onto a SBS 2003 server. NTbackup had been backing ...more >>

Hello I have vista and I upgraded MSDE to Express and now SQL Studio won't let me connect to MMSSD with windows authentication. What are my options? Thank You ...more >>

Hello NG, How can I _completly_ remove/unisntall the SQLServer 2005 Express ADV SP2 from Windows Vista? (Fetched from http://www.microsoft.com/sql/ctp.mspx#EJB) I tried to complete uninstall SQLServer 2005 Express Ed. ADV SP2 from iVsta (Business) But now I can't install the SQLServer agai...more >>

Hi This is something I've often wondered about. In this case, I've been given a SQL Server database that has details about a client survey. That is, an agent goes to a client site and writes a review of that clients business. So there is a clients table, linking to a survey table. There can b...more >>

Hi all Perhaps someone can point me in the right direction ? Here is the problem:- We has a SQL Server which we store our FAQ Db. We have just connected it to our website to display the information and we have provided a search facility for users to search the text from both questions and an...more >>

Hi, does anyone know if there is a possibility to buy an upgrade to SQL 2005 from SQL 2000? We could only find full versions for sale and no upgrades. Thanks Patrick www.patrickwolf.net please reply to group or to ppwolf ..#.... bigfoot ...%..com ...more >>

SQL 2000 I have a DTS package that runs fine, but when I schedule it the job fails. What do I need to check? Thanks. ...more >>

Hi, I have a sproc which returns a row from my table. The table has a field which is to contain the date when the row was last accessed ( ie. read) by the sproc. Can my sproc return fields from the row, while causing an update to the row's timestamp field, during the same hit on the db ...more >>

Hello, I am trying to query out of the same feild for separate results. The query looks like this: select trunk, start as StartCall from table1 where status like '%dialing%' That works, however; I also want to get this statment into the same results. select start as endcall from table1 ...more >>

All: I have a Pentium 4 2.2 GHz laptop with 512 MB of RAM. I installed SQL Server 2005 Express Advanced Edition on it last night and it said that my hardware wasn't optimal for the installation. After looking at upgrades this morning, I have decided to max out the RAM to 2048 MB to see ...more >>

I have a Purchase Order Items table. Items are considered "Open" if the Bill of Lading date is not older than 60 days from today. At that point they are no longer seen on the Open orders lookup form. Sometimes a partial shipment happens and I flag all the items on the order that they are par...more >>

I have an sql statement, as soon as I add the part : ---- h.FirstNm + ' ' + h.LastNm as spousename, h.POBCountry as spousecob ---- It gives me the following error: --- Server: Msg 156, Level 15, State 1, Line 16 Incorrect syntax near the keyword 'as'. --- The full query is: ---...more >>

Hi I can connect to one remote sql server using sql authentication but not the other. The error I get is; An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL S...more >>

I would like to obtain the object's id with codes in the same object. For example, there is a piece of code in prDemo to get prDemo's object id. I would like to code could be moved to other procedures or functions without any modification. So this code should be able to recognize its host pr...more >>

I'm having a little trouble with a Bulk Insert. This is my first time working with this, so I'm not sure what I'm missing here. I've read everything I can find about Bulk Insert in BOL and from querying the archive, but I'm not finding the answer. This is the error I'm getting when attempti...more >>

Hello, I have a couple of tables in a SQL Server 2005 database back end and I want to delete some records through a query from a MS Access 2003 front end. I get an error in MS Access saying "Could not delete from specified tables". There are multiple users of the back end and each one lo...more >>

I have two sql servers - mssql2000 & mssql2005- question.. how do I copy sql2000 database to sql2005? they are both in the same subnet. also, how do I copy whole database from sql2000 to append into a sql2005 data file with same tables, structure, etc? thanks, raul Rego ...more >>

Hi I want to delete from 2 tables. Can I do this in the one stored procedure? I've tried: CREATE PROCEDURE MONTHLY_Pre_Delete @EnterUserName as varchar(50) AS Delete From ZZZ_Monthly_Pre WHERE UserName = @EnterUserName; Delete From ZZZ_Monthly WHERE UserName = @EnterUserName GO But ...more >>

A client of mine has recently acquired SQL2005 on one server. They also have about 5 other servers running SQL2000 Licencing for the server and for client access is very clear but I can't seem to find a clear definition of the way the licensing for the client tools, i.e. SQL Server Management...more >>

Hi There is a ClientAge field in months. In my query, I'd like to return 'N' for New if the ClientAge is 12 or less. If over 12, I'd like to display 'E' for Existing. How do I do this? I've tried using the IIf statement, IIF(Client_Type<13, 'N', 'E') but that doesn't work. What should I use...more >>

I'm trying to query rows from a column that is ntext. I want to remove all those rows that are blank. These blank rows are just blank, not 'null'. I can't use DISTINCT on a text or ntext column, as I found out. I tried something like this: select computers_comments from survey06 WHERE c...more >>

Hello, I need some explanation with limits of SQL Server 2005 Express Edition (which is free of charge) I've read comparison table from here http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx and I cannot see there any information about limits in concurent connections...more >>