Need to Bulk Insert from a txt file: *************************************** Problem Description - There are special characters present in the file. For e.g., Montréal, Côte-de-Liesse… through Bulk Insert, they are getting saved in SQL Server as Montr+¬al, C+¦te-de-Liesse… --------...more >>

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 A B C 4 Vitamin 56 4 Vitamin 34 I would like to me...more >>

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 well. But there isn't always a delimeter in the column va...more >>

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? I have a small test server with SQ...more >>

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

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 ( tbl_id int identity(1,1) primary key, tbl_nam...more >>

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

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 the compiled application in another machine it returns with no recor...more >>

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 the same # of columns do not exist in both tables. Is t...more >>

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...more >>

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 join (select distinct salutation from complainer) as c2 on c1.complainerid = c...more >>

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? FETCH NEXT FROM a...more >>

-- Randy...more >>

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 repeatedly need to do... We have a table called CONTSUPP in our Sql...more >>

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 luck. I can save 'most' file types and get something useful (will op...more >>

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 ...more >>

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 properly. To do this I changed my code that was r...more >>

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? @ Shahul. ...more >>

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 the same( Feb-28days, Mar-31days, Apr-30days) and the d...more >>

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: SELECT TOP 5 * FROM EVENTS WHERE NOT EXISTS ( SELE...more >>

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: SELECT TOP 5 * FROM EVENTS WHERE NOT EXISTS ( SEL...more >>

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. Any articles on this? Thanks. -Greg ...more >>

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 Est...more >>

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 fld2 and fld3 unique and fld1 is the last enter. For this i us...more >>

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 ) INSERT INTO #Threads(MsgID,RootMsgID,Foo)VALUES(1,1,'A') I...more >>

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 emp...more >>

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 ...more >>

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: select StartsAt As convert(varchar, StartDate,111)+case when ...more >>

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 need to check every week in this manner. ...more >>

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 operation but for...more >>

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) ) INSERT INTO WordList VALUES ('L...more >>

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 '%' + cu...more >>

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

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. What I am attempting to do is isolate the most recent endDate for each ID and am ...more >>

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 in the EMPLOYEE table. ...more >>

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 ) ...more >>

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. But same result. I know server configs can ...more >>

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, i can see it in your logs, you're all i've ever wanted, you're the subject of ...more >>

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 TranDate <= @ToDt I'm thinkin...more >>

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) i want to return them as one result, but when i do this: SELECT we...more >>

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), @table Varchar(20), @PatNo int, @Type int, @Range in...more >>

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 Parameter1.: "test user"<testuser@yahoo.com> search Parameter2.: <testuser@yahoo.com> search Paramet...more >>

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 JOIN dbo.CommunityProfile CP ON Ad.IPCode = CP.IPCode AND CP.StatusCode = 1 ...more >>

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. something like DECLARE @div char(20); SET @div = 'DBName'; go CREATE VIEW view...more >>

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 SELECT DISTINCT OmimVarLocusIdSNP.snp_id,G...more >>

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?...more >>

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 ...more >>

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. They both have the same dat...more >>

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: DBCC xp_file (FREE) A...more >>