hi, I have to send bulk data to the SQL server. I have an arraylist of the test object and for each test i am making a SQL connection. It is slowing down the process very much. Is there another way to do that. I have a transaction and for each test i can update, insert or delete depeding...more >>

Hi All, I am trying to script out a whole SQL SERVER database with all objects in it along with INSERT Statments to populate data into the table. My goal is to have one single file which I can just run and produce the same structure in a new system. I do not know if there is a way to do th...more >>

I have a database table with data like this (some fields ommited): reserveID owner creator ----------- ------- -------- 39009 1 0 39009 0 1 39100 0 1 I would like to do a query that would return all rows in which a reser...more >>

Hi, In my table I have a datetime field (called modtime), and I need to build a select statement that groups by half-hour increments, so that it looks something like: modtime SUM(sales) 7:00 - 7:30 9999.99 7:30 - 8:00 9999.99 8:00 - 8:30 9999.99 et...more >>

I am trying to find any record in a table or database where record is empty without specifying column/field name or even table name. What would be the query statement? For example something like; SELECT * FROM table1 WHERE ???? = '' SELECT * FROM database1 WHERE ???? = '' What I...more >>

Just wondering what techniques are generally available or employed when different client application instances must be notified when data changes in a database. For example, assume a basic client/server Windows Forms application that uses SQL Server (2000 or 2005) on the back end. Client1 up...more >>

Hello. I see that we're not permitted to reseed a incremental column to a value that's lower than the highest value in the table. I guess that's in there for our protection but is there any way around this? On an integer column I manually set row to a value of 2 billion and had planned to rese...more >>

I'm having a problem creating a materialized view. Here's the view definition: Create View audit_Report WITH SCHEMABINDING AS select a.audit_id, a.status_id, a.audit_date, a.reference_name... from dbo.audits a join dbo.references r on a.reference_id=r.reference_id The view is created ...more >>

We have a commercial VB6 app that uses Access. We want to start using SQLServer, and I see that Express is 'a free, redistributable version of SQL Server 2005' (quote from MS) that we could use as an imbedded database. However, if we change the app, we will have to provide a conversion path ...more >>

Hi All I need some help. I have a table. It has 2 columns, ColA and ColDate. e.g ColA ColDate 1 01/1//05 1 02/12/05 2 01/23/05 2 03/2/06 3 014/01/05 I want to write a query that gives me the most recent ColA with its date. I can have duplicate...more >>

