The solution for such problems is obtained by using the aggreggate functions.

The required results can be obtainted by writing the query as below:

select id,total=sum(a+b,c)  from table group by id

There are different ways which you can use to delete duplicate values from a table.

If the data in your table is not huge .You could use the steps discussed in...

Control-M batch scheduler is a enterprise batch management solution that is used to run and mantain external jobs .

This is a product developed by BMC Software .

alternatively u can use the substring function to get the strings

Hi Amie,

You can restrict the columns available to the user by granting select permissions only on the column of the view to the user.

E.g.

Grant select on xyzview(empid,empname) to abcuser

Hope this...

I dont there should be any problem for you getting the resultset .

Sample query ....

select * from emp e (nolock)

inner join room b (nolock) on

e.emproomno=b.roomno inner join

device d...

This can be done but the query generated will be dynamic and has to be exceuted using the Execute Command

for eg:

if you want to retrieve the count from a...

Iam afraid any such solution is inbuilt in SQL server.

I would suggest that you can create a User defined function for encrypting and decrypting the data .

Very Simple Just change the Statement from

IF @intGWFSSeqNbr = NULL

To 

IF @intGWFSSeqNbr IS  NULL

This will work for you.

Do let me know if you have any further queries

Yeah I totally agree with SQL does things better than what Oracle does.My article is aimed at novice SQL developers who can find the script very convinent in situations wherein...

SQL doesnot allow you to use derived column names in the where clause.

You will have to repeat the formula in the where clause

Can you please let me know what information you are looking into.

If you need the column information for a table you can obtain the same from the SYSCOLUMNS system table.

You...

I believe leaving the connection object open till the end is a good idea.

Once all the processes is done set connection to nothing so that the connection is destroyed .

Hi ,

The solution for your problem could be obtainted by the query below :

select a.id ,a.first_name from

table2 a

where

a.result='fail'

and a.id not in (select id from

table2 where id=a.id and...

It would always be beneficial to use stored procedures.

In case when you have two databases A and B residing on the same server.

Lets consider we have Employee table on Database...