Hi I have the problem in splitting the string in T-Sql For example the string is like $EmpId = 1$; $EmpMgr=2323$;$DeptNo=20$ I have to get the EmpId , EmpMgr and DeptNo from the string i.e 1,2323 and 20 and use those values in th query. can anyone help me how can the splitting of the str...more >>

Is it safe to assume that an empty string (which contains any number of space characters) is always equal to ''? Or should I go for ltrim(rtrim(@string))=0? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 11:22pm ...more >>

given this table: staff_id trx_type amount -------- -------- ------- 001 A 10 001 B 20 002 C 10 how to convert into this form the smart way? staff_id A B C -------- ---- ---- ---- 001 10 20 NULL 002 NULL ...more >>

I am trying to create a late rental report for a video game rental store. The problem is the only way to determine if a game has been rented is by searching the description of the game field which has been modified to have the date + '2DY' + 'some string of numbers'. So what I have done is searc...more >>

We would like to analyse some sales transactions and check a theory of monthly growth. ie the third month growth of a customer is 1.5 the original month. We have a basic Sales Transaction table with: The following fields: TranDate, Client, State, Amt, SalesType 10-mar-2003, ABC, CA, 1000...more >>

I have two tables with one to many relationshtp. I need to create a view to display all the records in the "one" table and pivot one of the field and an aggregate sum of another field in the "many" table. At present not all "key" records in the "one" table have relate records in the "many" table....more >>

I have a table that I use for an intermediate step in importing data. All incomming data is inserted here, then checked for consistancy and inserted into the table where it belongs. (batches). The transaction log is getting very large and I really don't care to log the transactions in the init...more >>

I have a column of strings that have leftmost spaces that need to be trimmed. What would be the easiest way to do this Thank Jb...more >>

trying to duplicate an access query in sql server 2k which shows 10 or more decimal places. what needs to be done to extend decimals in sql? i've cast the fields which are muliplied as numeric(24,12), but they still only display max of 6 decimal places. any idea how to extend this? tia...more >>

In several messages that I post early I need help for create Dynamic SQL or that I trying to do. Here is an example of my store procedure ALTER PROCEDURE dbo.Test /* ( @parameter1 datatype = default value, @parameter2 datatype OUTPUT ) */ AS SET LANGUAGE us_english SET NOCOU...more >>

I am using this query to calculate Median of a group of data.it works fine but when there are 3 records ,it dosen't work .can anyone solve the issue. INSERT INTO @Median SELECT total FROM mytabel SELECT @cnt = COUNT(*) FROM @Median /*Number of rows to be calculated*/ IF ( @cnt % 2 ) = ...more >>

I have a query that is supposed to populate a table called CUSTOMERS with information from the first transaction for that customer. (CUSTOMERS includes an ID field called CUSTOMERID which is unique.) The transaction info is in a table called HISTORY. I've picked some samples off of some usenet...more >>

I have got a query like this: a 12 b 3 c 66 d 77 m 1 h 100 I want to do sorting based on the numbers (order by seems to sort based on characters asci code) would appriciate your help. ...more >>

Hi I am wondering if there System Restore feature in Windows Server 2003. Let me know where I could run this if it exists. Thanks -Lawrence ...more >>

I need to filter a select with IN statement: SELECT * from table where ID IN ( ...... ) But the IDs list is based on a dinamically creates SQL Statement, that I run with sp_executesq. So I cannot use a statement as SELECT * from table where id in (select id from table2). How can I create a ...more >>

HI In some sql select queries you have "where 1=0". WHat does mean and do Sorry am a novice cheer Barnabie...more >>

SQL 2K We are in the process of forcing our developers logging into Servers by NT Authentication. Controlled user-access level from the NT groups. Here is my scenario, I have a user 'Mydomain\Myuser' with full rights on server 'MyServer' . Inside SQL Server, I don't have a login for 'Mydomai...more >>

Can anyone please explain about a object rule in sql server ??? Regards Ajay ...more >>

