Topics
Started by
Posts
Last post
Hi, I believe the following code is correct. Can anyone say it isn't ? I'd be happy to be prov…
8 replies
I am trying to do a simple insert into a table with an identity field. This is the query I'm …
15 replies
I've got the following table structure, and I need to select the most recent record for each AssetI…
5 replies
Hi all, I am trying to figure out the best way to do this. Basically I have a @wordlist varchar(100…
4 replies
I am trying to convert a T-SQL script to use MySQL and I can't figure out what the MySQL equivalent…
1 replies
I've never used a Cursor or a Trigger before. I have a customer table that I want to assign agent_i…
1 replies
Hi guys, I have built a stored proc which inside has a loop (while begin end) performing insert and…
3 replies
Hi All, I am getting the following error : No TDS_RET_STATUS found for stored procedure output…
4 replies
Hi, I have a question relating to the performance of the query. which one will run faster in the …
3 replies
whats the difference between these two statements: select customerNum ,max(customerName) from #Dril…
4 replies
Hi, I need to sort records by a project number. The project number is varcahr data type and consist…
3 replies
In SQL2K, having generated a stored proc from a template by applying parameters within a generator …
1 replies
Hi All, I have a SELECT statement that has a WHERE statement that I need to be sure is returning th…
6 replies
Is there a way to use a variable for the table name in a from statement? I'm using a cursor t…
2 replies
Hello, I want to insert the result of a select into a table with a primary key. To avoid primary ke…
3 replies
Viewing 15 topics - 7,456 through 7,470 (of 17,082 total)
You must be logged in to create new topics.