.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Small T-SQl Help

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server
 I have the Following query that is defined like this

SELECT SUBSTRING(DESCR,charindex('[',DESCR)+1 ,charindex(']',DESCR))
and Produce the following results

Now i want to get Rid of the Bracket as i did in the query by removing the "[" first bracket.

Vuyiswa Maseko

View Complete Post

More Related Resource Links

I want Er Diagram for Fees System of small institution ,can u plz guide me what fields are necessary


I want Er Diagram for Fees System of small institution ,can u plz guide me what fields are necessary to store Fees information ...


XmlLite: A Small And Fast XML Parser For Native C++


XmlLite provides a high-performance, low-overhead XML reader and writer geared for applications written in native C++. Learn more here.

Kenny Kerr

MSDN Magazine April 2007

A small web application


Hi, I just a very small web project now I want to go further.

The question is that I have't found a proper direction to practice and improve myself. I downloaded dotnuke and found that is it too bigger and hard to learn for personal study. My goal is to do something like ajax+web sevices+sql etc.

Hopefully I can get some suggestion. Thanks.

How to create modile application with small DB?

Hi Friends, I am going to create my first Windows mobile application, I know Windows Form development. I want to know how to create mobile application with small DB. How I can use SQLlight DB or Shall I use text file to store that values? Which is the best way, I don't want to use SQL server..! Because I want to save few values that's all.   Thanks, Naga Harish .

Small issue extracting soap from xml using Xelement

The following code works fine, except it only gives me the value being returned (integer), with no XML tags at all.  I want the raw XML without the soap (not just the value). display code:                 Dim path1 As String                 path1 = "c:\temp\testing.xml"                 ExtractSoap()                 File.WriteAllText(path1, ExtractSoap.Value.ToString())   function: Public Function ExtractSoap() As XElement         internalStream.Position = 0         Dim xmlMessage As XElement = XElement.Load(XmlReader.Create(internalStream))         Dim soap As XNamespace = "http://schemas.xmlsoap.org/soap/envelope/"         Dim body As XElement = xmlMessage.Element(soap + "Body")         If body IsNot Nothing Then             Return DirectCast(body.FirstNode, XElement)         End

Small quible

Read about SSCE 4 and just installed it. It did not allow you to choose the install location, for 2mb Not too big a deal, But I like to have my development stuff separated from the rest...

Is it possible to prevent seeing results if rowcount is small?

Hi, we are about to start a new project. In the project we won't be owning the data to be analysed. The data provider is going to require some special rules for the usage of data. This is because the nature of data the - the data is going to be information sensitive. They are asking if we could implement a restriction which would prevent to see results rows if there is less than five result rows. I couldn't find any ideas how this could be done. Is it possible? How? We are running Sql Server 2008. Thank you in advance, Teemu Ajalin

Proper Approach for Monthly PDF Reports for Small Business?

Hello, all. Previously, our environment included an installation of WSS 2.0.  One of our most widely-used "features" was a page of links to reports on network file shares.  No one liked or trusted the Document Libraries, so we continued to store our weekly & monthly reports at places like \\fileserver\r-drive\MonthlyReports\2010\08\Sales\LicenseActivationReport.pdf and then created a bird's nest of links on our WSS "Reports" page to allow folks to find the information they were looking for more easily.  I'm not talking about a Links List, but a page of text with about 30 links to individual reports whose locations changed at least monthly.  These reports are roughly 70% PDF (exported from Crystal Reports), 25% Excel, and 5% Word. Today, we have an installation of MOSS 2007 Standard.  The collaboration and document management features are taking off quite nicely, but the staff is understandably itching to migrate the above-described "Reports Page" from WSS 2.0 to MOSS 2007. I can think of a few different approaches to this situation: We could reproduce a text page with 30 links to places like file:\\server\share\report.xls, but this seems contrary to SharePoint's mission.  It's certainly contrary to what I told the staff during training:  "Don't turn SharePoint into a bird's nest of links to ext

Who can translate this? Small PHP to ASP .NET

Hi,I'm a PHP Developer but I want to help one of my friends who is a newbie. Can anyone from here translate this code from PHP to ASP .NET?Part one: TO BE PLACED IN THE HEADER!/* BEGIN */if(isset($_REQUEST['ref']) && $_REQUEST['ref'] != ""){       $expire = time()+60*60*24*30; // 30 days     $do = setcookie('ref', $_REQUEST['ref'], $expire);    if( ! $do){        $_SESSION['ref'] = $_REQUEST['ref'];     }   }else{       $expire = time()+60*60*24*30; // 30 days     $do = setcookie('ref', '', $expire);    if( ! $do){        $_SESSION['ref'] = $_REQUEST['ref'];     }   }/* END */Part two: TO BE PLACED IN THE FORM! /* BEGIN */<input type="hidden" name="ref" value="<?php echo isset($_COOKIE['ref']) ? $_COOKIE['ref'] : $_SESSION['ref'];  ?>"/>/* END */The code tries to write a cookie with the name ref and if is not able to write that cookie it will create a session var with the name ref. The value must be retrieved after that in a hidden form field.Thank you in advance.Marius

SS2008 Supported on Windows Server 2008 Small Business

I am planning to install Sql Server 2008 x64 on Windows Server 2008 x64. My question : Is it only SqlServer2008 Standard Edition x32 supported on SBS2008? I checked the chart of the SW requirements and I am not sure about it.

