User Profile

Collapse

Profile Sidebar

Collapse
gpsharma
gpsharma
Last Activity: Nov 4 '10, 07:10 PM
Joined: Jul 9 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gpsharma
    started a topic Parameter in select statement
    in SQL Server

    Parameter in select statement

    Hi,

    I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement.


    Following query working fine.

    Code:
    BEGIN
DECLARE @strQuery NVARCHAR(MAX)
DECLARE @CountryId INT
DECLARE @CityId INT

SET @CountryId = 2
SET @CityId = ' AND CityId IN (23,45,85,86)'

SELECT @strQuery= 'SELECT VendorId
    ...
    See more | Go to post
    Last edited by NeoPa; Oct 5 '10, 03:52 PM. Reason: Please use the [CODE] tags provided.
    • gpsharma
      started a topic Httphandler not working in Windows Server 2003 R2
      in .NET

      Httphandler not working in Windows Server 2003 R2

      Hi,

      Im using a httphandler to response another pdf file in case requested file not found. Its working fine in local development pc but not working in web server. Mapped .pdf as wild card mapping too but no result yet. Still i'm getting the 404 error.

      Please help. Its very very urgent.
      See more | Go to post
      No activity results to display
      Show More
      Working...