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

More Search Options

RSS Available

• Re: using column values to calculate other columns in sql

  I am not really sure waht you meant by the value in the first column but this might help. The idea is to calculate the total in the repayments table and inner join the applicaiton table. Instead of hardcoding application_id_int there is a variable for it. SELECT c.claimant_id_int as 'Claimant', a.application_id_int as 'App ID', a.application_date as Date, c.office_no_int as Office, a.application_type_id_int as Type, amount_requested_dec as Requested, amount_awarded_dec as Awarded

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by FileFoundException on 11/24/2009

• Re: Talk to sun solaris OS application from ASP.Net application

  Interesting. I remember facing something similar to this. At a mixed enivornment (Unix + Windows), we had to copy files from Windows directories to Unix shared directories using ASP.NET 2.0. We faced many restrictions because of both security policies and techonlogy limitations (we could not hardcode creditionals; we face the like of double-hop authenticaiton problem). I proposed (and coded a proof of concept) a Windows Service that listens to commands issued from within the ASP.NET web app and that

  Posted to Web Forms (Forum) by FileFoundException on 11/24/2009
  Filed under: ASP.net unix

• Re: IIf condition problem

  That's right, my syntax was mix of C# and VB.NET. Use darsho syntax. At any rate, it's just a simple division; not rocket science.

  Posted to SQL Server Reporting Services (Forum) by FileFoundException on 11/12/2009

• Re: IIf condition problem

  There was a similar post about this very similar problem which I could find now. But IIF is a function and it invokes the exression ( b/a in this case ) no matter whether a > 0 is true or false " Because the IIf function does not use short-circuit evaluation, it always evaluates all three of its arguments. The If operator evaluates its first argument and, depending on the value of the first argument, either the second or the third argument. In the following example, using the IIf function

  Posted to SQL Server Reporting Services (Forum) by FileFoundException on 11/11/2009
  Filed under: IIF function

• Re: Custom Code Help

  I haven't done this myself, so I am guessing here. When you compile your project, you produce an assembly (.exe or .dll), right? Add that assembly reference to your report. You probably should have the logic in a static method in your project and call that static method from your report; instead of of trying to create an instance of your TableAdapter inside the report.

  Posted to SQL Server Reporting Services (Forum) by FileFoundException on 11/11/2009

• Re: Custom Code Help

  Are you added a reference to your assembly? To do that go to report properties -> Referneces : add the assembly reference in the References section, create an instance from your class in the classes section. See this http://msdn.microsoft.com/en-us/library/ms252130.aspx and these for more http://msdn.microsoft.com/en-us/library/ms155798.aspx http://msdn.microsoft.com/en-us/library/ms154507.aspx

  Posted to SQL Server Reporting Services (Forum) by FileFoundException on 11/5/2009

• Re: SSIS Package giving Error

  A single excel sheet (2003 for sure) cannot have more than 2^16 rows (65536).

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by FileFoundException on 10/6/2009

• Generate Database Scripts using PowerShell

  Using windows powershell you can generate scripts for a database and its objects http://www.mssqltips.com/tip.asp?tip=1842&home here is a snippet from the article [System.Reflection.Assembly] :: LoadWithPartialName ( 'Microsoft.SqlServer.SMO') | out-null $s = new - object ( 'Microsoft.SqlServer.Management.Smo.Server') "LOCALHOST\SQL2005_1" $dbs = $s.Databases $dbs["Northwind"].Script ()

  Posted to Tips & Tricks (Forum) by FileFoundException on 10/6/2009
  Filed under: generate scripts, powershell

• Re: Double Hop, Delegation Help

  A while ago I did some research for this same problem and here are some links I found useful How To: Use Protocol Transition and Constrained Delegation in ASP.NET 2.0 http://msdn.microsoft.com/en-us/library/ms998355.aspx How To: Create a Service Account for an ASP.NET 2.0 Application http://msdn.microsoft.com/en-us/library/ms998297.aspx How To: Connect to SQL Server Using Windows Authentication in ASP.NET 2.0 http://msdn.microsoft.com/en-us/library/ms998292.aspx Double Hop and ASP.NET - a workaround

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by FileFoundException on 9/28/2009

• Re: Filtering one dataset based on another

  [quote user="kj27"]Query Builder always adds quotes around the parameter names[/quote] I don't use query builder; not sure why it'd do that. try going to the non-query builder mode and edit the query.

  Posted to SQL Server Reporting Services (Forum) by FileFoundException on 9/24/2009