You can't do it with a single query but you can do it with two:

DECLARE @Computers TABLE

...

I think this article will help you:

Generating n-Tuples with SQL[/url]

There's a performance improved version of the UNIQUEnTuples rCTE (the one I think you'll need) late in the discussion thread here:

http://www.sqlservercentral.com/Forums/Topic1301485-3122-5.aspx...

I agree with Lynn that seeing the expected results would be far more helpful than a description, but nonetheless I'll give it a shot:

;WITH AllCustomers AS (

...

greg.bull (2/6/2013)

---

Perhaps one minor tweak is in order, which I hope you can help with. If there is no shift on a day, I want the period/episode to continue. Err...

Here's...

HildaJ (2/6/2013)

---

I'm very new to TSQL so my apologies for my lack of experience. Really working on it : ) So instead of using a cursor what would...

ChrisM@Work (2/6/2013)

---

DECLARE @Shifts TABLE

(staffid int, shiftdesc varchar(20), shiftdate datetime, shifthours float)

INSERT INTO @Shifts

SELECT 1, 'Sick', '2012-02-01',...

Maybe like this?

DECLARE @Shifts TABLE

(staffid int, shiftdesc varchar(20), shiftdate datetime, shifthours float)

INSERT INTO @Shifts

SELECT 1, 'Sick', '2012-02-01', 8

UNION ALL SELECT 1, 'SickOff', '2012-02-02', 8

UNION ALL SELECT 1,...

How about something like this?

SELECT *

FROM (VALUES (1),(2),(3),(4)) a([Day])

CROSS JOIN (VALUES (1),(2),(3),(4),(5),(6),(7)) b ([Week])

If you've already got SQL Server and SSMS, the best way to learn is to try to solve some of the puzzles that come up on this forum!

You don't necessarily...

I'd say that Cool Sig's response was pretty close to what I would do:

DECLARE @BenchTest TABLE

(ID INT IDENTITY

,PartNumber INT

...

Try this then:

DECLARE @FILTER VARCHAR(8000) = 'MGR1,MGR2'

SELECT *

FROM dbo.EMPLOYEE AS EMP

WHERE EMP.MGR IN (SELECT Item FROM DelimitedSplit8K(@FILTER, ','))

You can find the DelimitedSplit8K FUNCTION here:

Tally OH! An Improved SQL...

I believe you'll need to do something like this:

DECLARE @FILTERS TABLE (Name NVARCHAR(MAX))

INSERT INTO @FILTERS

SELECT 'MGR1' UNION ALL SELECT 'MGR2'

SELECT *

FROM dbo.EMPLOYEE AS EMP

WHERE EMP.MGR IN (SELECT...

masoudk1990 (2/5/2013)

---

Im trying to write...

Like Olga's suggestion, this approach is also pretty simple:

DECLARE @Table1 TABLE (PK INT, Name VARCHAR(6))

INSERT INTO @Table1 SELECT 1, 'XXXXXX' UNION ALL SELECT 2, 'XXXXXX'

DECLARE @Table2 TABLE (PK INT, Name...

SQLRNNR (2/5/2013)

---

You can't use CASE in that way. What you want to be using is IF blocks.

IF @GetRowcount=0

Begin

-- insert

END

IF @GetRowcount<>0

BEGIN

-- update

END

But this really looks like a...