Topics
Started by
Posts
Last post
There is always going to be 1 value in the columns a to e, at all times... Format 1 abcde 12 …
2 replies
I have a table with all our databases in it which is truncated and repopulated daily. I need to pu…
1 replies
Hi all, First time, I have dealt with filtering the duplicated records. Please help me to solve it …
5 replies
Hello, It is rare that I have a user for Triggers, but I have a special case. In a table named tbl_…
4 replies
I have a query whose results are as follows: Student Period # of Abs Student1 2A1 Stud…
2 replies
Good day all... I have to pass a table name as a variable to a stored proc, and as far as i know i …
2 replies
I saw this QotD where the answer was TRUNCATE TABLE. Then I read a bit more and was amazed that the…
6 replies
Hi All, I want to pass string value in a stored proc and use it as integer i.e i want to get the da…
5 replies
Hi, In which case @@FETCH_STATUS can be -2. I know SQL Server online book tell when Row fetched is …
2 replies
I need to change this cursor to update accounts to remove the letter 'P' in the prefix. This is the…
3 replies
I have a stored procedure that come off of 2 views. I run each view with the variable and I get da…
2 replies
It's been awhile since I've posted something so I thought I'd dust of my keyboard. I have a query …
5 replies
Hi All, To optimize the performance, we did try to avoid and replace certain CURSORS. To avoid CURS…
5 replies
Hi, I am trying to write an update statement that will concatenate 2 fields and add an incrementing…
3 replies
I have data similar to the following that I am trying to group: EmpID, LocationID, Amount 1, …
11 replies
Viewing 15 topics - 11,356 through 11,370 (of 12,234 total)
You must be logged in to create new topics.