Database Newsgroups: SQL Server database programming

on similar tables

neilmcguigan - 5 May 2006 10:35 PM - 4 messages

hi all, so i have these tables: Company Job Resume user searches for a company, views that company. there is a list of "viewed" companies for that user. Users can attach/delete a (private to themselves) note about that company. ...

Handle Error

Jorge Aguilar - 5 May 2006 9:22 PM - 2 messages

Hi everybody, i do insert into client select * from client client table has pk when execute the query the follow error appear Servidor: mensaje 2627, nivel 14, estado 1, línea 2 Infracción de la restricción PRIMARY KEY 'PK__EMPLEADO__4924D839'. No se ...

Stored procedure with return value

Sandy - 5 May 2006 8:30 PM - 4 messages

Hello - The following code only returns 0. What am I doing wrong? I want a '1' returned to VB 6 if the row is inserted and if it not, because a duplicate record exists, I want a '0' returned to VB. ...

Cascade Delete

Derek Hart - 5 May 2006 6:28 PM - 8 messages

Is there a way to turn off cascade delete temporarily? Yes, I want to leave orphan records in this instance. I tried the following: ALTER TABLE tForm NOCHECK CONSTRAINT Delete From tform ...

Update Cursor with Sort

rmcompute - 5 May 2006 5:32 PM - 11 messages

I am in a situation where I need to use an update cursor but also have the file sorted. The program won't run indicating that it is a read only cursor. Is there a way to get arround this ? ...

How to get row size

moondaddy - 5 May 2006 6:10 AM - 4 messages

using sql 2k, what's the fastest and easiest way to get the row size of a row. I hava a number of rows I need to look at. Thanks. ...

Charindex to not include the delimeter question

needin4mation - 5 May 2006 2:23 AM - 3 messages

Hi, I have this: select left (mycategory, CHARINDEX( ':', mycategory) - 1) as Cat from allCats If I have a column that has no ':' colon in it I get an error about invalid string. As long as there actually is a delimeter then all is ...

how to join two SELECT result and multiple one column?

guoqi zheng - 5 May 2006 1:39 AM - 1 message

I have two SELECT query, say that both return results of column A, B, C. I would like to union the search results. However I would like to merge them and multiple C column. Supposed that I have two results of ...

Same DB, same SP, differente results !

Junior - 5 May 2006 12:26 AM - 1 message

Hi guys. I've got this weird behaviour in a SQL Server 2000 simple SP (see below). The very same SP in the same database brings records normally when I'm debugging a .NET app with DAAB 3.0 in my notebook, but as soon as I run ...

Client Network Utility in 2005

scott - 5 May 2006 12:14 AM - 1 message

Where can I find the "Client Network Utility" in SQL 2005? ...

Insert Statement

Derek Hart - 4 May 2006 11:36 PM - 3 messages

I have an insert statement with 2 tables, such as: Insert tForm Select * From tForm2 I know that tForm has all the fields in tForm2, but tForm2 may have some additional fields not in tForm. The insert statement will not work because ...

CLR Defined Types

Sean - 4 May 2006 11:36 PM - 2 messages

All read up and ready to create a database project only to find we dont have "database" as an option for a project type. Any clues why? we have SQL 2005 running as well as running SQL reporting services. Thanks ...

Distinct on only one column, return all columns

randy1200 - 4 May 2006 11:08 PM - 2 messages

I have a table with many columns. I want to return all columns, and I want only the first record for each distinct value in the salutation column. I come up with the following: select c1.* from complainer as c1 ...

Eliminate duplicates from only one column

randy1200 - 4 May 2006 11:00 PM - 2 messages

...

Files corrupt when retrieving BLOB data

Paul Pleasant - 4 May 2006 9:57 PM - 2 messages

I am attempting (for the last several days) to save binary files to a SQL Server 2005 database and then retrieve the files later. Have tried the new varbinary(max) and image data types and several different techniques with no ...

strange occurances when add '1' to character string

rengeek33 - 4 May 2006 9:34 PM - 1 message

I have a stored procedure that takes a text field and breaks it into 80 character chunks and stores it in a table for reporting as individual records. (client requirement). All was going well, into we noticed that the CR/LF were not working ...

Error 3260, could not update

Saga - 4 May 2006 9:27 PM - 1 message

Hi all, I have a VB6 (SP5) application that I developed that is generating the following error: Error 3260, Could not update; currently locked by user 'ADMIN' on machine 'Win2003SRV' More info... I am using DAO on an Access mdb that resides on the above ...

