I don't know your table structure...i just wanted to demonstrate that you can have an update that comes from a sub query as well as other values....use this as a...

quisiera saber como poder hacer que se guarde el log de mis dts en una tabla especifica , o como hago para que mis dts guarden el log de la...

the number one tool to export SQL queries and tables to disk would be BCP; you can decide what the delimiters would be, ie commas or tab delimited, or even...

The format of your current update from is a lot like what i've seen in Oracle and PLSQL;

SQL server supports a different format that, at least for me, seems more...

you guys missed his previous post...I;m thinking this is a shared hosting server, and not anything on his own LAN or that he has Admin access to at the OS...

the interview question was a test of your basic knowledge on how to query for data.

you failed.

If you can't answer it, it would show that you have no experience...

when the old SQL 7 was upgraded, non-system databases were left at compatibility 70.

since you clearly have a need to use functions, I'd change their compatibility to 80 and be...

to do that, you need a case statement for each possible value:

[font="Courier New"]

SELECT

  SUM(CASE WHEN idstatus = 1 THEN 1 ELSE 0 END) AS STATUS1,

  SUM(CASE WHEN idstatus = 2...

jb, was my guesstimate right? were all the databases on that server at compatibility 70, but master at 80 due to an upgrade?

you are all set on that server?

yep when using a varchar for LIKE statemnts, the spaces are significant. a varchar contaning spaces at the end maintains the spaces; it's when you look for equal to a...

following up on Alvin's question, which is important...what happens when you go to the spot below...what do you see?

on every Windows machine, there is an Administrators group, and by default a specific login named Administrator. On laptops it is typical that every login on the laptop become an...

it sounds like the following occurred:

someone created the view, and when you select from the view, you get the results you saw.

Then, in Enterprise Manager, they edited the view, aliasing...

there is no need to start a new thread;

continue the thread you started on the same question here:

http://www.sqlservercentral.com/Forums/Topic643690-19-1.aspx

if you are having trouble understanding some of the answers there, add a...

Here's how i understand the advantage:

if we are talking about a script that is doing something like updating data or something, a procedure has an advantage:

I'm sure you've seen this:...