GSquared (1/15/2009)

---

Loner (1/15/2009)

---

10:15 - messing around on SQL Server Central

10:21 - help desk ticket #35104

11:30 - lunch

12:50 - building view dbo.JoesNewReport

13:07 - emergency help desk ticket #542138

13:17 - building view...

First you need to define your table with a column of varbinary(max). Then you can use the code provided by ulhas.

Do you want to copy primary key values to another table? What is the schema of the destination table?

I'd also be concerned someone else is trying to hack into the server.

IMO, you should be opening and closing connections as needed, not holding a connection open as long as the program is open.

I' m with you Steve. I'd much rather stay home and be in my routine. If I have to go, I endure the getting there part, and usually...

Grant Fritchey

---

Oh now, don't be getting nervous over potato cannons. There are a lot more weapons around here as, or more, deadly.

For example, oh Gail, how many swords in your...

We always...

Do you work for Bill Belichek...

I missed that one.

Michael has an interesting solution.

It looks like the Optimizer is ignoring your subquery since you are not referencing anything outside the table. Basically it is converting your query to this:

Select ...

Here's a blog post that I think will help: http://blogs.conchango.com/jamiethomson/archive/2006/01/04/2540.aspx

bpowers (1/14/2009)

---

I am trying to build a view that looks at our cust_address table data. However, there will be times when this information will be null. In that case I...

Where does Cust_Address_v.ID come from? I assume you it si from a view. You would need to do something like this:

If Exists(Select 1 from Cust_Address_v Where ID is...

Basically allowing a NULL in a Foreign Key is allowing for an optional relationship. For instance in a system I am working on we have a birth_state_id in the...