Several ways of doing this, here is one suggestion using a CTE. The important thing here is to pre-filter the second set because any filtering after joining the sets will...

Have a safe journey back home.

😎

Thank you all for the interesting discussion, don't panic and remember the Towel day[/url]

😎

In the explanation I used the term unassigned for the lack of a better one as the value of the variable is neither truncated nor is it null.

😎

ChrisM@Work (2/26/2015)

---

Jeff Moden (2/25/2015)

---

Brandie Tarvin (2/25/2015)

---

Need some advice, all. I'm about to rewrite a novel of mine and I need references for research. My protagonist (the star) is humanoid but...

On SQL Server 2008 you can manipulate the image data just like any other data type, consider this example

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.MY_BLOB') IS NOT NULL DROP TABLE dbo.MY_BLOB;

CREATE TABLE...

Quick question, what is the question?

😎

CELKO (2/24/2015)

---

...

You should follow ISO-8601 rules for displaying temporal data. This is the second most used ISO standard on Earth (the metric system is #1) and you do not know...

RamSteve (2/24/2015)

---

So will there be any issues in using with(NOLOCK) for sys schemas ? I had the habit of using every where in SQL Statements ..What would be the pros...

RamSteve (2/24/2015)

---

Hi,

I have the following 2 Query's - case when Table has no Identity Column and other with identity Column . I am planning to make it to single...

Good work! appreciate it.

😎

It popped up on "Recent Posts" two days ago, thought it was funny:-D

😎

KGJ-Dev (2/23/2015)

---

Hi Erik,

Here is my confusion, if i use the Sean's suggestion i am in the position to use the same query for two times as i need that output...

Quick suggestion, use the sys.sql_expression_dependencies system view

😎

SELECT

SD.*

FROM sys.sql_expression_dependencies SD

WHERE SD.referenced_database_name IS NOT NULL

;

Duplicate post, answer on this thread

😎