optimized name-address-zipcode-region design

hazz - 4 May 2006 8:23 PM - 3 messages

Whether thin-client with round-trip cycles to the db or a rich-client loading look-up data into memory on application startup, what is a solid optimized database design for customer location search functionality. USPS zip data has about 75K records. ...

Getting Records not in both tables

Irvin McCoy - 4 May 2006 7:24 PM - 6 messages

I have 2 tables and I want to retrieve all record that are in table 1, but not in table 2. Here's my data. Table 1: EstEquipment Columns: EstEqpPK, EstimatePK, Description Table 2: CrewEquipment Columns: CrewEqpPK, EstEqpPK, quantity I need all records in EstEquipment with a certain EstimatePK that are not in ...

System.Data.Sql.SqlDataSourceEnumerator visible servers???

newscorrespondent - 4 May 2006 7:21 PM - 2 messages

System.Data.Sql.SqlDataSourceEnumerator is documented to return all visible SQL servers with several notes that it may not show all of them. Should this show all the servers that are shown in the SQL Server Manager connect dialog when I browse for servers? ...

Sql Code generation tools

helpful sql - 4 May 2006 7:07 PM - 12 messages

Hi all, Are there any good Sql code generation tools out there in the market? If not can you please give me tips or sample code for creating one? I need to automate code generation for data integration. Here is what I ...

SQL Server 2000 - Invalid character value for cast specification: using Power Builder 8

Steph - 4 May 2006 6:39 PM - 1 message

PB 8.0.4 build 10501 DECLARE MyProc PROCEDURE FOR Test_Proc Parent_Action = 1, Current_Action = 2, User_id = 50, Computer_Name = 'Steph', SearchText1 = '', SearchText2 = '', SearchInt = 0; I'm getting this error when I try to execute MyProc EXECUTE MyProc; I'm not using any fields related to date datatype in the SQL Server 2000 ...

Active Directory, Terminated Employees

Pancho - 4 May 2006 6:22 PM - 3 messages

Hello, we have scheduled a nightly refresh into an Employees table in a database, that receives data from Active Directory. AD is the "authority" of who is an active employee and frees us from manual maintenance of the Employees table in our DB. However, we want to store information on ...

Date & Time formatting to sort by date and time.

Mike - 4 May 2006 6:01 PM - 7 messages

Hi, I have a Startdate and StartTime in my table, I would like to combine to the 2 columns as one column so that it can be sorted as date. startDate - smalldatetime startTime - nvarchar ( I cannot change this) my current query: ...

SSIS DtsDataParameter

tronn - 4 May 2006 5:56 PM - 1 message

Since I could not find an SSIS managed newsgroup, posting this here. Using this example [link](SQL.90).aspx gives me: "A requested parameter does not exist in the package" Removign the parameter teh code works. A little help! ...

detecting Update Conflict

Tanweer - 4 May 2006 4:22 PM - 6 messages

When a user try to update the record I use timestamp field (upsize_ts) to figure out if data was modified by other user. However I found out @@DBTS may cause problem in Multi user senario and may not return correct Tiemstamp value as it is not the timestamp for the current ...

Returning long string in varchar using Coalesce()

Ashish - 4 May 2006 4:16 PM - 5 messages

