See this thread.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110745

Hi,

If you are using xlsx file in DTS are you getting any error?

You can change xlsx file in xls also use save option in Excel.

Hi Murli,

You can use EXCEPT here.

DECLARE @TABLEA AS TABLE (account CHAR(8), HCS_Code CHAR(4))

DECLARE @TABLEB AS TABLE (account CHAR(8), HCS_Code CHAR(4))

INSERT INTO @TABLEA

SELECT 'AC_1234', 'ICP1'

UNION ALL SELECT 'AC_1235', 'ICP2'

UNION ALL SELECT...

Hi,

Some simple example of REPLACE:

SELECT REPLACE('SQL Server Central','Server')

SELECT REPLACE(FieldName,'ABC','PQR') AS 'Result' FROM TableName

WHERE

FieldName IS NOT NULL

Hi,

In SQL Server we have ISNULL function.

You can write your query as below:

SELECT ISNULL(FieldName,'XYZ') AS 'Result' FROM TableName

Hi,

See this thread.

http://stackoverflow.com/questions/2007857/reading-a-text-file-with-sql-server

Hi,

What is the objective to write while loop here?

Can you elaborate it little bit more?

Hi,

Can you explain your desired output?

Hi,

It seems role issue on user.

Check your any other script revoking role on this user.

Hi,

If you want to write function then you need to do small changes in T-SQL.

CREATE FUNCTION [dbo].[Total]

(

@Amt INT

)

RETURNS INT

AS

BEGIN

DECLARE @TSUM INT

SELECT @TSUM = SUM(@Amt)

RETURN @TSUM

END

Hi,

Perhaps some of your queries making lock on table.

Run SP_LOCK and check lock status of your database.

Run SQL Profiler and enable 1222 deadlock trace.

Hi

Check this link.

http://www.sqlservercentral.com/Forums/Topic475278-338-1.aspx#bm477297

Thanks

Shatrughna

Hi,

See this thread.

http://blog.sqlauthority.com/2010/02/24/sql-server-introduction-to-rollup-clause/

Thanks

Shatrughna

Hi,

Please post your T-SQL here.

It will better to understand.

Thanks

Shatrughna

Hi,

You can do it by dynamic SQL statement.

Search Google for Dynamic SQL statement.

Thanks

Shatrughna