You are close but I believe you need to remove the statement

ROW_NUMBER() OVER (ORDER BY RowNumber)AS 'FinalRowCount'

from the CTE expression and add it to the outer Select statement

for the...

Here is my email: jwbart10@gmail.com,

shoot me an email and we can set up a time

I could meet tomorrow night?

I recieved an email from Melissa the Northeast PASS...

Using

@fromRec int, -1

@toRec int -10

you are going to get row_numbers 1 through 10

on the between statement @fromRec and @toRec

So your results are correct, there is no way to get...

I have only been once, but I figured it would be a good general meeting place.

It is right next to the Hanaford\Mcdonalds on Wolf road.

Never been to the one...

Dan,

I say we meet and start our own user group, once we have a plan of attack then we can start our own PASS Chapter, I emailed Melissa the Northeast...

Did you start one in Albany?

Contact me I would like to start one, I have no idea how to do it, I believe we officially have to start meeting and...

Weird thing you don't have to have the same size of data type.

If you were to explicitly convert the columns to be the same datatype you can, but as you...

I am new to the forum, so any help would be great.

So, when is it a good time to SET and when is it not?

From the article I deduced it...

As a syntax thing use SET to assign value to the variable

set @_type = (select max(turno) from u_contadores)

Although it does work the way you wrote it is a little more...

I would just like to say when I ran select @@VERSION

it gave me

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600..

After my much anticipated searching I could not find...

I feel this would be practical in certain situations, especially in the ever changing and dynamic code we like to implement.

Good to know someone has an idea on how to...

This is definitely awesome!

Thank you, 🙂 only problem is where were you three years ago when I had to write all of the insert and updates before?

I haven't implemented...

I felt it was worth two points , sure stumped me.

Make you think outside the box.

Thank you