Great picture, Gail. Is that an original artwork, or something you put together from other works?

For the current season, from Audra and the Antidote:

We Wish You A Merry Christmas

We...

Here's how I'd do it in T-SQL, based on the strings provided.

if object_id(N'tempdb..#T') is not null

drop table #T;

create table #T (

ID int identity primary key,

Val1 varchar(max));

insert into #T (Val1)

select 'NAORABRA...

I use an Android phone, and it's been a pleasure to use since the hour I got it. Plenty of apps available, some good, some not so good, some...

Okay, that clarifies the rules enough to work with.

What you need to do is modify my Union query by adding a simple "Not In" for the contra-rule. That will...

On the "where to process it" question, the keys to that are "what are you doing" and "what effect will it have on network utilization".

If, for example, you're going to...

If they'll be writing their own queries, make sure they only have rights to the tables/views that they are supposed to. You don't need people accessing system tables, for...

rahulsony111 (12/21/2009)

---

I am trying this from 5 hrs and unable to get a solution.

In target table i have that column as numeric.

I tried getdate() with datatype databasedate but it...

Does this do what you need?

;with Dates (Date) as

(select Date1

from dbo.MyTable

union all

select Date2

from dbo.MyTable)

select max(Date)

from Dates;

Have you tried converting to varchar with style 112?

select convert(varchar(100), getdate(), 112);

You could wrap that in a further convert/cast to numeric, if you want to.

There are now, always have been, and always will be, ambiguities in every human language that has ever existed.

We've got extensive mechanisms for dealing with this already built into every...

I had to decipher the code based on the usual methodology. I haven't seen the Frosty the Snowman movie since the 70s. Amusing question though.

Steve: Is there a...

Without knowing your security and seeing your connection string (please don't post that with username and password data, just to be safe), there's not much I can tell for sure....

Books Online (SQL Server "Help" file on your start menu or in Management Studio), or MSDN (online) has exact data on what roles can do what.

For someone who just needs...

Here's what I'm running:

-- I havePreference Types as Under;

Declare @vPreferenceType Table (TypeId int, TypeDesc varchar(10))

Insert into @vPreferenceType

Select 1,'Gender' Union All

...

sjsubscribe (12/21/2009)

---

GSquared (12/21/2009)

---

sjsubscribe (12/21/2009)

---

Encryption in general should be a default install at the OS level and apply to all files, not just to database files or express editions. Files like...