Search results for query: *

I tried a clustered index....didn't seem to help.... DECLARE @RecordID bigint DECLARE @Hi varchar(2) DECLARE @Bye varchar(2) DROP TABLE Central.DBO.TempRecordCompInfo CREATE TABLE Central.DBO.TempRecordCompInfo ( [RECORD_ID] [bigint] NOT NULL , [Hi] [varchar] (2) COLLATE...

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...

Don't know why I didn't see that until you said that. I think I included every other reference but that one.... Thanks!

What references do you have to include in order to get this to work? Thanks....

Nevermind....figured it out. thread216-614818

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...

Any help? Thanks!

Create an intermediary field. UPDATE MyTable SET MyNewField = CAST(myFloat as varchar(x)) ???

Ok, apparently it didn't like my formatting. 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}

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...

Ok, I figured something out.

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...

Well, thanks for the help. Guess I'll just have to go through my SPs one at a time and hope that I documented when I changed things well :)

Even Access stores modified dates. Well, just leave it to Microsoft to come up short.

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?

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!

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!