Hi, I have the following SQL statement which adds 7 days to today. Update Table SET VALUE=DATEADD(dd, 7, GETDATE()) WHERE Definition='' AND Attribute='' However, the date becomes May 6, 2005 4:24 PM from 6/06/2006. How do I apply convert or cast to get the format as 6/06/2006? Thank y...more >>

I am preparing to build an app that will pull data from multiple databases on the same sql server. For performance sake, is there a more "effecient" way to grab data from multiple databases at once? I've read a couple of threads and noone really seemed to give a straight forward answer. I woul...more >>

Hi guys, I have created a stored procedure and need to run it once a day automatically. Does anyone know how I would do this using Microsoft Server Enterprise Manager or any other quick way? Thank you Maz ...more >>

Can you assign 2 virtual IP's to a SQL cluster ??? 1 valid on 1 LAN and another on another LAN ??? i.e. 1 public and 1 private. ...more >>

Greetings, I need to bounce off some ideas about database design and normalisation - Say a product can have several attributes, such as colour, smell, etc. So an example of a product is "Roses" and its attributes are "red"(for colour) and "sweet" (for smell). I have a table called Attrib...more >>

Hi, I have two tables: Table T1: Id_T1: Primary key Data1_T1 Data2_T1 Id_T2: secondary key, allow null Table T2: Id_T2:primary key Data1_T2 I would like to create a query which returns all data for given Id_T1. Something like this: Select T1.*, T2.* >From T1 Inner Join T2 On T1.Id...more >>

A recently inherited can of worms has me in a quandary. I am reluctant to backup the database, uninstall it, and then reinstall just put the database into a known condition. Any guidance will go a long way: 1 - How can I determine which (if any) Service Releases my predecessor applied? ...more >>

Moving to SQL from access in access I used the as command to join two fields, how do I do it in SQL. I get an error. For example: SELECT [Employees]![Last] & ", " & [Employees]![First] AS Participant Whats the proper syntax for this in SQL? Thanks ...more >>

Hello, I am generating some scripts for my database... When I script tables it always adds "ON [DATA]" which when executing in query analyzer gives error Invalid filegroup 'DATA' specified. I can do a replace of DATA to PRIMARY but how can I generate a script so it works. Thanks, y...more >>

We recently renamed the local administrator account on our server from administrator to boaadmin. And now we need to change dbo owner for a database becauase the dbase is still using the name administrator for the dbo. I ran the process : sp_changedbowner boaadmin but it gives the follow...more >>

Hi, I have three tables T1,T2,T3 with reletions between them. I want to fill a row as follows: 1. fill T1 2. fill T2 3. fill T3 If any of the operations fail - all fail. Tables have 6,8 and 12 attributes. How could I realize the transaction (or anything else if there is)? Do I create a...more >>

Brothers and Sisters... Well, for a long time I have wondered how come SQL Server does not have an unsigned int data type. Most of the int columns I have designed, are unsigned and would probably fit in a smallint datatype saving on space in the DB. However, since smallint only gives me a set ...more >>

Hi: I am pumping data from a Sybase database into SQL Server that will be run daily. I am trying to set a composite Primary Key on the destination table. In this table, it is made unique by a combination of these Three fields: AgentDateTime AgentLogin SupervisorLogin For example, if du...more >>

Greetings, I need a way to measure the volume of data transferred back and forth between my application and SQL Server (2000). I haven't been able to find a tool that does this - Profiler shows everything else, but doesn't show the volume of data sent or returned. Is there any tool out th...more >>

I am a retailer whose software back-end has just been upgraded from Access to SQL Server 2000. (The front-end is an independently-written shop Point Of Sale system) While I know a fair bit about computers, I know nothing about SQL Server. And frankly, I don't want to know much. I don't need to...more >>

Does anyone have a code example of how to create a CRC Function to xompute a Reporducable Key? Thanks Tom ...more >>

If anyone knows sql commands, I need your assistance. Table1 is from dbase iv and Table2 is a sql table that does not exist yet. I need to put all of what is in Table1 into the "new" sql Table2. I've tried DTS and just can't get it right because the new sql tables values are different than th...more >>

Hey there - got an issue. I use a document imaging software that uses SQL for the backend. Loaded great, put it on everyone's machines - but 2 machines for some reason cannot "see" the SQL server. If you run thru ODBC setup, every other machine will see the server - but these 2 cannot connect...more >>

Hi! I was wondering if it could be possibile to work with data in this way: suppose we have sales data (productid, customerid, saledate), I would like to calculate how much time elapses between two sales to the same customer (in order to obtain variance, standard deviation, and so on...). I'v...more >>

Hi, I was just about to post a question on whether there is an elegant way to find the modal - highest occuring - value in a set of data (say the most ordered product ). I'd thought this was a natural aggregate function and wondered why MS, and indeed the standard SQL-92 syntax, did not inclu...more >>

Greetings All, I have an operation that involves the use of a cursor. This cursor is looping over a table that has about 20,000 rows. If I run this operation when SQL server is just started and total virtual memory used by SQL is low the operation takes about 3 minutes. If I wait and do some o...more >>

Hi. I'm a newbie at SQL Server I thoroughly know MySQL, but I am having a hard time getting started with SQL Server. Basically, I'm trying to set up a simple, local PHP site which has a SQL Server backend. Is there a quick and dirty (and cheap) way of doing this? Also, are there any reso...more >>

I am currently working on converting a VB ASP web appliction to work with SQL Server. It was previously using Oracle 9i. Most of this has gone without major incident, however a small (but signifacant) part of the application uses a tree structure. Oracle has some advanced capabilites for dea...more >>

Years ago I upgraded from SQL 7 to SQL 2000 and ever since the transaction logs on my database backup jobs have been huge. I had enough disk space, but it is now getting close to being a problem. I believe that I am still using the same upgraded Database Maintenance Plan that I made under SQL...more >>

I've been running into more and more complexity with an application, because as time goes on - we need more and more high-level, rolled-up information. And so I've created views, and views that use other views.. and the queries are getting slower and slower. This morning, I'm working on som...more >>

Given the following table setup Table column1 column2 forumCategory ID name forum ID name forumCategoryID ForumTopics ID forumID ForumTopicMsg ID topicID dateEntered I am attempting to create a query that gives a complete ...more >>

Hi: I am fairly familiar with SQL Server and DTS but not programming code-I am doing research for a programmer. I imagine what we want to do is fairly common so if if there are any articles out there you know of that would be helpful: 1. We need some idea as to how to do the following throu...more >>