Search results for query: *

I have a table that I read. The table is indexed by the columns that I want to sort by (and in the same directions). I need to pick the Top 1 row from the table given certain criteria. If I do it without the ORDER BY clause, my code runs in less than a minute. If I include the ORDER BY, it...

I have <td><span style=&quot;font-size:10pt;fontweight:bold;&quot;>Sold</span></td> <td><input id=&quot;Sold&quot; type=&quot;radio&quot; name=&quot;Sold&quot; Checked Value=&quot;1&quot;>Yes <input id=&quot;Sold&quot; type=&quot;radio&quot; name=&quot;Sold&quot; Value=&quot;0&quot;>No...

I've basically coded one huge mess of stored procedures, but that is beside the point. Here is how it is set up. MAIN_SP SUB_SP_1 SUB_SP_A SUB_SP_2 SUB_SP_3 SUB_SP_4 {List of SELECT statements for return to web interface} A stored procedure that is indented is called by the one a...

Whenever I use a </form> tag, it seems to put in white space on the page. If I take it out, the white space disappears. I'd move the tag further down the page, but I have a separate <form> starting almost immediately after I close this one. Is there any way to keep this white space from...

In EM, is there a way to show the ModifiedDate of an object instead of the CreateDate? Or is there an easy way to get that information for all the tables/objects with some sort of query?

Is there a system stored procedure that you can pass the name of a DTS package to as a parameter that will execute that DTS package? If so, what SP is it? Thanks!

Is there a system stored procedure that you can pass the name of a DTS package to as a parameter that will execute that DTS package? If so, what SP is it? Thanks!