Recent content by tek2002

I am using linked server to execute an SP on one server from another. It works fine if on server A i am calling the SP on server B from within a stored proc. I get the above error when if on server A i call the SP on server B from within a trigger. Dont know why this call to a SP on another...

I am using linked server to execute an SP on one server from another. It works fine if on server A i am calling the SP on server B from within a stored proc. I get the above error when if on server A i call the SP on server B from within a trigger. Dont know why this call to a SP on another...

Yes, i did give a simplified version :-) Thank you to everyone for thier input - of the lot, the suggestion made by MDXer (dynamic sql)will do the job for me at this time. Thanks Again. In case any one has any better suggestions, here is a bit more detail though still simplified...

There has to be a way to store a datatype in a variable and then use that variable in a conversion/cast. I tried to do it this way but i keep getting this error: "Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '@DATATYPE'." DECLARE @DATATYPE VARCHAR(25) SELECT...

the select stmt actually looks like 'select prog_NAME from tblArea where area = ' somevalue so the opening and closing quotes here is incorrect as i get a different error --> i need to place quotes around the value held in @spParam.....how can i do this programatically? SELECT @SQL_TEXT =...

i have this stored proc that accepts a parameter called @spParam which is of type char(40) and i have a variable called @SQL_TEXT which holds a select stmt 'select prog_NAME from tblArea where area = ' This select stmt btw is stored in a table that i am retrieving in the SP. when i try to...

Thanks so much - i made some changes b/c using vb.net - works great though!

working with a webform that has a radio button list ... when one of the buttons is clicked, i would like a certain action taken without having to use a submit button. does anyone have any code on this or can u point me to where i can find some. for simplicity sake, lets say that you want a...

i created a dts package called Nef_Projects which moves data from an excel file to table1 in BLA database - it works fine when executed. i created a job in sql server agent with step1 deleting data from table1 in BLA database and step2 runs the above DTS package. the problem i am having is...

i am sure that there is a better way but this is what i would do: 1-store the date as char data type 2-add '00:00:00.000' to the value 3-convert the char data type back to datetime you can try this out in query analyzer: declare @date as varchar(12) select @date = getdate() select...

Please Disregard.....I figured it out. Thanks

i have a grid that gets loaded with data from db and i would like to give the user the ability to add a record to the grid. cmdCreateNew_Click event has this line of code that adds a row to the grid just fine: grdPaysched.Rows = grdPaysched.Rows + 1 i however am having dificulty highlighting...

just wanted to post the answer to my question that i found: I basically had an array that i was filling in a vb.net application that worked fine but when i tried using that array in a vb.net web application, it failed b/c the array was emptied each time i posted so the solution was to save my...

OMG - i cant believe that i overlooked that...urrghhh thanks so much -> vbcrlf and chr(13) works perfect if you have textmode property set to multiline. thanks again

Does Not Work. txtOutput.text = &quot;1&quot; & chr(13) & &quot;2&quot; & chr(13) & &quot;3&quot; Produces: 123 for a label, chr(13) translates into a space: 1 2 3 for a label <br> translates into carriage return like u said: 1 2 3 Nothing seems to work for a text box....help