Hello, I have a query where I'm trying to count the amount of posts each user has made for a blog. The first table (user) has the username and user_ID, the second table (posts) has the user_ID, post_status (publish, draft, etc.). I want to create a query so I can show each username, userID, a...more >>

table 1 ============================= id | ip | file ------------------------ 1 | 127.0.0.1 | testfile.jpg table 2 ====================================== ip | country ------------------------------- 127.0.0.1 | us 1.2.3.4 | de query =============================== Select C...more >>

Dear all, I am new to SQL statements, Now I want to join 3 tables: Table A ,Table B, Table C, I want to join A and B First and then use the result of joining of A and B to join C. Can I write the following SQL statement. Select * from (A join B on A.fieldA = B.fieldA) join ...more >>

Hello Everyone, We have a project which requires (one-way) synchronization between two databases across the Internet. We need to maintain a relatively up-to- date database < 5 mins difference? We will be synchronizing a couple tables from the customer's database over to our company's data...more >>

Without writing an application, is there a way to continuously call a SQL 7 stored procedure every 0.5 seconds or so? Is it OK to configure a SQL job that starts once and simply runs some SQL that sits in an infinite loop as my example below or will this cause problems for SQL Server? E.g. C...more >>

I am trying to build a query that will tell me the date a customer crosses a predetermined threshold. I have an invoice table that carries the invoice date and the amount invoiced among other things. We would like to reward customers that do x amount of business with us. How can I query a the in...more >>

Hi, Would like to know the performance differenece between Multi-column Index vs Single Column Indexes. Let's say I have a table with col1, col2, col3 along with a primary key column and non-indexed columns. In queries, I will use col1, col2, and col3 together and some times just one or two ...more >>

Hi, I am trying to solve this problem in SQL 2000 and any help is appreciated. Imagine there are big containers each with various items in similar quantities. tbl_containers -------------------- container_id int item_type char(1) qty int We can, for example, have 10 of A, 20 of B, 40...more >>

I have two tables TEST1and TEST2 that have 2 cols (clmA,clmB in TEST1 and clmC,clmD in TEST2) I have this data in TEST1 (TEST1) is on a remote linked server called server1 A , 1 B , 2 C , 3 I want to copy this data to TEST2 only if TEST2 does not already contain on of these entries. S...more >>

Hi, I'ld like to have returned only records where a field contains uppercase characters, example select * from customers where company like '%FIAT%'. Is this possibile with standard transact SQL for SQL2000 and SQL2005? best regards Toni Santa ...more >>

I am backing up to a tape drive to backup 3 databases. All appears works well except that each backup appends to the tape rather than overwites it. I setup the backup plan with the wizard a couple of times, but I do not see any option that says overwite tape. I thought I would just adjust ...more >>

Hi, I've got a problem in that a stored procedure of mine always times out within my application. Realistically there's no need to increase the timeout because the individual sections of the SQL execute fast, yet when I bring them together the execution time increases dramatically. Firstly...more >>

I am in one heck of a bind. I need to know how I would write a script in SQL Mangt Studio for the following: I have two fields I need added into my linked table. BestEfforts is a check box UserField is a standard text box that should be varchr255 How would I write this or where do I begi...more >>

