Programming SQL

Stored Proc Help...
Here is what I have so far.... set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go CREATE PROCEDURE [dbo].[type_check2] @name VARCHAR(30), @result VARCHAR(3) OUTPUT AS DECLARE @namecount int BEGIN SET NOCOUNT ON; SELECT @namecount = count(*) FROM dbo.warehousetype WHERE name =... 7 Jul 2008 16:38

best datatype
Hi all, I need to upload a file that has columns as below: Emp ... 8 Jul 2008 13:07

Restricting output of view to eliminate rows having duplicate part
Hi, I got the output from a view as following: Part# Project# ModDate Status 100-1 100A 01/10/08 A 150-2 200B 02/10/08 A 100-1 199K 02/10/08 A 100-1 198P 03/09/08 A 200-4 100T 04/12/08 A 200-4 100M 03/01/08 A The above view is created by joi... 7 Jul 2008 16:38

Stored Proc Help...
Here is what I have so far.... set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go CREATE PROCEDURE [dbo].[type_check2] @name VARCHAR(30), @result VARCHAR(3) OUTPUT AS DECLARE @namecount int BEGIN SET NOCOUNT ON; SELECT @namecount = count(*) FROM dbo.warehousetype WHERE name =... 7 Jul 2008 16:38

Convert VB function to SQL function
I have to convert VB function to SQL: Function CalcCompItem() Dim mValue1 Dim mValue2 Dim CompValue,CompPerc Select Case int(sCPExt) Case 0 mValue1 = rs("Tickets") Case 1 mValue1 = rs("ExtFee1") Case 2 mValue1 = rs("ExtFee2") Case 3 mValue1 = rs("ExtFee3") End Select Select Ca... 8 Jul 2008 06:57

Importing whole txt file into a table
I have a sql table called FileInfo, which consists of two columns, filename and File. FileName is the name of file to be uploaded, and File is the content of the files to be uploaded. The file is located in c:\Files. I need to create a script to pupulate the name of the file and the file content into the ta... 8 Jul 2008 05:55

Text file output encryptioon
I have a table can MemberSSN, which consists of MemberID and SSN. I want to generates a list of of all MemberID and their SSN, to a files called MemberSSN and ouput to C:\. I have an encryption key called Company.asc stored in C:\encryption, and I want to encrypt the output with this encryption key and put... 7 Jul 2008 17:40

CLR proc that access a COM object
I need to access a COM object (C++) from a stored proc. the interface is too complicated for SQL (using sp_OACreate and the like) so i thought i would write a .net proc as a wrapper for the COM object. I don't see how to add a reference to the COM object. When i try to add a reference to the COM dll the only thi... 8 Jul 2008 17:13

Subtracting dates to get times
I have an enddate and a startdate for a process and I want to subtract the start from the end to get the duration but I only need hours, minutes and seconds, not the date part. How do I display only the time? Thanks. Darlene ... 7 Jul 2008 22:47

CTE syntax error problem....
Hi all, I'm new to the CTE thing, and I'm wondering why the following stripped down example generates a syntax error ("near 'if'): ;with SearchSpace( myfield ) as ( -- something complicated ) if select count(myfield) from SearchSpace != 0 begin -- do something interesting end else begin ... 9 Jul 2008 13:43