The for each procs use cursors, they just hide it a bit. If you're comfortable with doing the update that way, then write a simple cursor that selects from...

The first point in getting buy-in on a redesign is finding out exactly how well it's working the way it is. If it fulfills the business needs, and the...

Keep in mind that making someone a schema owner can have unintended consequences security-wise. Check the MSDN/BOL articles on GRANT with regards to schemas.

You can use variables to modify connection options like server, table and column names in some SSIS objects. It really depends on what you are trying to achieve.

I read...

There's no "to_date" function in T-SQL. Oracle, yes. MS SQL, no.

Is the ENTRY_DATE column a text data type (varchar/char/etc.) or a datetime data type?

You can create them in either sequence. Schema first or login first. Works the same either way, just changes some of how you write the commands.

You can create them in either sequence. Schema first or login first.

When you say you're using SQL 2008 to connect, do you mean you're using SQL Server Management Studio 2008 Express, or something else?

Peter Brinkhaus (12/29/2010)

---

Probably hex values. 0x41 = 65, the ascii-value of a capital...

It can apply to any account. It depends on the options set when the account was created.

SQL Challenge 46, right?

The answer is, only the person who wrote it knows what they meant, and they haven't replied yet. So, nobody knows.

Thus far, the guesses on it...

ALZDBA (12/29/2010)

---

What's wrong with:

/* day 2 of the current month 00:00:00.000 */

select dateadd(dd,1,dateadd(mm, datediff(mm, 0, getdate()), 0))

/* if you need day 2 12 noon */

select dateadd(hh,36,dateadd(mm, datediff(mm, 0, getdate()),...

Check the server logs on mercurio. Something changed, you just need to find what.

Maybe there's been a patch you don't know about. Maybe a firewall setting was changed....

You're doing Charindex backwards. The string you're looking for goes first, the string you're looking in goes second. Essentially, you're trying to find "houses public" in " "....

Per the error messages, the "mercurio" server isn't responding to a login request. Is that server up and running? Does it respond to a ping?