i have the following script: ----------- declare @field_count int declare @x table ( metafieldid int primary key , value varchar(50) ) insert @x ( metafieldid, value ) select metafieldid, value from ufMetaDataSelectOpenXml(@metaxml) select @field_count = count(*) from @x insert @...more >>

Hi friends, I have a problem with my Sql Server (Win2k Server, Sql Server SP3 updated) replication. My replication stopped with "The process could not bulk copy out of table '[dbo].[syncobj_....." message. What is wrong? Could anybody help me? Arda Han Software Engineer ...more >>

Is it possible to create a query (a view/stored procedure) based on the tables from two different databases? Thank you. ...more >>

I have a problem with posting today. Some of my messages appear on news group, some don't. What it depends on? I reposted one message 3 times with intervals. And it's not here. Does the contents of the message affect it's appearance? I included in lost messages the text of trigger. Nothing speci...more >>

HELLO... HOW WOULD I FIND ALL COLUMNS THAT HAVE THE WORD *_CASE* IN IT USING SQL? ...more >>

How can I have a varchar column work as an identity column? Basically I need to automatically put an incrementing value into a varchar field. Any ideas please. -- Michael Tissington http://www.oaklodge.com http://www.tabtag.com ...more >>

Friends, I have this value @status =3D "P, R, A" which I would be passing to a = stored procedure=20 I thought I could use IN in the stored procedure instead of =3D but I = get syntax error. =20 ------- WHERE .... .... and (@status is null or status IN @status) ..... ------ =20 ...more >>

I have a bcp command which exports a SQL table to a file in a directory. When I start the command from the command prompt it works just fine. But when I try to start it threw a .NET application using a SqlCommand object with a parameter the string of the bcp command - nothing happens! The Execut...more >>

I've written a stored procedure to enter data into a table consisting primarily of nvarchar and ntext fields with a uniqueidentifier field, which is being used as the primary key. In my application, I need to grab a copy of the uniqueidentifier for the record being written for use later on in the a...more >>

I am having some confusion with why a UDF defines to be a system function must begin with fn_. I see docs that recommend UDFs begin with fn and I have found many docs which explain why a UDF is two or three part qualified name to distinguish it from system functions which are non-qualified names...more >>

Here are the tables I'm dealing with: CREATE TABLE [dbo].[DataField] ( [OrgID] [int] NOT NULL , [OrgLocID] [int] NOT NULL , [DataFieldID] [int] NOT NULL , [RegExFormat] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [FieldName] [varchar] (20) COLLATE SQL_Latin1_General...more >>

2 Tables Tbl_1 1 null 2 null 3 null Tbl_2 2 'abc' I want Output to show: 1 null 2 'abc' 3 null Regards, Tim ...more >>

I think I need some good references to SQL Server to learn some basic functions. I have a stored procedure that creates document numbers with a value within a table. 2 instances of our application called my stored procedure and at the same time, they accessed the value and generated d...more >>

Hi All, I work in a Network Environment. My System Number is "system1" where the SQL Server DB is Installed. And If I Try to Bulk Insert any thing from my system Then it works fine. But If I Try to do Any BULK INsert from "system2" then I Get the below ERROR!!!! Server: Msg 4861, Level 1...more >>

