Search results for query: *

Hi, hope someone can help with this! My small team supports several organisations on one Exchange 5.5 server. As the result of a name change, I need to change the "Company" field for a sub-set of users. Even though it's a sub-set there are still 400 accounts so I really don't want...

Thanks Nick. I could come back to the same page but with request("varname") populated, maybe? I was hoping for a solution where "onblur" calls a javascript function that itself invokes an MS-SQL stored proc and uses the returned value to pre-poulate the input box using...

As a learning exercise I'm writing a small application but I've hit a small problem and I'd like some help. I have a form. On the form is a selection box. When the user selects one of the options the cursor moves onto the next input box. The bit that's missing is the bit that pre-populates...

Hi. That's a lot of questions. SQL is "Structured Query Language" and it is used to query a database. It's a little like a programming language but it is very specialised. An SQL Server is a server running a database management system (or database engine) that responds to SQL...

You're right.&nbsp;&nbsp;I did say it was an easy solution!<br><br>You need a more sophisticated approach if what you describe is possible.&nbsp;&nbsp;Do you need to know which records were affected every time this update is run or do you just need to know periodically?&nbsp;&nbsp;What will you...

An easy solution would be to add an attribute, say &quot;marker&quot; (bit).&nbsp;&nbsp;You then modify your UPDATE statement to set the marker to 1 as well.&nbsp;&nbsp;When you've finished whatever you need the marker for, set it back to 0, ready for the next time.<br><br>UPDATE TIDS <br>SET...

You could always pass each fam_id as a separate parameter but this would be more work than necessary and you'd be limited to 1024 fam_ids!&nbsp;&nbsp;<br><br>Another option would be send the string as a parameter and then use string functions to break it into individual components within the SP...

You can almost do exactly as you ask:<br><br>CREATE PROC sp_test<br>&nbsp;&nbsp;&nbsp;@Orderby VARCHAR(30)<br>AS<br>&nbsp;&nbsp;&nbsp;DECLARE @CommandText VARCHAR(100)<br>&nbsp;&nbsp;&nbsp;@CommandText = 'SELECT * FROM test ORDER BY ' + @Orderby<br>&nbsp;&nbsp;&nbsp;EXEC...

Shirley, a select statement may be the answer you're looking for if you simply want to know if the key is booked out or not.<br><br>SELECT COUNT(*) FROM KeyLogOutTable WHERE KeyNumber = 123 AND SiteNumber = 56 AND ReturnedDate IS NULL<br><br>This statement will return 1 if the key is out, 0...

Hi Nancy, you've got us all curious with this one!<br><br>Another thought, are there any triggers on this table that may be running off and doing all kinds of things every time you insert a record, perhaps coming back to the spcl table?<br>

I'm still unsure of what you're trying to achieve.<br><br>The final comment in your last message seems to imply that you're trying to change the name of a column in a table.&nbsp;&nbsp;If this is the case then I'm unaware of any way of doing this other than rebuilding the table.<br><br>If you're...

I should've taken more notice of your subject.<br><br>I don't have access to SQL server to tell you what you're doing wrong but I can offer this:<br><br>Try<br><br>DECLARE @Command VARCHAR(100)<br>SET @Command = 'UPDATE table SET ' + @str1 + @str2 + ' = &quot;001&quot;'<br>EXEC (@Command)

What are you trying to do joblue?

Rahel, when you say your client can &quot;see&quot; tables do you mean that you can see that the tables are there or do you mean that you can see the data within the tables?

Ian, I'm unsure of why you need to reindex.<br><br>Can you not just SELECT &lt;fields&gt; ORDER BY &lt;field&gt;?<br><br>You could also try reducing the number of fields in your table.&nbsp;&nbsp;For only 100,000 records though the performance increase may be minimal unless your table is very...

That's all for your comments.<br><br>Cal, special thanks for the extra info on where things sit DURING and on RETURN.

Point noted Eduard.<br><br>I meant more natural as a statement, maybe I'm showing a little bias &lt;g&gt;.

The SQL Server version is easier...<br><br>SELECT TOP 50 A, B, C ....

When writing VB6 code to use stored proceedures on the server, is the result of the select (within the SP) stored on the server or passed to the client?

Doug, there are several ways you could do this but have you considered replication?&nbsp;&nbsp;Replication is all about what you want to do here - keeping two databases (or parts of them) synchronised.&nbsp;&nbsp;You can do this in real time or, and I suspect this is what you need, in snapshot...