Post New Web Links

I Need help with my SQL code please !

Posted By: Posted Date: October 10, 2010 Points: 0 Category :Sql Server

I have to display all fields of my table with a break based on the first two digits of the account number and subtotal of the account balance field at each break.

I've been trying for while now but I ran out of ideas on how to write it. And I keep get this error message everytime I execute.

BEGIN TRANSACTION 
SELECT account,AcctDescription,ShortDescription,Store,AcctType,Balance 
FROM tblChartofAccounts AS SubTotalBalance 
WHERE account Like '10%','11%','12%','13%' 
SELECT SUM (Balance) AS SubTotalBalance FROM tblChartofAccounts
COMMIT

And the error code is

Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ','.

Any suggestions I would appreciate!

thank you

View Complete Post

More Related Resource Links

Code Optimized Web Development Profile (VS 2010 and .NET 4.0 Series)

When you first run VS 2010 it prompts you to select an IDE profile to use. The profile you select will configure how tool windows are displayed/docked in the IDE by default and set the default keyboard shortcuts. You can then customize any of these settings by using the Tools->Options menu within the IDE and then override/change them. You can also later reset your profile and pick a different one by choosing the Tools->Import and Export Settings menu command.

Free Code Snippets - ASP.NET

You Can Find Useful ASP.NET Related Posts on the above link.

Free Code Snippets - C#

Free C# Code Snippets

call JavaScript - jQuery code from ASP.NET Server-Side

jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

call JavaScript - jQuery code from ASP.NET Server-Side

Microsoft StyleCop: Source Code Analyzer for C#

StyleCop is similar in many ways to Microsoft Code Analysis (specifically FxCop), but there are some important distinctions. FxCop performs its analysis on compiled binaries, while StyleCop analyzes the source code directly. For this reason, FxCop focuses more on the design of the code, while StyleCop focuses on layout, readability and documentation. Most of that information is stripped away during the compilation process, and thus cannot be analyzed by FxCop.

Code spelling checker extension for visual studio 2010

Building a spelling checker for source code as an extension for visual studio 2010.

C# and XML Source Code Documentation

Through many years of enterprise level software development and consulting, I became critically aware of the importance of good source code documentation, and several years ago when I began working with the first release of Visual Studio .NET beta 1 and found C# provided built-in support for inline XML code documentation, I was thrilled.

Bar Code Scanners with the .NET Compact Framework

Summary: Learn how to make your applications use bar code scanners in a generic way-ndependent of the specific bar code scanners that are used on different devices. Using the design patterns FaÃÂ§ade and Factory, the implementation not only supports multiple bar code scanners, but it also makes it easy to add support for other bar code scanners. After a brief discussion about bar code scanners and the bar code scanner pattern, a download code sample, written in C#, demonstrates the use of the pattern and technologies.

PrinterCE for .NetCF - Code Samples

1)Example:Hello World
2)Example:Form Test
3)Example:DrawTextFlow
4)Example:TextColumns
5)Example: Bar Code Test
6)Example:Text Wheel
7)Example:Image Rotation
8)Example:Line Fun

.net code converter

For coverting your programming langugae to another languge the below site is very help full

http://www.developerfusion.com/tools/convert/vb-to-csharp/

Code works on aspx but not ascx

Not sure which category to put this question in, so I will put it in here.

Just to give you an idea of the layout of my solution, I have the main project, along with 2 class libraries, BLL and DAL. (Business Logic Layer and Data Access Layer)

The BLL refers to the DAL and the main project refers to the BLL.

I had a test website and the code worked fine, but the same code will not work on the real project. The only difference is that in the test project, the code was on an aspx code behind, whereas in the real project, it is an ascx code behind (Web User Control )

The code is:

Dim connectionString As String = ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString").ConnectionString
        Dim recordEntry As New UserRecord(connectionString)
        recordEntry.UserName = "TestName"
        recordEntry.BMI = bMI
        recordEntry.BMR = bMR
        recordEntry.FTM = fTM
        recordEntry.TDEE = tDEE
        recordEntry.TodayDate = dateForToday
        recordEntry.InsertRecord()

Dim connectionString As String = ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString").ConnectionString

how to set break point at inline code

I set the element height value by using inline code

<%# Eval("s") %>

where "s" is the variable declared in page load event. when i run the application it don't set the height.

Is there any way, i can set break point into .aspx file. i mean how i can check if my Eval("s") get the value.

how implement this code

check this link

and how can i implement on aspx page to get value on textbox

http://www.acmetech.com/documentation/javascript/parse_magnetic_track_javascript.html

Validator code keeling over

I'm posting in this forum, as it seems the best place for looking at some horrible Javascript! In essence, I'm trying to hook into a RangeValidator on the client side - nothing special, just asking it to revalidate. So, I have this in my VB:

 objDescriptor.AddProperty("DateRangeValidator", rvDateInput.ClientID)

and this in my JS:

// First the constructor
this._DateRangeValidator = null;

//-------------------------------------------------------

// Then the prototype
get_DateRangeValidator: function () {
        return this._DateRangeValidator;
    },

    set_DateRangeValidator: function (value) {
        this._DateRangeValidator = value;
    },

That's no different from many of the other references I am passing around, and which all work. So, I'd expect this:

 ValidatorValidate(this._DateRangeValidator)

to "just work" and re-evaluate the validity - I think! What I am actually seeing is:

function ValidatorUpdateDisplay(val) {
    if (typeof(v

Button specific code

I have 2 submit buttons on my page. Right now, the only way to run the code behind with razor is to to If(IsPost). Since I have 2 buttons, how would I destinguish between the two in post? Is there a way to request a button that sent a post request?

Any plans on releasing the source code for Web Pages Helpers?

Following this thread: Any plans on releasing the source code for WebMatrix itself?

How about those Helpers code?


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All