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://qa.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

check if this works for you.........changed your code a bit to make it work..

drop table languages

drop table daytime

create table languages (id int, name varchar(20))

insert into languages select...

Can you post sample data along with...

For testing, I have tried with following variables and works fine.

declare @o_bal decimal(10,3)

declare @Outstanding_Bal decimal(10,3)

declare @P_Amount decimal(10,3)

set @o_bal=10

set @Outstanding_Bal = 5

set @P_Amount = 5.5

SELECT...