INSERT INTO table1 ....... (I added a record into a table). I have an identity field (RecID). I am now recording add transactions in a database. I want to capture the RecID I just added into another table INSERT TO table2 (NewRecID) VALUES ( (S...more >>

I have a stored proc that accepts several parameter, one being relocation_id. If it is passed in I want to add it to the Where clase AND rd.relocateID = @relocation_id Ive been trying to avoid dynamic sql and thought I could do something with COALESCE but I cant seem to get same results f...more >>

I have two tables with identical structures (for example): items_1 id int identity item_no nvarchar 11 description nvarchar 255 items_2 id int identity item_no nvarchar 11 description nvarchar 255 Users can add, delete and change data in items_1 at wi...more >>

Hello If I use Where datefld = '1/24/06' my query returns 1 record containing that date. But if I use datefld Between '1/24/06' and '1/27/06' it returns 6 records of which 3 are from '1/24/06'. Why do I not get the 3 records when datefld = '1/24/06'? Here are my queries are resultsets...more >>

I want to be able to set-up a job that runs every month on, let's say, the 15th. Now, that job will always look to the following month and pull every transaction of a certain type that falls within that month. So, given that the table I ma pulling from has dates attached to each record, is the...more >>

I am trying to fine tune some of my Queries and I noticed some TableScan with cost: 0%. Should I worry about these TableScan? Thanks, Culam...more >>

Can't figure out why I am getting a syntax error on this Incorrect syntax near '@RecordID' RecordID is an integer UPDATE CCI SET Insured = @Insured, State = @State, CCICode = @CCICode, Occupation = @Occupation, PolicyNumber = @PolicyNumber, PolicyEffective = @newPolicyEffective, P...more >>

I am not sure how to phrase this query...if i could have MAX in my where clause it would be: SELECT jj.id, jj.lastname, jj.firstname, jj.StartDt, jj.TotalDays, sum(jpm.NbrDaysPaidFor) AS DaysPaidFor, sum(jpm.Amount) AS TotalPaid FROM table1 jj inner join table2 jp on jj.id = jp.id inner ...more >>

Hi to All! Can any one help me in generating serial no in the query result? e.g. i write a query it gives me 500 rows. select name,fathername from abc name FatherName Harry David Sarah Nenry .. .. .. .. i want that reslut should come like that S-no ...more >>

I have a row that contains invalid information. I have created another row with the correct data. each row has a sequence number on it. The other two fields in each row contain binary data. how can I move the binary data from one row into the incorrect row and maintain the sequence number ...more >>

I have 1 record per day with a Daily Difference. I would like to also keep a running difference. So I am looking for a way to insert the value for RunningDiff RunningDiff = PreviousDay's RunningDiff - current day's DailyDiff date, $ShouldHave, $Have, DailyDiff, RunningDiff 1/23/2006, 12...more >>

Hello folks. I have a list of servers and for each server I need to loop through all the databases on that server and see if there is a table with the name XYZ (for example). I guess I would start out by going to the master database on the server. Which table do I need to open to find ...more >>

I am trying to create a loop that will go though all the databases and collect all the table names. Currently the loop goes around and around till it scans all the databases but only pull from the current database you are in. I am probably missing something that is obvious. DECLARE @ExecSQLcm...more >>

hello everyone, i have an artificial keying system that is based upon a psuedo-randomly changing 31 bit pattern stored in the database as an int. the current key is stored in a table like so: create table artificialkeys ( keyname varchar(50) primary key not null, keyvalue int) go i...more >>

I have 2 large tables that are over 11 million records each. I need to join them on 1 field and then update 4 fields. So my script is this update a set a.field1= b.field1, a.field2= b.field2, a.field3 = b.field3, a.field4 = bfield4 from a inner join b on a.field5= b.field5 This...more >>

alter PROCEDURE upGetWarehouseItems @warehouse_name varchar(50), @criteria_name varchar(50), @status_name varchar(50), @customer_id varchar(50), @warehouse_rpt varchar(20), @track_num varchar(50), @weight varchar(50), @description ...more >>

Is there a way in Service broker to change the priority of a conversation (or group) within a queue? thanks bv ...more >>

I am writing an SMO console application (in C#) to script out a database. I am spitting out a seperate file for each type of object. First and foremost, I am NOT a C# Programmer, secondly, I cannot figure out how to script out indexes without it including the primary keys. Below is a code s...more >>

Question that I hope someone can direct me. I do alter table command to (mostly) add columns to an existing table, but sometimes to change the size of an existing column (such as char(30) changing to char(50)). I remember reading that changing the sze will actually leave the 30 character ar...more >>

Hi, I'm trying to create a linked server of DB2. I've tried using the providers "IBM OLE DB Provider for DB2" and "Microsoft OLE DB Provider for ODBC Drivers" but I just don't know what to put in the fileds to create a valid connection. Can someone give me an example that would work for me....more >>

Hello, I would like to monitor the changes in current SQL Server Database Objets like Tables, Stored Procedures, views and Triggers. I would like to store the information in one table and would like to get the report. How can i do this? ...more >>

friends, I have the following table with atleast 4,00,000+ records & i want to update some of its fields with the below logic. STOCKEXCDOWNLOAD I've ran the below query in query analyzer with no indexes on this table. the time taken is about 40 secs. UPDATE StockExcDownload SET CalC...more >>

Hi, I need to insert into a set of joined tables. I'm using a select statement as the target 'table' into which it will insert into: INSERT into dummy as ( SELECT e.name, e.email, d.dept_name, l.location_name FROM Departments d INNER JOIN Emplo...more >>

Hi All, i have a problem while using the Cursors, actually i have main cursor, let say "ParentCur" and i'm definding the another cursor in the Parent Cursor say "childCursor" in the child cursor i'm checking for some validations, if 'a'='b' raiserror ('Both Are Not Of Same Type',16,1...more >>

We regularily use functions to return indexed table variables (for a range of dates, products and stores built for the parameters passed in). These are then used to join to tables to return sales information etc. Occassionly, we need to recompile the stored procedures using sp_recompile, but ...more >>

Hi How can I attach mdf file without copying it to local disk. I dont have enough space on the server which I have to attach db. But there is enough space on an other server in the network. Thanks Banu...more >>

Hello, I am making a database migration from Sybase SQL Anywhere to SQL server 2005. Under sybase I had functions I use in VB6 applications, and in VB6 I call these functions directly by their names ie: select fGetText(1) but with SQL server I have to specify the schema before the function n...more >>

I have two stored procedures which return results in the same column format. I would like to have a third stored procedure which will union the results of the two stored procedures, eliminate duplicates (distinct) and put the results in order by userid. pseudocode: CREATE PROCEDURE [sp_unio...more >>

I want to change the alias of the fields below to the current month and the month +1 ie datename(month, getdate()) and datename(month, dateadd(mm,1,getdate())), so instead of '1' and '2' I have January and February Select case when p1.ExpectedDeliveryDate >= @Start and p1.ExpectedDelive...more >>

Hi We have some datetime fields that hold poor data that we want to clean up on the fly (a poor third party system requires it like this). e.g. the field holds just the time: "18:18:23" which is converted to a date time (with the time as the date) when we select it. We have developed code...more >>

I find that the following commands successfully decrease the size of the log file: - Backup Log MyDB With Truncate_Only - DBCC SHRINKDATABASE (MyDB) However the following commands (exec one after one) can't decrease the size of the log file: - DBCC SHRINKDATABASE (MyDb, TruncateOnly) - DBCC...more >>