SSRS option to make capital first letter and rest small letters of a string

Hi, In the 'Name' field of String type is appearing all capital letters. I want to appear it as first letter is capital and rest all small. If there is space between two characters, then the second should appear as Caps again. Ex: 1. PETER Should appear like Peter 2. ALEXANDAR PETER Should appear as Alexander Peter Is it possible in SSRS or SQL Query ? I am using SQL Server 2005 SSRS Reporting Services. Thanks,

Small problem with FOR XML EXPLICIT

Hello everyone, For my BizTalk application I need to receive "STRUCTURED" XML from SQL Server so I decided to use FOR XML EXPLICIT.  I have a pretty simple scenario. I have 2 tables in SQL. One is a table for invoices, the other one a table for items. One invoice can have many items. I use a stored procedure to retrieve invoices. Right now the returned XML only retrieves the items for the last invoice. So if the SP returns 3 invoices, the first 2 will only have the receipt number and supplierIdCompany and the last record will be complete with the items (as expected). My SP is as follows ALTER PROCEDURE [dbo].[RetrieveDeliveryreceipts] AS BEGIN SET NOCOUNT ON;     -- Insert statements for procedure here  SELECT 1 AS TAG, NULL AS PARENT,  tblDeliveryReceipts.dlrReceiptNumber AS [tblDeliveryReceipts!1!ReceiptNumber!ELEMENT],  tblDeliveryReceipts.dlrSupplierIdCompany AS [tblDeliveryReceipts!1!SupplierIdCompany!ELEMENT],  NULL AS [tblDeliveryReceiptLines!2!ItemDescription!ELEMENT],  NULL AS [tblDeliveryReceiptLines!2!Quantity!ELEMENT]  FROM tblDeliveryReceipts   WHERE tblDeliveryReceipts.dlrReceiptNumber = 'B 00000010' OR tblDeliveryReceipts.dlrReceiptNumber = 'B 00000011' OR tblDeliveryReceipts.dlrReceiptNumber = 'B 00000012'  UNION ALL  SELECT 2 AS TAG, 1 AS PARENT,  tblDeliveryRec

Why input text is so small in the People Seach box?


I have SharePoint Server 2010 Enterprise based intra.
I have added People search box.

I wonder why text is so small if I add search word.


Small site embedded login validating against Active Directory and redrecting to SharePoint site


I am only finding pieces of this information. 

Challenge: Have a standard page with a login box in the corner that is exposed on the web.  The login will validate an employee against AD and also redirect them to a site collection.

I have found information on claims based authentication and the AD Membership provider.  I have also found information on form based login pages.  Most of these examples though just modify the SharePoint form login.  I want to create just a small login box on a page that is already created.  The one thing that I can't seem to find any really solid information on is the redirect to a site collection.

Can anyone tie all of this together for me?  Am I using the correct terminology and heading down the right path.

Any help is greatly appreciated.

SSAS - Besides 2 big user defined hierarchies, plently of small hierarchies


Hi All

I am working on a project where we have to define an Organization Dimension (we defined a standard dimension not parent-child for performance reasons).

The company I am working for is using codeblocks at the lowest level of the hierarchy (combination of business unit, operating unit, etc...).

We created two user-defined hierarchies on that dimension

- One organizing the codeblocks Geographycally (we have attributes like Area, Subarea, CountryGroup, Country)

- One organizing the codeblocks from a Service perspective (ServiceLine, Subserviceline)

The table looks like:

Codeblock, Area, SubArea, CountryGroup, Country, ServiceLine, SubserviceLine, ...

An additional business requirement we have is to define plenty of very small hierarchies besides those two main hierarchies.

One example would be to have a hierarchy that combines values for Country(Switzerland) and Country(Germany). Of course it would be possible to create calculated members in the MDX Script but we have the requirement to be able to drill down from the sum to the individual countries. Since calculated members are not allowed to have children, they are not an option.

We would like to avoid using a parent-child dimension (I know the possibility of using a parent-child with multiple hierarchies).

One ugly option I found is to add dum

Writing to excel file - The field is too small to accept the amount of



I am writing to excel file using jet driver. If the length of value exceeds 255 characters i get the below error.

'The field is too small to accept the amount of data you attempted to add.  Try inserting or pasting less data'

Please could you provide a solution to how can i add values with length greater than 255. Excel file is 97-2003 format.

System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand();
 System.Data.OleDb.OleDbConnection connection =
          new System.Data.OleDb.OleDbConnection(
              "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + destinationFilePath + ";Extended Properties=Excel 8.0;");
command.CommandText = "Insert into [sheet1$] (col1, col2) values ('1', 'TEXT Message greater than 255 characters')

Report Viewer column width too small when viewing in IE 8, works in IE 8 compatibility view and Fire


IE 8 Version 8.0.7600.16385 64-Bit Edition
Report Viewer

The web page is just the report viewer control (see code below).  

When the report is rendered in Report Viewer   (IE 8), the width of the first column is much smaller than it should be. 
When the report is rendered in Report Manager (IE 8), the width of the first column is normal size.  
When the report is rendered in Report Viewer (Firefox or IE 7 compatibility view), the width of the first column is normal size.


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" %>
<%@ Regi
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend