Keeping an honest boss happy is too easy to do to need explanation.

Keeping a dishonest boss happy is impossible so not worth worrying about.

So I don't really bother with attention...

I've used ASCII comparisons for that kind of thing many times.

select *

from dbo.MyTable

where ASCII(MyColumn) between 97 and 122;

The ASCII function returns the ASCII value of the left character in a...

You can also use something like RedGate's Datbase Compare to compare schema differences and script the changes. There are competing products that do the same thing.

Those are very valuable...

Another valid use of Views is refactoring. Let's say you discover through use that a particular table should have been normalized further than originally conceived, due to changing business...

Exam or interview?

Doesn't look like a standard T-SQL statement to me. You can't use a column-wildcard in a Where clause in SQL Server. Ask your prof or interviewer what...

You're welcome.

I need the table definitions so I can write a query that will work for you.

engrshafiq4 (12/20/2011)

---

Sorry for your confusion.

i am asking SSC Eights!

He correct my code in his above post.and that worked for me.

Let me explain the issue

consider i have a table

CREATE TABLE [dbo].[Cities](

[CITY]...

Do you just need the count of workdays, or do you need a list of them, or something else?

If it's a count of them, then the query would look something...

I could give you a formula (or better yet, a calendar table solution) for that in SQL Server, but not in Excel. Have you tried posting the question on...

The version I posted will do what you need, but it might have performance issues, mainly depending on data size.

What you're probably better off doing is a two-step insert into...

Non-reversible, reproducable hashing (like the SQL Server use of...

WangcChiKaBastar (12/20/2011)

---

I am looking to send BINARY data instead of XML in the Service Broker to reduce message payload.

I was thinking to HASH the string but then couldnt figure out...

Yes.

Maybe I need to add to my sig:

"You have...