however, this should do what you ask
Code:
Select Max(TimeLogoff) From shift_Login
gpl
Last Activity: Jun 26 '12, 01:44 PM
Joined: Jul 26 '07
Location:
-
In the context of an SQL table, last row is meaningless
however, this should do what you ask
-
Foxpro is essentially dBase -- is there a filter for this in the import (was data transformation in sql 2000)
If not, write a script to recreate the tables and then some code to extract the data from the foxpro database and format it into a series of INSERT statements that you can execute to add the data into SQL 2008
Thats how Id do itLeave a comment:
-
In the case statement, replace 'rentperiod' by the definition of rentperiod from the previous columnLeave a comment:
-
VarChar is a variable length type, it takes up just enough room to hold the contents (up to the limit in its declaration.
If you were using the Char type, then the length is important.
In your case just declare it as VarChar(4096) - and no, you cannot have variable variable-length declarationLeave a comment:
-
Its a bit dangerous to do this if you arent sure of the syntax
Could you try deleting a few rows at a time in Enterprise Manager ?Leave a comment:
-
what happened when you tried it?Leave a comment:
-
I dont have SQL Server with me, so I cannot verify the code
Basically, your sub query needs to be set up as a derived table so that it can be joined.
Many years ago I read an article that said SQL Server is optimised for Left (as opposed to Right) outer joins, so have re-written it that way.
This should get you started
...Code:SELECT tblPhone.custID, NotMobile.CustMoreThanMob FROM tblPhone left outer
Leave a comment:
-
ok - I dont have SQL server available to me, but you would have to do something like this:
Code:SELECT id, first_name, (SELECT user_name FROM table2 WHERE table2.user_id = users.id) as new_user_name FROM users WHERE (SELECT user_name FROM table2 WHERE table2.user_id = users.id) = 'a'
Leave a comment:
-
new_user_name cannot be referenced in the outer query as it is an alias for the subquery
why not just use a join?Leave a comment:
-
You could use correlated sub queries, or derived tables, see below (I dont have sql server so have not been able to check the results)
...Code:Select ID, ACTIVITY, INITIAL_DATE, NULLIF(End_Date, Initial_Date) As END_DATE From ( Select ID, ACTIVITY, MIN(Date) as INITIAL_DATE From A_TABLE Group By ID, ACTIVITY ) MinTab Inner JoinLeave a comment:
-
Try this, the group by will order the results, Im not sure how you want to order the results from your example
...Code:SELECT FruitID, CustomerName, SUM(QuantityBought), MONTH(DateBought), YEAR(DateBought) From CustomerOrders inner join Customers on Customers.CustomerID = CustomerOrders.CustomerID WHERE YEAR(DateBought) >= 2010 GROUP BY FruitID, CustomerName,
Leave a comment:
-
do you mean connection pooling ?
didnt google return ANY results ?Leave a comment:
-
Why do you have the requirement Only use NOT EXISTS.Is this homework?Leave a comment:
-
dateadd(n, moncalladd.star toncalldate, +1)+(moncall.startoncalltim e/1440)+(moncalla dd.Duration/1440) as addeddate,
highlighted above -- a hard to find typo ?Leave a comment:
-
Take a look at DTS, you can even get it to be scheduled to run every dayLeave a comment:
-
what does the generated SQL look like ?
try replacing your exec @Query with a Print @Query
Do you really need dynamic sql for this? a stored procedure would be much more efficient and would give a better clue as to where your problem is.Leave a comment:
-
2 things - your table creation has a set statement in it, that would not be valid.
Your @Query string needs a space after the FROM
I havent used TEXT fields, is it valid to oncatenate them ? the error message would indicate not, so cast those columns as varchar
When developing dynamic sql, it is often useful to PRINT the generated query in query analyser to see what will be executedLeave a comment:
-
Im guessing that your emp_id column is not a numeric one!
Assuming that it only holds digits, try
select max(convert(int , emp_id)) from table_name
Or convert the whole column to a numeric type .. in future, it would be helpful if you posted the table definition too!Leave a comment:
-
Strip off the time and test for equality - look at converting to a stringLeave a comment:
No activity results to display
Leave a comment: