some code that can be used in DTS package to check if a file exists:

Function Main()

Dim objFSO

Dim cFilePath

Dim cFileName

cFilePath = "<file path>"

cFileName = "<file name>"

 -- instantiate the Scripting Object

  set...

CREATE PROCEDURE Z_Billing_Payment

(@GetWhat as Varchar(15),

@PaymentID as int)

--set @GetWhat = 'something'

--set @PaymentID = 1

as

Declare @SQL VarChar(1000)

SET @SQL = 'SELECT '+@GetWhat+' From Payments Where PaymentID = '

+cast(@PaymentID as varchar (10))

--PRINT @SQL

Exec...

select convert(varchar,cast('2003-01-08 00:00:00'as datetime),103)

a

New to this this forum so dont know if this is appropriate to ask for email addresses but I have a great document about SQL injection attacks in SQL Server and...

Beth

What exactly do you mean by creating relationships between tables in T-SQL ?

When you write any T-SQL you can relate tables together using join syntax - post what you would...

when you insert the new batch instead of setting the

GL_Control=0

set it to = 1 then others will sequentially be in the correct order

otherwise you could

Update Yourtable

set GL_Control= GL_Control +...

I agree with a previous reply that you can set the ansi nulls on either before or after the creat proc statement.

One point though - if the correct answer SP...