Search results for query: *

Hello, I've got a stored procedure that builds a dynamic SQL satement and then assigns it to a varchar variable. I would like to know if if's possible to declare a variable from within a select statement. I keep getting the 'Incorrect syntax near the keyword Declare' error. For example...

Hello, I would like to know if if's possible to declare a variable from within a select statement. I keep getting the 'Incorrect syntax near the keyword Declare' error. For example: SELECT A.test1, A.test2, (DECLARE @tmp INT SELECT @tmp = (SELECT B.test3 FROM B) CASE WHEN @tmp <> 0 THEN @tmp...

Hello, I'm hoping someone can help me. I've got a web page that creates an excel file client side and saves it to the client's temp folder. The page then displays a hyperlink (File://...) to that file. Before SP2 there were no problems, the file would open normally, but now even though the...

Hi, Does anyone know how to force a form to the front, but only within the calling application (hopefully using the SetWindowPos API)? I have a form that is displayed showing a progress indicator (therefore I don't want the form shown modally, which would halt program execution). I want the...

Hello, I'm hoping somebody can help me out. I'm using the double click event of an MSHFLEXGRID to sort a column selected by the user. I have multiple columns with different data types (dates, integers, strings). The problem is that whatever sort property I choose, it doesn't sort all data...