Books Online has data on how to do this. Search for "encryption", and it will give you a How-To article on the subject. It tells how to set...

Do you mean something like:

select Col1 as Name

from dbo.Table1

Or do you mean an actual synonym? As in:

create synonym Name for dbo.Table1.Col1

If so, then no, that syntax doesn't do what...

Glad you got it working. Well done.

Because of the ease of SQL injection, data corruption, user-error (whether that user is a dev or an end-user), et al, ad naseum, ad infinitum, I operate on the principle...

d_sysuk (4/29/2008)

---

There is a big difference in writing :

>> Unoptimsed SP method for lookup using local var

create procedure mysum (@myid int)

as

declare @myint int

set @myint= @myid

select x,y,z from mytable

where mylookupfilter...

Yep.

If you have a lot of rows being run at once, or if it's a lot of counts, you might be better off using a temp table than using a...

Keep in mind that the question, as asked, is possible. There are details that might make it impossible, but they aren't in the scope of the question.

As far as...

It's a standard hierarchy situation.

There are two basic ways to store and query those: Adjacency, and Nested Sets.

Adjacency is better at dealing with data that changes a lot. Nested...

Jeff's function will most likely do what you need, but keep in mind that calculations of age for "Leaplings" (people born on 29 Feb) can be problematic.

It's not a problem...

I came up with a different plan from yours for "best solution":

set nocount on

go

CREATE TABLE CaseDetails

(CaseId INT IDENTITY(1,1) primary key,

QTY NUMERIC(14,4),

weightedQty NUMERIC(14,4),

ShipmentId INT,

Total as Qty + WeightedQty)

go

raiserror('First...

The only suggestion I have is convert from DTS to SSIS, but that's not a very helpful suggestion. Sorry I can't help on this one. Don't know what...

Sorry, Art. Didn't read the second sentence where you answered me about the Union vs Join.

What you want to do is Join them.

Turn both in derived tables (I recommend...

My point was meant...

Shalini, please start a separate thread for that.

In that case, just add a Union All between the two queries, as written. I'd recommend adding a Category or Type column to each, so that you can tell...