Check the response from GilaMonster and post the ready to consume DDL and DML scripts....

sorry..not done intentionally..because of slow system response, i would have clicked 3 times and hence 3 replies....is this the problem with this application?

check if you are looking for this..

USE TEMPDB

GO

declare @hash varbinary (255)

CREATE TABLE tempdb..h (id_num int, hash varbinary (255))

SET @hash = pwdencrypt('123') -- encryption

INSERT INTO tempdb..h (id_num,hash) VALUES (1,@hash)

SET @hash =...

check if you are looking for this..

USE TEMPDB

GO

declare @hash varbinary (255)

CREATE TABLE tempdb..h (id_num int, hash varbinary (255))

SET @hash = pwdencrypt('123') -- encryption

INSERT INTO tempdb..h (id_num,hash) VALUES (1,@hash)

SET @hash =...

check if you are looking for this..

USE TEMPDB

GO

declare @hash varbinary (255)

CREATE TABLE tempdb..h (id_num int, hash varbinary (255))

SET @hash = pwdencrypt('123') -- encryption

INSERT INTO tempdb..h (id_num,hash) VALUES (1,@hash)

SET @hash =...

try with Left join and group by....

Redundant Post...

why dont you continue in the old post...same query again..

http://www.sqlservercentral.com/Forums/Topic826786-338-1.aspx

try this..

BULK INSERT testtbl

FROM 'f:\orders\lineitem.txt'

WITH

(

FIELDTERMINATOR =' |',

...

Was busy in one production issue. sorry for the late reply. Thanks all for replies...

Thanks Jeff for your clue on xp_DirTree..It really helps....

Instead, You can use bulk insert to load files, if you are not comfortable with SSIS.

Check if the below code helps you.

Create procedure usp_ImportMultipleFiles @filepath varchar(500),

@pattern varchar(100), @TableName varchar(128)

as

set...

Two things..

1) DMV Not working...

I have copied and pasted your code in Query window and it executed successfully. may you...

For getting faster response, please post readily consumable sample script.

for now i have created a table with dummy data and calling the calculated price column at multiple places in the...

Alter the trigger to work only for Insert (remove update).

Change for Insert, update to for Insert.

You create another trigger for update if you want any other transaction to happen on...

Instead...

to make the code work with varchar variable..

you can change the code

from

EXECUTE sp_executesql @SSQL

to

Exec(@SSQL)

--Jus