Topics
Started by
Posts
Last post
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
I'm having trouble using an If statement and checking to see if my boolean parameter is true in my …
2 replies
Hi, I'm having some issues with renaming my table. I actually have some code in a SSIS package and …
4 replies
Hi I'm just trying to understand if...else statements. For instance can I use and if statement to …
5 replies
Is there any easy way to have a join merge several rows into one row containing - eg. - a comma-del…
7 replies
Viewing 15 topics - 11,356 through 11,370 (of 12,230 total)
You must be logged in to create new topics.