Hi, I want to return a string of words separated by comma using coalesce() so that the client application can look for a specific word in this long string.Following is the script:- CREATE TABLE WordList ( WordId int IDENTITY, WordDesc varchar(100) ...

how to compare rows from oldtbl to curtbl using Like?

Rich - 4 May 2006 4:14 PM - 11 messages

oldtbl contains these CoNames 'abc' 'def' 'ghi' 'jkl' curtbl contains these CoNames 'abc inc' 'def inc' 'jkl inc' Note that curtbl does not contain 'ghi inc' I need to retrieve rows from oldtbl where CoName Like CoName in curtbl select CoName from oldTbl where CoName like '%' + curtbl.CoName + '%' ...

Using EXEC

Stephen K. Miyasato - 4 May 2006 4:08 PM - 5 messages

I'm a newbie still learning to use stored procedures. I have the following stored procedure @PatNo int, @Type int, @ABN int, -- abnormal values only 0 false 1, true. @Range int AS DECLARE @TempVS varchar(20), ...

Way to check logged in by week HELP!!!

KT - 4 May 2006 3:34 PM - 8 messages

In need of a way to check whether or not a person logged in every day within a week (week starts Monday through Sunday). Does anyone know of a good way to accomplish this? In the table below, User #2 did log in each day within the week. I would ...

Restrict certain characters in varchar column

hals_left - 4 May 2006 3:22 PM - 4 messages

Hi - Is it possible to restrict the domain of a varchar column to prevent certain chatracters being accepted. I want to prevent commas. Thanks ...

Cursor in stored procedure

Steph - 4 May 2006 3:15 PM - 2 messages

I'm trying to do something like that: CREATE PROCEDURE [dbo].[Test_Proc] (@SearchText1 nvarchar(10), @SearchText2 nvarchar(100), @SearchText3 nvarchar(100)) AS DECLARE @SQLString NVARCHAR(4000) DECLARE @SQLSelect NVARCHAR(3000) DECLARE @SQLWhere NVARCHAR(1000) SET @SQLSelect = 'SELECT dbo.View_Clients.Client_id, ...

Getting Most Recent Date for Many IDs

mgabig - 4 May 2006 3:06 PM - 15 messages

Hello, Like the subject says, I'm trying to get the most recend End Date for multiple customer IDs in a table. The table, Rate, has multiple customer IDs and each ID may have multiple data in the endDate column. ...

Table Joins on more than one field

adi - 4 May 2006 3:04 PM - 3 messages

Hello all, Can someone help me with this SQL? 1) EMPLOYEE table has columns 'employee_id' and 'emp_sid' and other columns 2) EMPLOYEE_BENEFITS table has a column called employee_entity, this column can be joined to either 'employee_id' OR 'emp_sid' but not both ...

Update Statement

marcmc - 4 May 2006 2:28 PM - 8 messages

