Hi

I hope you got the answer but i would like to give you basic information.

Select TableA.*, (Select sum(acres) from p_acres where p_acres.id = TableA.acre_id) As TAcres from TableA Where TAcres...

Hi,

You can even try out in this way

theprevmonth = UCase(MonthName(Month(DateAdd("m", -1, dtsglobalvariables("TodaysDate"))), True))

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

You can use some tools to compare the tables/schemas/databases but how would you compare the data in those tables? If databases are really then !!..

But first of all why one...

Hi

The UPDATE statement is used to modify the data in a table.

If you want to update all the records then simply dont use any WHERE condition.

ex:

UPDATE EMP

SET SALARY =...

Hi

This is anotherway to do the deletes.

DELETE FROM tblname t1 WHERE t1.type = 0 AND EXISTS (SELECT 1 FROM tblName t2 WHERE t2.Type = 1 and t2.nme = t1.name)

Thanks --...

Its nice one.

Thanks -- Vj

Hi,

Noramlly people convert he views to stored procedurs but here the case is bit opposite.

May i know what is it your trying to address?

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi Buddy,

Please post your questions, are you expecting us to Post Questions your criteria :P:D

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

In simnple way you can write queries with the Group by Clause and CASE statements.

SELECT c.fk_customerid,

...

Hi,

Why do you want to do that? If something is available in SQL server to generate the numbers then why do you want to build your own? Is there any...

Hi,

In Nutshell Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table.

Index Scan:

Since a scan touches every row in the table whether or...

Hi,

Yes you can have One Compiste index. But as i understand by the definion of LookUp table, Look Up tables are generelly very small. If it is small table then...

Hi,

The simplest would be by using PIVOT function, as i undestand in general scenario there will n.Of employees for a given company. So its pretty hard write a query like...

Hi,

Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows...

Hi,

few inputs, now you need to think about what are the data access patterns. prepare good documention around database. then move on to the front end code and test the...