Maybe something like this:

WITH SampleData AS(

SELECT 1 n UNION ALL

SELECT 2 n UNION ALL

SELECT 3 n UNION ALL

...

Ed Wagner (9/11/2014)

---

Heh - We just got our driveway paved with asphalt on Tuesday (the day before the rain) and our dog doesn't know what to do any more. ...

Thank you, Tom.

I guess I shouldn't have taken the quote from Wikipedia. My mistake.

PS. It's great that you can create cables on SQL :-D:hehe:

Your little example is really nice, real life isn't like that.

Please find the errors in the following code:

INSERT INTO dbo.FactInternetSalesCopy

(ProductKey, OrderDateKey, DueDateKey, ShipDateKey, CustomerKey, PromotionKey, CurrencyKey,

...

If my guessing skills are working fine, you want a result set which in some coding languages is called a cursor. A cursor in SQL Server is very different and...

If you're interested on having help in the same place for front and back end, you might want to use SQL Server with visual studio and take a look at...

CELKO (9/11/2014)

---

The single line is a bouma; a semantic unit read as a whole. My PROGRAMMING STYLE goes into some of the research we collected at AIRMICS on this. I...

SimonHolzman (9/10/2014)

---

Please don't do this... It's one of the things that drove me crazy with c programmers -...

Eugene Elutin (9/10/2014)

---

Alan.B (9/9/2014)

---

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very interesting :laugh:

Edit: sql code tag messed up...

Are you seeing (ampersand)gt(semicolon)? That's a "greater than" sign showed like that by this site. You should use the normal sign in your query.

If you see the "greater than" sign,...

To complement what David said, you need to use AND instead of OR.

Of course, you could go with the simple way of doing it.

declare @user varchar(30) = ''

IF @user >...

You're right.

But with no question, there's no wrong answer. 😀

"If you don't know where you are going, any road will get you there." - Lewis Carroll

You need to use 2 data flow tasks.

New Born DBA (9/9/2014)

---

Yes on the server. I asked one of co-worker to RDP into the server and kick me out but he...

Here's an option to read the table once based on Tom's post and cross tabs.

with number as (select Exam_id

, row_number() over (partition by exam_id order by ([time])) NUM

...