Microsoft SQL Server Forum

How can you remove a part of a text field in sql but leave the section that is needed such as the cat went up the hill: the dog followed on behind the mouse went the other way (4 spaces between 'behind' and 'the mouse') 'the cat followed on behind' is the only bit I need Also need to add that the text field varies in length so...

Good day, I'm getting an error when I'm inserting to my standard table. The below is the code that I have Insert into Bidvest.dbo. (, , , , , , , ,

I have a table with 3 columns. The first column has Hexadecimals. The second column has the corresponding binary numbers. The third colmn has boolean values. I need to select 4 records where the colC is False for the 4 records, the last two digits of the first record's colB (Binary value) are 00 and the other 3 records' ColB are the next...

Now i have a MSSQL table, Material The fields are as below, Type, Mat_Name, Size1, Size2, Size3 A, Wood, 100, 100, 100 A, Iron, 200, 200, 200 A, Steel, 300, 300, 300 B, Plastic, 400, 400 ,400 B, Ore, 500, 500, 500

i have no idea for how to create trigger and how to execute trigger in sql server 2008 Please help How to trigger execute to export csv file? Select * from user_Registrition; user_Registrition table to create trigger and trigger excute to all user_Registrition data export in csv file

actually i am working on a project in which members are added in a tree pattern, and get the payment accordingly. My tbltestingtree structure is ass follow: Id ParentId IsLeft IsRight 1 Null Null Null 2 1 1 Null ...

I am having a table tbltestingtree representing the tree structure, Member_Id is the id of the member, Parent_Id represent the Parentid of that member , Lefts and Rights tells us that the member is attached to the left or right of the Parent. **My problem is that i have to make a sqlquery that counts the total number of pared members for any...

Which options do i have to create a database link between MSSQL and DB2 to use sql-functions like a view...

Hi Pinal Dave, I have 2 columns in one table, its datatype are numeric(18,0),datetime when i am going to encrypt these column i’m adding columns with same datatype it is giving error when the time of updation and I am tried with varbinary(256) also it is giving the same error. The error is ” Argument data type numeric is invalid for argument...

I have installed W7 64 bit. And SQL Server 2008.When open project on VB6 then find that SQLDMO missing. Thats why I installed MSDE(Microsoft Desktop Engine), then missing fix. But when run project find error in following line DIM sqlVer AS SQLDMO.SQLSERVER Set sqlVer=New SQLDMO.SQLSERVER Error is : To Connect To this Server You must...

In SQL Server 2008 R2, I have a stored procedure X, which execs 2 other stored procedures: create procedure X begin exec A exec B end Stored procedure A has a transaction in it

. Provide a list of productid’s, the name of the vendor and their credit rating. The results should be ordered by last name and then by credit rating. Write out the SQL that would accomplish this.

I am trying to execute below sp but i am unable to get the result. reasion is i am using function which is return string values like ('ab','df','dfff').when i use this function in operator it is not returning any value ..anybody help me why it is not returning ?. function name (.fnParseSplitString(@stQueueName))) ALTER PROCEDURE --...

select case when adjAmount < 0 then 'No. of Negative Cases' when adjAmount > 0 then 'No. of Positive Cases' else 'No. of Null Cases' end as Report,procEndDate, count(adjAmount) from dbo.tblProductivity_HIS_DEV8 where procEndDate between '2013-04' and '2014-04' and procstatus = 'Complete' and inventory = 'N' and...

Hi, Everybody is saying that to avoid Cursor in SQL Server, then why we have cursor in sql server? Cursor mainly for Row by row iteration, we can do it using while loop, then why cursor concepts are implemented in sql server. Thanks, Ramesh

select OrderId, OrderGroupId, dtCreated,DORNum , (select top 1 intPercentageFill from orders where OrderStatus='sh' ) as 'intPercentageFill' from orders where OrderStatus='sb' i am try to display on intPercentageFill column the data that have a status="sh" no sb like the other ,in this case is displaying but only the first record,the...

I would like to use Windows authentication on SQL Server, but so far I could not find a solution to this problem... The application has algorithm on which rows and columns withing a table specific user allows to read or modify. To do that, on the SQL server, the user must have read/write permission on that table. However, if the user has...

I have a table .that table record. 1-Name 2-Salery if have 100 record that table. firstly salery should be assending order. then display only 1,3,5,7,9.....

I have items in a group. Each item has a time stamp. I'm looking for gaps of two seconds or more. I can order them by GroupId and ItemId and manually search for gaps. The gap for ItemA is defined as ItemB.Created - ItemA.Created. How do I query to find the length of the gap for each item?

Hi, I'm getting following error while creating an SSIS package Could you pls advice on it, how should i go forward as i'm new to creating an SSIS package Thanks in Advance!! HRESULT: 0xC0204016 (Microsoft.SqlServer.DTSPipelineWrap)

I am developing a website for local business classified. Where Service Provider / Traders will post advertisement of their business / shop etc. and end user will search for their needs and locate all the adv. based upon their search. Basically this will be SIMILAR to JUSTDIAL.COM While posting and adv. I have provided input field to...

How to empty transaction (log.idf ) for sql server 2000 ?

I am trying to get this query using a derived table and an aggregate function to work in Excel Query: select purordcom.* from (select purOrdDet.PurAcct, sum(PurOrdDet.ExtCost),PurOrdDet.PONbr from AEMApp.dbo.PurOrdDet PurOrdDet group by PurOrdDet.PurAcct,PurOrdDet.PONbr) as PurOrdCom But I get a generic error. So I broke it up into two...

Does anybody knows a simple way to create a pivot of this result: 12 45 29 5 This result is created with query: SELECT = SUM(CASE WHEN AGE >= 0 AND AGE <= 1 THEN 1 ELSE 0 END), = SUM(CASE WHEN AGE > 1 AND AGE <= 2 THEN 1 ELSE 0 END), = SUM(CASE WHEN AGE > 2 AND AGE <= 3 THEN 1 ELSE 0 END),

This may be a really stupid question but i am writing a billing, scheduling, dispatching, and customer information organization program. Currently its running off of an sql ce database, but im not sure if the 4gb max is something i should worry about. if i should be, what would be the best alternative. Thanks.