You searched for the word(s): userid:795226

More Search Options

RSS Available

• Need help in resolving Dynamic Query Error: Is Not a Valid Identifier

  Good day Experts, I am doing dynamic sql in my stored procedure. set @ledgersql = N 'select accountnum as [' + @Accountnumber + '], accountname as [' + @Accountname + '], SUM(CASE WHEN periodstart = convert(datetime,substring(' + @June + ',1,10),120) THEN total else 0 END) AS [' + @June + '] ,SUM(CASE WHEN periodstart = convert(datetime,substring(' + @July + ',1,10),120) THEN total else 0 END) AS [' + @July + ']' ; set @ledgersql = @ledgersql

  Posted to Getting Started (Forum) by kalyan1982 on 1/30/2009

• Re: Need help in writing a sql query

  Good day Experts, I need help in writing a sql query for the below scenerio. Description: Two tables Table1 and Table2 Table1: RECID ACCOUNTNUMBER ACCOUNTNAME ACCOUNTTYPE AREAID Table2: RECID ACCRECID AREAID FROMACCOUNT TOACCOUNT My select query looks like as below. Select t1.ACCOUNTNUMBER,t1.ACCOUNTNAME,t2.FROMACCOUNT,t2.TOACCOUNT From Table1 t1,Table2 t2 where t1.accounttype = 10 and t1.areadid = 1 and t1.areaid = t2.areaid and t1.recid = t2.Accrecid From the result of the above query I need to

  Posted to Getting Started (Forum) by kalyan1982 on 1/27/2009

• Help with Alias names in sql

  Good day Experts, I need help with alis names in sql. Declare @Date as datetime set @Date = GetDate() Select a,b,c,d as @date from table1 I am trying to use @Date value s alias name to column d in table1. Any help would be appreciated. Thanks in advance.

  Posted to Getting Started (Forum) by kalyan1982 on 1/27/2009

• Need help in writing a sql query

  Good day Experts, I need help in writing a sql query for the below scenerio. Description: Two tables Table1 and Table2 Table1: RECID ACCOUNTNUMBER ACCOUNTNAME ACCOUNTTYPE AREAID Table2: RECID ACCRECID AREAID FROMACCOUNT TOACCOUNT My select query looks like as below. Select t1.ACCOUNTNUMBER,t1.ACCOUNTNAME,t2.FROMACCOUNT,t2.TOACCOUNT From Table1 t1,Table2 t2 where t1.accounttype = 10 and t1.areadid = 1 and t1.areaid = t2.areaid and t1.recid = t2.Accrecid From the result of the above query I need to

  Posted to Getting Started (Forum) by kalyan1982 on 1/27/2009

• Re: Need help in writing a sql query

  Hi Jef, Thanks for responding. As described in my previous post, I ll have to pass two date parameters in which one is Start date and the another one is the end date. The starting date will always be the 1st June and the the last date will always be 31st May, but the years may differ. May be using a for loop, I need to dsplay my result set like as below. 2008-06-01 - 2008-06-30 2008-07-01 - 2008-07-31 . and so on till 2009-05-01 - 2009-05-31 It should give me start date and end date of each month

  Posted to Getting Started (Forum) by kalyan1982 on 1/22/2009

• Need help in writing a sql query

  Good day Experts, I need help in writing a sql query. Scenerio: I would be passing two date like below: @date1 --'2008-06-01 00:00:00.000' @date2 --'2009-05-31 00:00:00.000' My result set should look like as below: 2008-06-01 00:00:00:000 - 2008-06-30 00:00:00:000 2008-07-01 00:00:00:000 - 2008-07-31 00:00:00:000 . and so on till 2009-05-01 00:00:00:000 - 2009-05-31 00:00:00:000 Any help would be much appreciated.

  Posted to Getting Started (Forum) by kalyan1982 on 1/22/2009

• Re: DES Encryption/Decryption

  Hi there, The below class might help you solve your problem. Imports Microsoft.VisualBasic Imports System Imports System.IO Imports System.Xml Imports System.Text Imports System.Security.Cryptography Public Class EncryptDecrypt Private lbtVector() As Byte = {240, 3, 45, 29, 0, 76, 173, 59} Private lscryptoKey As String = "ChangeThis!" Public Function psDecrypt( ByVal sQueryString As String ) As String Dim buffer() As Byte Dim loCryptoClass As New TripleDESCryptoServiceProvider Dim loCryptoProvider

  Posted to Security (Forum) by kalyan1982 on 12/30/2008

• Re: Adding attachment to mail

  Hi there, Sending a email with an attachment using ASP.NET 2.0 and C# is actually very simple. First, you will need to import the System.Net.Mail namespace. The System.Net.Mail namespace contains the SmtpClient and MailMessage Classes that we need in order to send the email and the message attachment. using System.Net.Mail; We use the btnSubmit_Click event to do the work. We then call the emailClient.Send to send the message using the variables from our ASP.NET coded page. The txtAttachmentPath.Text

  Posted to Getting Started (Forum) by kalyan1982 on 12/19/2008

• Re: Cache expiration

  Hi there, Try the below code. Hope that helps. Try Dim entry As DictionaryEntry For Each entry In System.Web.HttpContext.Current.Cache System.Web.HttpContext.Current.Cache.Remove(entry.Key) Next lblMsg.Text = "Cache is cleared!" Catch ex As Exception lblMsg.Text = "Cache is not cleared!" End Try

  Posted to Getting Started (Forum) by kalyan1982 on 12/10/2008

• Re: Encrypting/Decrypting for URL

  Hi there, The below class will help you do the encryption and decryption of a string value passed. Hope this helps. Imports Microsoft.VisualBasic Imports System Imports System.IO Imports System.Xml Imports System.Text Imports System.Security.Cryptography Public Class EncryptDecrypt Private lbtVector() As Byte = {240, 3, 45, 29, 0, 76, 173, 59} Private lscryptoKey As String = "ChangeThis!" Public Function psDecrypt( ByVal sQueryString As String ) As String Dim buffer() As Byte Dim loCryptoClass

  Posted to Web Forms (Forum) by kalyan1982 on 12/10/2008