Topics
Started by
Posts
Last post
[font="Courier New"] I have data in a table ManagerGoals EventID EEID CustValue 107 …
3 replies
Hi all, I have a table with Three coloumns. Path,ID,Filename DECLARE @A TABLE( Path VARCHAR(M…
3 replies
Can someone give me some support in migrating this to SQL Server? The Req_Fin_Priorities are numeri…
2 replies
Any ideas?... I have a trigger (not working obviously) set up that decrements from my [tblBulkPurch…
45 replies
Hi, I know I that, when using UPDATEABLE VIEWS, INSERT statements are not allowed if a member table…
14 replies
Hey guys, I have been working on the books "SQL Server 2005 Recipes" and "Transact SQL Cookbook". I…
2 replies
Hello, For SQL 2k5, 2K8 and 2K8R2, I need a T-SQL query to get all the users listed in: SSMS => …
6 replies
Hello, I have the following query that returns 2 rows and I would like to have the results in 1 row…
2 replies
Below is some sample ddl and data. Each row represents an item that is on rent between a period of …
3 replies
Hi, I am running an update to a large number of rows on a table in a database which has a snapshot.…
2 replies
CREATE PROCEDURE usp_update @pcid int ,@ppid int ,@ptid int ,@pqty int AS BEGIN SET NOCOUNT ON; DEC…
20 replies
I have 2 columns in the database. The value in column 1 is 10000000. The value in column 2 is 987…
15 replies
I want to select a field that has a value of 0 or 1. I want to select that field but have it print…
3 replies
Hi All, I'm trying to set up a view that will allow me to re-organise and existing table for the pu…
9 replies
Just curious: is it possible to perform a UNION between two stored procedure executions (that both …
3 replies
Viewing 15 topics - 4,936 through 4,950 (of 10,638 total)
You must be logged in to create new topics.