Given the following table... CREATE TABLE [dbo].[tblEmployees] ( [EmployeeID] [int] IDENTITY (1, 1) NOT NULL , [SupervisorsEmployeeID] [int] NULL , [JobTitle] [nvarchar] (50) NOT NOT NULL , [JobDescription] [nvarchar] (200) NOT NULL [FirstName] [nvarchar] (50) NOT NULL , [LastName] ...more >>

I am getting an error on an ASP page that does a simple update to a single row in a table. The SQL statement is: UPDATE tblRecHead SET Qty = 1 WHERE SeqNum = 123 and LineNumber = 12 The ASP page will time out and return an error. If I change the SQL to: UPDATE tblRecHead SET Qty = 1...more >>

Can someone help me out with this. Say I have a simple inner join Select * From myTable t1 inner join anotherTable t2 on t1.id =3D t2.id Where t2.field =3D 'something' I can rewrite this join like this, elimating the where clause Select * From myTable t1 inner join anotherTable t2 ...more >>

Hi all, I have a number of columns in an SQL server table that are of type Decimal. The problem is, when I create a stored procedure and add decimal data to the table, the decimal places are chopped off. The number of decimal places to be stored is set to auto, so that should be ok. Does an...more >>

I need to be able to allow the user of my system to clear the data in ceratin tables. The easiest and cleanest way for me to do so is to drop and re-create the tables as this also resets all the ID columns. I can put the commands in a SP but this means that everytime I make an alteration to t...more >>

Hello, we are working on our very first database attempt using MSDE and ADO.Net in our VB.Net application. We have many unanswered questions like: 1> how would we update database (add tables/modify fields etc) for clients between our subsequent releases without loosing their data. 2> how wil...more >>

Hi all, I have a table in my database that is causing me some problems. The scope of this problem is limited to two tables - table A and table B. table A has a primary key of type nvarchar(100) - let's call it "UID" table B has an ID (not necessarily unique) - call it "myID" and a foreig...more >>

Hi, I know nothing about scripting operations on SQL, so I'm hoping someone could help. I want to simply go through a table and everytime one of the columns equals a certain value I want to delete that record. So I have a Database called SMS_C00 I have a Table called PkgServers in it are ...more >>

Sorry if this post is there already. I cannot see it although I made it before my other posts which I see. I have 3 tables - Job (real name is Sopa), Order (real name is Ordr), OrderDetail. All of them have a bit type field RowDeleted. I would like to update this field in Order and OrderDetail...more >>

I have this stored procedure which uses dynamic SQL: CREATE PROCEDURE CRCommissionPayments @Salesman int=null, @CheckNumber varchar(20)=null, @DateMin varchar(20)=null, @DateMax varchar(20)=null, @SortBy varchar(50)=null, @SortOrder varchar(10)=null AS DECLARE @sql nvarchar(1000) DECLAR...more >>

I recently discovered that when an identity column overflows, you get a SQL error when you try to insert. What is the best method to handle a reset of the identity seed since the table may contain old rows with random numbers which may be foreign keys?...more >>

Hi, Is it possible to send a table, derived from the TABLE data type, from one SPROC to another? I'll give you a break down of my problem, and perhaps there is a better way to do what I want. -I have a SPROC (let's call it "MAIN") that returns a result set (this result set was generat...more >>

Hi , group I am trying to create a SQL dinamicaly in a Store Procedure but all the time I recive the following error: Syntax error converting datetime from character string. Here is my SQL: declare @sql nvarchar(1024) declare @Desde int,@Hasta int declare @FDesde nvarchar(10),@FHasta nv...more >>

I am trying to update a record based upon a value found in a view of a parent table. This is what I have attempted - I don't get a syntax error but nothing seems to happen. The ITEM field is equal to the sequence key in the Parent View called V_InvItems - I need the view as that view uses a fi...more >>

I need to build couple of user interfaces to enable users to maintain a table like add new records , delete existing records and modify existing records. I would preferably like to do this from a .Net system they must be easy to deploy and universally accessible across the company. Please a...more >>

I have a requirement to publish dashboards for SQL Server like gauges, sliders, graphs, etc to a digital dashboard. Please advise which is the best way to publish dashboards on SQL Server. Also please point me to some resources on some sample dashboards to SQL Server. If it is Sharepoint ca...more >>

I am using xp_cmdshell in a couple of stored procedures to do some decrypting of files tha were transferred and then using bcp to copy the data into tables. This has been working jus great up until about 2 weeks ago when it stopped working. I hadn't changed anything as I have not been on the m...more >>

Hello Experts, I'm a little bit confused about what happening with these queries. I'm trying to add a priamary key on my table. The First Set of queries do not do that, the Second Set does that, the funny thing is that I don't see a serious reason not adding my PK with 1st Set of qurei...more >>