Viewing 15 posts - 5,881 through 5,895 (of 7,429 total)
I suggest connecting to the remote server and build the database there not thru the new function of Export wizrd, this way you have more control over what happens as...
May 15, 2002 at 5:25 am
That is correct, what are you needing to know?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 15, 2002 at 5:15 am
Seems to be a common thing for people to ask, seems quite funny MS did not include this information in SQL BOL with an easy to find reference if it...
May 15, 2002 at 4:51 am
There's not much MS likes anyway, just as long as he is complying with the correct licensing purchased thou then there is not much they can say. And yes that...
May 15, 2002 at 4:48 am
Small list really don't make much difference, however IN has an ability that OR does not that I have seen on occasion and look for, plus IN is means less...
May 15, 2002 at 4:36 am
Try these then, you should be able to figure out which Emp comes thru based on order:
SELECT
*
FROM
Emp oQ
INNER JOIN
Dept
ON
oQ.deptid = Dept.deptid
WHERE
Salary IN (SELECT TOP 2 Salary FROM Emp iQ WHERE...
May 15, 2002 at 4:20 am
I find no information so there has to be something specific about this table that is causing this. Can you open EM and right click the table, select copy and...
May 14, 2002 at 7:40 pm
So I can make sure I get this right the expression defined by
(x2-x1) / (n+1)
what does n represent? Is it the number of missing days, which I assume but want...
May 14, 2002 at 3:36 pm
SELECT
*
FROM
Emp oQ
INNER JOIN
Dept
ON
oQ.deptid = Dept.deptid
WHERE
Salary IN (SELECT TOP 2 Salary FROM Emp iQ WHERE iQ.deptid = oQ.deptid ORDER BY Salary DESC)
ORDER BY
deptname
"Don't roll your eyes at me. I will tape...
May 14, 2002 at 3:10 pm
This is the correct method to change the server default collation you have to rebuild the master. If you want to make it easy on yourself then you can backup...
May 14, 2002 at 2:45 pm
Which if any of those problems is true it should be specific about. What is the full text of the message you are getting? This will help us explain maybe...
May 14, 2002 at 2:40 pm
Sorry you cannot do this. From SQL 2000 BOL (updated)
quote:
Function InvocationScalar-valued functions may be invoked where scalar expressions are used, including...
May 14, 2002 at 2:38 pm
Sorry there is no ### def for temp tables. From SQL 2000 BOL (updated)
quote:
There are two types of temporary tables:Local...
May 14, 2002 at 2:35 pm
Can you post your table DDL as you can try the -F and -L bcp commands which are First and Last records bu I don't believe it will work and...
May 14, 2002 at 12:36 pm
Don't see anything right off and things got busy here so I cannot test right now. But try the following change to the last of your code and see what...
May 14, 2002 at 9:48 am
Viewing 15 posts - 5,881 through 5,895 (of 7,429 total)