We use SProcs with Dynamic sorting, by implementing the last parameter passed as the SortBy column. For this we use a select box of available column...
In the DataSet designer, did you place the Param names in consecutive columns or type the statement sirectly in using OR?
quote:Originally posted by kbachelder Thanks for the reply Luis. I just want to know if Visual Studio or some other programming component is...
Greetings, I have a (simple?) question regarding MAC and IP Addresses on SQL 2000. My Initial problem was such: Using a single Application Login I...
jvinoth, I have had similar experiences when accessing SQL server from Access 97 and 2K databases. In the absence of creating an Access Data...
Chili, Try the following code. It can be called using the following syntax: exec sp_test_Dates '01/01/2001', '01/01/2003' (Note the use of...
sabst79, Just another note: ZONE is a ODBC Ketword, and as such, it is not adviseable to use any keywords as Column names or aliases, as it will...
sab, Here's a simple procedure that will do what you need. It can handle unlimited Zones, but you will need to add extra lines for further Status...
Separate names with a comma.