If you run the followingDDL you will see my issue. CREATE TABLE FAt_bse_events_marc( dim_one_id int, dim_two_id int, ev_event_id int, ev_type_id tinyint, cur_trn_dt smalldatetime, f_ev_date smalldatetime, f_ev_count tinyint, f_ev_num1 float ...

charindex faster than like operator??

Omnibuzz - 4 May 2006 2:12 PM - 2 messages

Hi ppl, While I was working on the post "compare 2 strings" in my test db, I came across this. I ran these queries, the ones using the charindex and patindex were faster than the like operator. I ran it in different tables with different inputs. ...

hello

m00nm0nkey - 4 May 2006 2:09 PM - 8 messages

i've been alone with you inside my mind, and in my dreams i've improved performance a thousand times, i sometimes see you in the server room, Hello.... can you query your tables? I can see it in your transactions, ...

Extrapolate the size of filegroups by 12, 24 ,and 36 months.

Naana via SQLMonster.com - 4 May 2006 1:57 PM - 3 messages

Hi All, I have a large Database with two filegroups and I'm trying to extraplate the size of the filegroups for 12,24,and 36 months. I don't have historic data, but have current data as of Feb, Mar, & Apr. The days of these months are not ...

T-SQL help

Sam C - 4 May 2006 1:43 PM - 8 messages

Hi, Please help me with this T-SQL. I have mentioned my requirement towards the end. Thanks in advance! --DDL & DML use pubs go create table U_empl ( emp_id int identity(1,1) primary key, emp_name varchar(50) ) go create table U_tbl ...

UHG... Dates in SQL

SteveInBeloit - 4 May 2006 1:36 PM - 6 messages

Hello, I am having trouble searching on dates in SQL. I have a table that has a transaction date on it, type datetime. The user types in two dates, and the sql is supposed to return all transactions between those dates. So I say WHERE TranDate >= @FromDt AND ...

Problem using "AS" to add 2 numbers

friedman30 - 4 May 2006 1:18 PM - 4 messages

i need to add 2 results from a query to get this string: 2.2006 (that represents the number of the week, and the year) i have a table that holds these 2 columns ("week" , "year") as integers (i can't change it to string) ...

How to transfert Data from a cube to anogher

Florent CORNEILLE - 4 May 2006 1:12 PM - 1 message

Hello, I try to transfert datas between two cubes with C#. The source is a local cube (.cub), the destination is Analisys Services. I can read the Shema with this instruction : AdomdConnection MySource = new AdomdConnection (); MySource.ConnectionString = "Location=C:\\MyCube.cub;Provider=msolap"; ...

UPDATETEXT with Transactional Replication

Yan - 4 May 2006 1:06 PM - 3 messages

Hi, The bellow Update works fine but does not replicate and this is because it is treated as a single transaction regardless the fact that an explicit transaction is being opened inside the cursor. I need each UPDATETEXT statment to be a single transaction, any idea? ...

compare 2 strings

henk - 4 May 2006 12:27 PM - 7 messages

i have a Company table . one of the column is EmailAdres. now i want to compare a string(a emaiadres) agains this column. the problem is that the string is different every time. e.g. search Parameter2.: <testu***@yahoo.com> ...

Multipart Identifier???

Phill - 4 May 2006 12:02 PM - 7 messages

I am getting an error: Multi-part identifier Ad.IPCode could not be bound. What does that mean? This is my query: SELECT Ad.ObjectID, ObjectTypeCode FROM dbo.ClassifiedAd Ad, dbo.Objects O ...

@@servername returns NULL

Yan - 4 May 2006 11:53 AM - 5 messages

Hi, sql server 2000 sp3a select @@servername returns null but select * from sysservers shows the correct servername. This causes problems to set up replication. Any idea how to resolve apart of reinstalling? Thanks Yan ...

What's wrong in my Select Statment

Islamegy® - 4 May 2006 11:45 AM - 11 messages

I'm try to run this procedure to implement Custom paging so i pass 2 paramters @PageIndex, @PageSize so if i @PageSize = 5 and PageIndex =2 (0 based index) then i want to ignore first 10 Rows right?? I wrote the following select statment: ...

What's wrong in my Select Statment

Islamegy® - 4 May 2006 11:45 AM - 1 message

I'm try to run this procedure to implement Custom paging so i pass 2 paramters @PageIndex, @PageSize so if i @PageSize = 5 and PageIndex =2 (0 based index) then i want to ignore first 10 Rows right?? I wrote the following select statment: ...

What's wrong in my Select Statment

Islamegy® - 4 May 2006 11:45 AM - 4 messages

I'm try to run this procedure to implement Custom paging so i pass 2 paramters @PageIndex, @PageSize so if i @PageSize = 5 and PageIndex =2 (0 based index) then i want to ignore first 10 Rows right?? I wrote the following select statment: ...

Using a DB name as a variable

Simon - 4 May 2006 10:54 AM - 5 messages

I am scripting database views to allow us to easily build a new server. However I would like to be able to have a variable containing the DB name that allows me to script views that look at other databases. ...

How to write 'update' statement to update top "n" records using Sql server 2000?

ABC - 4 May 2006 10:44 AM - 10 messages

How to write 'update' statement to update top "n" records using Sql server 2000? "n" is unknown and inputted by user. ...

Using max function

Roy Goldhammer - 4 May 2006 9:59 AM - 4 messages

Hello there I have table1 with Fld1, fld2, fld3. Fld1 is Identity and the unique primary key clustered. Fld2 and fld3 are indexed and don't unique. I need to build fast query that returns from table1 all the records with ...

How to make the database execute query faster PLEASE HELP

Fairy239 - 4 May 2006 9:52 AM - 25 messages

i got a very big problem help i need my database to execute one query in less than a min but it executes for 8 mins is there any way i can shorten the period of time execution? this is the codei am excuting some of the tables have 1-3gb big in size ...

Small exists problem

Lasse Edsvik - 4 May 2006 9:40 AM - 2 messages

Hello I'm trying to get this to work, i dont get the exists/join thing to work at all.... CREATE TABLE #Threads ( MsgID int, RootMsgID int, Foo char(1) ) CREATE TABLE #Test ( MsgID int, UserID int ...

How to make the database execute query faster?

Fairy239 - 4 May 2006 9:34 AM - 2 messages

i got a very big problem help i need my database to execute one query in less than a min but it executes for 8 mins is there any way i can shorten the period of time execution? ...

Find in SPs option for SQL

Will - 4 May 2006 9:33 AM - 3 messages

Hi All, Just a quick question, is there any option to search in all stored procedures in a database for a particular string, without scripting out the whole lot? Thanks Will ...

Not able to open Query Analyser...

Shahul - 4 May 2006 8:58 AM - 5 messages

hi pals, Iam not able to open the Query Analyser in my machine. When I am clicking the QueryAnalyser, isqlw.exe is present in the Process Tab of TaskManager, but it is not running in the Machine. Any idea? ...

Database mirroring

Craig HB - 4 May 2006 8:28 AM - 3 messages

I have a database that I want to split up so that I separate the transactional side from the reporting side. It seems that database mirroring (or something similiar) is what I should do. So I'll a have Transaction database that mirrors with a Reporting database. ...

Loading DLL in SQL 2005

Woo - 4 May 2006 8:05 AM - 2 messages

I am trying to register a dll in SQL 2005. I am running the following: EXEC sys.sp_addextendedproc 'XP_FILE', 'XP_FILE.dll' After doing this the extended stored procedure appears in the master database but I cant use it. I then ran this, as per the Books online: ...

[Question]Problems related to the MySQL of linked server in the SQLServer

Alex Lee - 4 May 2006 7:30 AM - 1 message

Dear everyone. I have two questions about the linked server for the MySQL.(The MySQL ODBC is Ver 3.51) I need to connect to the MySQL DB from the my SQLServer 2000 SP4 on the Windows 2000 standard Edition(MDAC 2.8) ...

booking db design help

sammy - 4 May 2006 4:52 AM - 4 messages

Hey Guys, I am trying to create a web app that uses an SQL db to handle employee scheduling. I can design a table to hold the appointments with no problems but I need to be able to search for free time for the employees. ...

Renaming Foreign Key

Anchi - 4 May 2006 4:40 AM - 5 messages

Hi, Does anyone know if there's a way of renaming a foreign key? Or even name the foreign key on key creation? Thanks ...

DBCC CHECKDB

nate.vu - 4 May 2006 4:27 AM - 3 messages

Hi, Just got a question about the way DBCC CHECKDB works.... When I run a DBCC CHECKDB statement against a database, are all the pages for that database read from the disk (i.e. if there are pages for the database in the buffer cache then these are not used)? ...

[Q]Problems related to the MySQL linked Server.

Alex Lee - 4 May 2006 3:17 AM - 1 message

Dear everyone. I have two questions about the linked server for the MySQL.(The MySQL ODBC is Ver 3.51) I need to connect to the MySQL DB from the my SQLServer 2000 SP4 on the Windows 2000 standard Edition(MDAC 2.8) ...

[Q]Problems related to the MySQL linked Server.

ÀÌ»ó¼ö - 4 May 2006 2:47 AM - 1 message

Dear everyone. I have two questions about the linked server for the MySQL.(The MySQL ODBC is Ver 3.51) I need to connect to the MySQL DB from the my SQLServer 2000 SP4 on the Windows 2000 standard Edition(MDAC 2.8) ...

question

joe - 4 May 2006 1:43 AM - 3 messages

what is the meaning? set ANSI_NULLS ON set QUOTED_IDENTIFIER ON and can i know the stored procedure create/modify date? ...

Multiple Records Subquery..

den 2005 - 4 May 2006 1:21 AM - 9 messages

Hi everybody, I like to display the records for AccountNo = 221 from table records shown below, how would I do this? I am display this results in a crystal report. What is sql statement to do this? Thanks. ...

User Defined DataType

Lianne Kwock - 4 May 2006 12:52 AM - 4 messages

Hello, I received the following error when I was trying to use one of User Defined DataType in creating a table on remote database server. The error message is as follow: Server: Msg 2715, Level 16, State 7, Line 1 ...

Using SQL Server and C# to make simple version control system

bob_jeffcoat - 3 May 2006 11:33 PM - 2 messages

Hello, I make a CAD program and I'm planning on creating a simple product database to control the versions of my customers CAD files. The database will only have a couple of tables, the main one having these ...

WHERE performance issue

Brandon Lunt - 3 May 2006 11:18 PM - 8 messages

I saw two previous posts on this topic with no answers. I run identical queries, one using a literal value, the other using a variable. The query that runs using a variable in the WHERE clause takes 30-40 seconds to run as ...

Differences in error handling between 2000 & 2005

Nick - 3 May 2006 11:01 PM - 2 messages

The following code is executed within a stored procedure, written for SQL Server 2000: SET @BI = "BULK INSERT " + @TableName2 + " FROM '" + @path + "\"+ @TableName1 + "' WITH ( FORMATFILE = '"+@formatPath + "\"+ @TableName + ".fmt' , MAXERRORS=0, BATCHSIZE=500000,CHECK_CONSTRAINTS, ERRORFILE='"+@formatPath+"\"+@TableName + ".bad')" EXEC (@BI) SELECT @err = @@error ...

Appending text to a text field type

wnfisba - 3 May 2006 10:05 PM - 2 messages

I have the following code which properly appends text to exisiting text, but I also need a carriage control line feed so that the appended text will appear all the way to the left when we view it through the application. ...

Email address in stored Procedure parameters

Pantano Antonio - 3 May 2006 9:59 PM - 4 messages

Hi, i'm writing a simple sp that check if an email address already exist in an AddressBook table. This sp expect a parameters called @Address. When i call this sp and pass to it an email address which contains an at ...

Accessing data in a different database?

Linn Kubler - 3 May 2006 9:38 PM - 4 messages

Hi, I'm using SQL Server 2000 and I would like to make a view in one database that returns data from a second database on the same server/instance of SQL Server. Is this possible? If so, how? ...

Update field based on previous record (incremental)

curtmorrisonemail - 3 May 2006 9:12 PM - 3 messages

I have the following table that I want to update: COL1 COL2 ==== ==== 0 8 1 12 ...

Can CTE be used inside a FROM subquery?

Deepak Puri - 3 May 2006 9:12 PM - 4 messages

This issue came up in the MSDN Analysis Services Forum, so I was wondering if there's any workaround: [link] When a Named Query is used in lieu of a table in an SSAS Data Source ...

Newbie - Query with loop?

kat - 3 May 2006 9:12 PM - 7 messages

Howdy, I am relatively new to Transact SQL and need some help on what should be a simple query... I have a table with * Item * Cost * MonthEndingDate (e.g. 1/31/2006, 2/28/2006) I need a query to return the Cost for a given month, but if the cost is null ...

Date question, Can I get Q1, of 2006 begin and end dates?

TallMike - 3 May 2006 8:36 PM - 5 messages

I would like to get the first and last day of a quarter by passing in todays date. I can get the quarter were in with select (DATEPART(Quarter,GetDate())) Now I want to get the day the quarter started (Min day of the quarter) and ...

Need to do the following...any suggestions?

Ben - 3 May 2006 7:30 PM - 4 messages

i need to be able to run the following code SELECT NULL, 'N/A', 0 UNION EXEC spListSubgroupsByGroupID @param Basically, I need to add an additonal row to the results that enters a null value. I cannot change the spListSubgroupsByGroupID stored procedure. ...

Help with Arithmetic Overflow error

7racer - 3 May 2006 7:26 PM - 2 messages

Hi. I could use some help troubleshooting an error in a stored procedure. The SP was developed some time ago and recently started thowing this error: Arithmetic overflow error converting numeric to data type numeric. This error doesn't seem to make much sense since it happens when ...

SMO - SQL Server 2000

Tony HInkle - 3 May 2006 7:23 PM - 2 messages

Can anyone tell me what needs to be done so that the following code, which works successfully for SQL Server 2005 systems, will work with SQL Server 2000 systems. The documentation says that SMO works with SQL Server 2000 ...

duplex communication

wilf - 3 May 2006 7:13 PM - 1 message

I have a need to asynchronously send a short message to an application over tcp/ip after the user makes a selection from a web browser. We are developing a reservation system where the availability to users in close physical proximity is indicated by lights at a kiosk. We want the user ...

Simple but useful technique - is it possible?

Uday - 3 May 2006 6:52 PM - 6 messages

Lets say, I have two groups of numbers (1,2,3,4,5...) and (1,8,3,6,1,4,...) [doesnt matter what the numbers are, as long as they are numbers] If I want to get a list of matching/non-matching numbers using a query, ...

SQL Transs Log Restore

Rick - 3 May 2006 6:29 PM - 1 message

I have a script that has been used to restore logs at a company where I just started. They use the following script to restore the log files in a particular folder as a part of log shipping. The problem arises when the ...

Update Conflict

Tanweer - 3 May 2006 6:02 PM - 3 messages

Appreciate if you guys can resolve my issues I am trying to write a store procedure that can handle Update Conflict Senario to be handled --Row was deleted --Row was modified by other user --Row is locked What is the best way to do it in Stored Procedure also is Timestamp field is ...

How can I print column name only from table?

coke - 3 May 2006 5:55 PM - 3 messages

Is there some Sp out there? ...

Let me rephrease the question.

Justin - 3 May 2006 5:43 PM - 3 messages

I hope I can better explain. I have a column that stores unicode (nvarchar). I am well aware that unicode equivalent for ascii characters. Now if the data does contain non-asii characters, I want to retreive it and ...

Multiple WHERE replacement???

Vito D - 3 May 2006 5:28 PM - 3 messages

Hello, I have a table relationship that connects a list of Amenities provided by each Property, such as: Properties --------------- PropertyID int PropertyName nvarchar(100) Amenities --------------- AmenityID int AmenityName nvarchar(50) PropertyAmenities --------------- PropertyID int, AmenityID int I want to be able to pull a list of Properties that have a certiain ...

Select List question.

hazz - 3 May 2006 5:26 PM - 6 messages

I would like the 'select list' in a select statement to be generated as follows; Query A - select (output from Query B) from sometable. Query B - select Column_Name from ColumnsToSelect where Include_in_Report = 1 ...

Integration Services Project -how to import flat file?

GB - 3 May 2006 5:23 PM - 1 message

Hello, I am recently upgraded from SS 2000 to SS 2005 and now I am trying to create some test SSIS project analogues of DTS package to import flat file to SQL Server. Previously it was possible to create DTS package which created new table for the flat file data on a ...

Fill in missing date ranges

Terri - 3 May 2006 5:12 PM - 5 messages

I have a table AssetValues that contains several rows of data for a particular date. The table has missing dates and I need to populate these missing dates one-time to create historical data and then daily to populate missing data on an ongoing basis. The missing dates are not related to the ...

BCP with Windows authentication?

Rick Charnes - 3 May 2006 4:44 PM - 3 messages

We've been using BCP.EXE for ages, but are now connecting to our databases via Windows authentication rather than SQL ID's. How can I get BCP to connect via Windows authentication? Thanks. ...

Group by and Case Statements

Red2 - 3 May 2006 4:25 PM - 5 messages

Hi, I have a query where I am using a case statement and a group by e.g. Select Field1, Field2, Field3, Max(Field4), CASE WHEN <something> THEN ' ' ...

Using EXEC in a WHERE clause of a SELECT statement

agschwantes - 3 May 2006 4:17 PM - 5 messages

Is it possible to do something like: Select field1 from table1 where [ID] = (exec sp1 '1234567') I've never seen the exec used in this fashion and I've tried to find a direct answer to the question, thanks for any info and I apologize if ...

Returning two values from Case statement

VMI - 3 May 2006 4:09 PM - 3 messages

I want to write a query that looks something like this. I get an error running this: select id_1 = case [ID] WHEN 1 then 'test' , 'test2' -- error end ...

SQL 2005 Editor

Panos Stavroulis. - 3 May 2006 4:01 PM - 2 messages

Hi, I am quite new to SQL 2005. I've just loaded a file called .sp within the Management studio and I can't get it to connect to a database. If I change the file ext to .sql then no probs it works. ...

Opendatasource

bhorwitz - 3 May 2006 3:34 PM - 3 messages

I was able to use the following select qry with an OpenDataSource, but I recieve and error when I change it to an Update qry. SELECT * FROM OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="\\Posiden\apps\Access\MsData\holdbk.mdb"; ...

Float vs Decimal

Bassam - 3 May 2006 2:51 PM - 14 messages

Hello, sorry if this question is silly I'm confused about difference between Decimal and Float data types , if im writing accounting application and use 10:4 as precision/scale in all numbers , does it matters if i choose fields as Decimal or Float in that ...

Archive Strategy

Craig HB - 3 May 2006 2:27 PM - 4 messages

In our Inventory Control database we have tables that grow and grow and grow as the database gets used. Tables like StockResults, Deliveries, StockCount etc. I want to archive the data into archive tables, which I can later moved to ...

Line item query

CJEN - 3 May 2006 2:12 PM - 7 messages

I have a query that I am trying to write that will get demographic information from one table and then get journal entries from another table. However, I want all the journal entries to be concatenated together so in the end I only have one record for each person. ...

Compression or zip function

Which data types for currency?

How would I filter?

Using a trigger for Veritical Partitioning with a calculated table name...

user defined function question?

How do I get count to issue a 0???

PIcture values for a column

Regarding SSIS

Small Stored Procedure Help

SQL Server Stack Dump

Query Performance

stored procedure running too long

a query that doesnt work

CS1595: 'Sanghi.Global' is defined in multiple

control-m and sql25k

CRL return table function using dataadapter

Insert or update depending on existence of record

Inserting data

T-SQL- comparing NULLs

How to loop through a recordset in an SP

Count and top

String comparison

(a,b) not in ( select c,d from ... ) , is it possible ?

Combining XQuery and data paging in SQL Server 2005

SSIS and DTS

Query Problem

Problem with Group by and having using alias

How to loop through each row in table?

Joining multiple tables

ALTER SP if exists in all databases

deleting hyphens in a phone field

Strangest thing in my life (well, almost)

Is my beloved TSEQUAL() officially dead in 2005?

Foreign Key Question

max memory for SSIS?

rundll

create secondary for getting property set extention failed

Poor query performance with: set statistics time on (SQL2K5)

Helpful suggestions...

carriage return in a text field

grouping and ordering in OUTER JOIN

T-SQL

Combining two rows into one

Table Partitioning (SQL Server 2005)

Bulk Insert not importing all records

What is non-deterministic or imprecise in this code

NOT LIKE '%' difference on SQL 2000 and 2005

Question about design practice - Address table

Optional Query with in a Query

Need help with Complicated Sort-by-value-groups-if-... confused.

Help with combining two queries

Help with counting query

Transform column headings to a character variable

I really need help with this one.

Bad Practice: Calling Views From w/in Stored Procs

prob w cursor for checking nulls in a table

Help with datetime field

Sorting efficiency

Function with local parameters

Insert Table Lock - Various connections inserting into one table

table lock on insert (multiple inserts at one time)

Cursors only fetching about 200 records?

need a simple query

Erroneous EOF's from Simple Queries

Can I use SqlBulkCopy to copy from a non-SQL Server database TO a SQL Server database? (VB.NET 2005)

ActiveX Scripting in JobStep

'reportServerTempdb.dbo.persitedstream'

Query over name/value table

SSIS Training

reporting database

selecting from more than one table

Searching on unicode characters

Indexes On Filegroups

IS THIS GOOD DESIGN?

Help with date query

High CPU utilization after SQL Server reboot.

Sql server to oracle conversion

Data Imprort scripts

Database Snapshots question

Querying most recent backup

sql25k questions

other possibilities than cursor

Error: 1203

Treating Null value as 0

Data Driven Query Task - question about Insert and Update queries

2005 Directory Tree

how to set multiple local variable from single select statement

[Q]Problems related to the MySQL linked Server.

SQL truoble!

ODBC call SQLExecuteDirect() takes more then 50 milliseconds...

Finding displaying and deleteing dulpicate records

Returning Date Formats in Stored Procedures?

TSQL ELSE IF

How do I design for categories, subcategories, subsubcategories and so on?

Data translation

Help! Processing Hard Coded vs. Stored Procedure

Display multiple rows as one record

debugger

Text change management

CAN'T FULLY UNINSTALL SQL SERVER 2005 STANDARD

SQL help please

Sorting Numeric Strings

Query Optimization NOT IN vs LEFT JOIN

DECIMAL datatype

too many connections with .NET

Alter table - add default value

SMO Settings Question

How to read the content of a flat file in Stored procedure

write conflict problem with InsteadOf Update Trigger

update qry

Select the users in a database

listing columns in view and stored procedures

Viewing table variables when debugging

Stored procedure

HELP! - SQL Mail

Do i need primary key?

Delete Data from a Column

ExecuteNonQuery in SQL 2005

too many connections with .NET

ok again. Field status unavailable at record update (serverside cursors)

TSQL Error

Converting to crosstab table

Scalar Functions Re-Revisited - Doesn't Concantenate

Is there anything similar in TSQL to oracle code "SEQUENCE.NEXTVAL

decrypt function

xp_regwrite vs. xp_instance_regwrite

Order by question, pls help

Help with query! Ranking of Sum() column

Getting size of table

BCP : Format File : Second Question

BCP : Format File : Export Table

Running the Genereate sql script by code

looking value in table

US-CA-LOS ANGELES SQL Server DBA/Developer

UNICODE question

Best Practices - SQL Transactions

SQL Server 2005: error: 26 - Error Locating Server/Instance Specified

Using SQL Server 2005 Public Keys in VB.Net

SQL 2005: Replication: location of snapshot files?

Splitting a String

How do I make a field automatically get its values from another fi

Calculating Hours, Mins over 24 hour periods

how to prevent 2 users from running the same front end process at the same time

COPY to a .txt file

how to ALTER COLUMN ?

bug in string processing if the GO keyword is inside the string

sqlite current_timestamp

Transactional Replication - Modifying Target tables