Indeed Ramma, a difficult situation , but I was just wondering if u had a network problem.... but I suppose you may know (your problem) better...

.... any time.

Do you need to temporarily keep a dataset came by a query?

You can do this, using a temporary table:

CREATE TABLE #tempTable ( Value INT, i INT identity(1,1) )

USE...

Fortunately, seems to have hapy end.... here.

But,.... i have some questions...

Under which circumnstances you SQL Server was corrupted?

How did u realise that all the DBs...

Suppose that we have the following data in a table named Table1.

id Name

----------------

1 Sanket

2 Sachin

3 Kishan

4 Sanket

5 Ram

6 sachin

We see that the name Sanket occurs 2 times:

id Name

----------------

1...

You need the max date... per class i suppose?

What if for tha same class you have 2 or more rows with same max date?

Please.... be more specific, even the result...

ok... Farrel...

Now, for the JOIN syntax question... the syntax is:

< join_type > ::=

    [ INNER | { { LEFT | RIGHT | FULL...

@Date + ' 23:59:59'  performs date arithmentic calculations: adds to the @date 23 h, 59 min and 59 secs...

  any time...

Write a sp "EndOfDay" or update the current (I believe you use one, to transfer the data into history table) to do the following:

-After tranfser and delete the rows in the...

CREATE FUNCTION CustomersByContinent (@Continent varchar(30))

RETURNS TABLE

AS

RETURN SELECT dbo.WhichContinent(Customers.Country) as continent, customers.*

from customers

where dbo.WhichContinent(Customers.Country) = @Continent

GO

--examples of Calling the function

select * from...

for one more time u r not clear.... restructure and apply again.

Heiiii!!!!!!!!!!!!!!!!  we have a...

Yes, of cource I can tell you what Stored Function Tables are (i've worked on these maths structs).... if you would be more polite!!!!!!!!!!!!!  TO PEOPLE THAT TRY TO HELP...

First of all we must say two-three things:

1. The 'i' is just a sequencial number from 1 to the number of rows.

2. When we execute a query like this "select...