Hello, I need to create a stored procedure in SQL Server Express 2005, and I´m gettign errors. Can anyone tell me waths going wrong in this code? Tahnk you! USE [mydatabase] GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[mysp_sp_syncroaddserver] ( @a_da...more >>

Lets say I open a View in Enterprise Manager (or Management Studio), display the rows and then Update some data. It appears that EM or MS updates the base tables directly, updates rows in the base table, thus ignoring any "instead of" triggers on the view. Is that correct? Is there any offi...more >>

can we export/attach data/database from SQL Server 2005 Enterprise editon into SQL Server 2005 cluster environment? thank you...more >>

Hi guys, I'm trying to work this query out in my head see if you can help me with it. I'll give you a little background information so you have the big picture. This is a real estate database, every home has an APN number it's a unique number that always means the same property. When a co...more >>

We are using service broker to keep 2 databases in sync via an activated stored procedure. This works fine, but it seems like allot of data is building up in the queue waiting to be processed by the stored proc. Is there a way to tell how long a message has been in a queue?...more >>

hey all, what do i have to do to secure my database so that only one person with login rights can access the database? For instance, System Administrators, Domain Administrators, etc. should not be able to view my database either? I basically want all modifications possible only thru a .net...more >>

I'm running a query to create a temp table: insert into order_tempfile select orders.orderid, orderdetail.productid, orderdetail.productname, orderdetail.quantity, orderdetail.unitcost, orders.totaltax from orders inner join orderdetail on orderdetail.orderid = orders.orderid where ord...more >>

Hi, I'm using the ip 2 location service (http://www.ip2location.com/) to find where a web site visitor is from. The table has more than 2 000 000 rows. The table is created like this: CREATE TABLE [dbo].tbl_IPS ( [ipFROM] [float] NOT NULL , [ipTO] [float] NOT NULL , [countr...more >>

I have installed windows vista, but when I want to create a database from our software I get this error: "REATE DATABASE permission denied in database 'master' ". I worked in a new windows vista we installed on our desktop, but did not work on a new laptop we purchased with Win Vista on it. ...more >>

Hello everyone I am trying to use a varchar(string) in my where in clause and it will not work why is it not working and how can I get to work. Here is some sample data, DDL, code I am trying to run and desired results. CREATE TABLE #UsersTable ( [UserName] [varchar] (50) COLLATE Latin...more >>

I posted this yesterday but never got a response, so I thought I'd try it again: If I want to do a one line test to see if an alert exists, it's as easy as if exists(select name, enabled from msdb.dbo.sysalerts where name like 'Access to database denied%' and enabled = 1) blah blah blah ...more >>

I process a text file daily with about 500,000 rows. The data are inserted into two different tables: Customer and Items. What I do now is read the customer header in the text file and inserts the record into the Customer table which generates and ID (identity column) or an Item table if the r...more >>

I have the following SQL statement select config.AssetConfigId,config.RemovedRemInsId, a.TEC, a.SerialNumber, a.Site ,t.title from AssetLCF a left join AssetConfig config on a.AssetKey=config.AssetKey and a.Site=config.AssetSite join AssetInspection ai on a.AssetKey = ai.AssetKey and a.Si...more >>

Hello Gurus, Strange behavior tracking failed logins. Environment: SQL Server 2K STD SP 4 build 2187 Windows 2K3 SP 1 SQL Server Audit Level: Failed Logins only Failed logins are be written to the SQL Server log as expected. However, successful logins are also being logged. Now here is...more >>

I'm working with an outside firm to develop an application for our database, and they've requested a database dump to use for design and testing. However, we're only giving them a portion of the database, so I don't want the back up file to contain everything. I've designed a number of view...more >>

Hi When I start up Visual Studio for SSIS package development and add a VB.Net Script task to the package the messages below show up and The script can't be compiled. This happens before I add any text to the script. The dependency 'EnvDTE' could not be found The dependency 'Microsoft.SQ...more >>

I have a table similar to the following: CREATE TABLE [dbo].[Person]( [ID] [bigint] IDENTITY(4,1) NOT NULL, [LastName] [varchar](50) NOT NULL, [FirstName] [varchar](50) NOT NULL, [DOB] [smalldatetime] NULL, [SSN] [char](11) NULL, CONSTRAINT [PK_Person.Contact] PRIMARY KEY CLUSTERED ...more >>

I've been searching many placing for ideas on how to improve the speed of this problem: We have a system that samples various equipment every minute or so, and stores these measurements in a table in our database. Currently there are about 300 mio rows in this table. There are about 200 colum...more >>

Someone had posted a question few days back about SSMS Add-In. Here is the article that explains how to create an add-in for the object explorer. We used it to create our SQL SP Generator tool - http://www.etekglobalinc.com/Downloads/SQLServerDownloads/tabid/320/Default.aspx ...more >>

Hi, We have 30 jobs in SSIS that we now execute manually from Sql server 2005 BIDS. We want the user to be able to execute it using a browser. How do we do it? I searched online resources but none explained it clearly. Do we use .ASP or C#. Is it possible to use both? We do not have C# or VB...more >>

I have a table called Accthist. The table has values Acct,subaccount, Ptd00 to Ptd11 (12 coloums for the 12 months in the year. I want to update the value in PTD06 for acct 25010 by adding in it the value that is in acct 25150 where the subacct is the same. That is Update accthist set acct2...more >>

What is wrong with the following query please? dtexec /f d:\sysappl\CEM\SSIS\Imports\Trades\BaseProfiles2.dtsx /set \Package.Variables[User::FileName].Properties[Value];"d:\ApplData\CEM\WorkingTemp\profiles.csv" /set \Package.Variables[User::ConnectionPath].Properties[Value];"Data Source=...more >>

In the last update I am always getting 50. Is the standard has defination for this sort of update where we have multiple possibility or this behaviour is undefined? Use Tempdb Go create table #temp1 ( o int identity(1,1), SID int, tId int ) insert into #temp1 (sid) values(23) cr...more >>

I'm pretty much at my wits end with this server. Running Sql server 2000 sp3. 4 gigs of memory. The server is utilizing 6 disks. D: Logs (.ldf) F: Data (.mdf) G: Filegroupings of our two largest and most used tables H: Tempdb K: Tempdb L: Tempdb M: Tempdb We are experiencing slow di...more >>

Hello there I've worked hours on some of my database. Suddenly someone has just made restore in this database and erase all the data i inserted. Unfortunaly i don't have full recovery module. Is there a way to restore it somehow? ...more >>