Programming SQL

Help With Calculated Value
In the below I need to calculate (TransactionHistory.Quantity * TransactionHistory.CostValue) AS ExtendedCost WHERE TransactionHistory.TransactionTypeID=15 AND (TransactionHistory.Quantity * TransactionHistory.CostValue*-1) AS ExtendedCost WHERE TransactionHistory.TransactionTypeID=16. How would I put this t... 11 Jul 2008 16:08

Synonyms
I've got code running from one particular database on a server. I want it to refer to tables in another database on the same server, and maybe another database on another server. Do I need to create the synonyms in the Master database, or in the database where the code is? ... 11 Jul 2008 14:04

What is wrong with this T-SQL?
Am getting 'bad syntax near 'IF' ??? IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name = 'dbo.Vw_ChildNotDenied') BEGIN DROP VIEW dbo.Vw_ChildNotDenied IF @@Error = 0 PRINT 'DELETED View dbo.Vw_ChildNotDenied' END GO IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name = 'dbo.V... 12 Jul 2008 13:35

select earliest date
How can I do this from four dates in each record? ... 11 Jul 2008 13:02

SQL Server 2000 access...
I have a table in my SQL Server 2000 database that I do not want to allow any rows being deleted from. So, I simply right clicked the table in enterprise manager, clicked permissions, then placed an "X" beside all of the users listed there under the "Delete" heading. Then I logged in as one of those users, ran... 11 Jul 2008 16:08

process locking with row existence
I need opinions and suggestions on how to accomplish the following: Two users of my application that do not have communication to each other start the same process simultaneously. I need to stop the second process from occurring. The app calls a stored proc. My current idea is to create a "lock" table. The f... 13 Jul 2008 14:06

Result of table 1 into column table 2 via Stored Procedure
Hello, I'm creating a stored procedure which needs to store the result of a query on table 1 into a text field column in table. Let's say, table 1 contains: Col1 Col2 ---- ----- A 1 B 2 C 3 I have a query which returns the concatenation of the 2 cols: A1 B2 C3 = 3 rows My s... 14 Jul 2008 08:32

GMT date/time handling
I will be using SQL server 2008. If I have users accessing the system via web page then I don't want to always use their local date/time. Instead I will use the GMT date/time. So let's say that I use GETUTCDATE() to capture the GMT date/time. 1. How do I convert this to my local date/time? 2. How do I convert th... 11 Jul 2008 10:58

variable in query analyzer
Is it possible to declare a variable in QA and run like few statement at a time. I know this can be done via SP but just wondering if this can be done with QA e.g select * from tableA where COLA = 'this is where I always pass same value' select * from tableB where COLG = 'this is where I always pass same value... 11 Jul 2008 10:58

A strange SQL server problem
I was going through a database and modifying a stored proc. when i opened the stored proc using sp_helptext then it displayed the body of stored proc in which the name of stored proc was different for e.g. sp_helptext testProc gave create proc testDiffProc ------------- when i looked up in sysobjects th... 11 Jul 2008 09:56