Not sure what your question is there?

Having group by in your query won't matter one jot.

peacesells (11/8/2013)

---

SGT_squeequal (11/8/2013)

---

Be easier to help if you provide some Ddl and how are you calling stored procedure or setting the variables. Initially i would look up dynamic sql perhaps...

First you will need to include some column which ORDERS the data.

As it is your sample data cannot be ordered by anything to know whether activities are consecutive.

Mick, can I ask why you want to insert the 50 rows into a temp table?

Can't you just take the output from the "OUTPUT" clause and use that directly in...

The standard way would be to use the format property with a value of "C2", then it will use the user's local region settings to display the value.

If you wanted...

Jacob Pressures (11/3/2013)

---

Thanks very much for your replies. I'll answer as best as I can because I'm an novice.

Not exactly sure...

I take it you know about REPLACE, so I can only assume that there is some other complication that prevents you using REPLACE...yes?

Maybe you don't know it will say Frog12...

So, this is a web application running on the same machine (MIKE) as the SQL instance that contains database Northwind?

Are you sure that Northwind is on the default instance?

Have you...

You...

Borrowing from Dwain's sample data and Tally, here is my submission:

--== Dwain's setup ==--

declare @t as table (ptr int identity, START time, ENDD time)

insert into @t (START, ENDD)

SELECT '09:30', '10:30'...

You have your syntax wrong, try this:

;With aa AS (Select * from [temp_table] where c_date between @Begin_Date AND @End_Date)

INSERT @tmp1

SELECT [Year]

,[Month]

,[Customer]

FROM AA

James Millar-305032 (10/25/2013)

---

Thanks, I get the bigger picture now, but what is the "values" part doing? Why the 6 "(1)" records and the significance of the a(x) and b(x)? Sorry...

That part of the code is simply building an "on-the-fly" Tally/Numbers table, which will be used to address each character in the input string.

See This Article by Jeff Moden to...

Here you go

create function Mod97Checksum(@input varchar(30))

returns table

as

return

select sum(cast(substring(@input,N,1) as int) * N)%97 as check_sum

from (

select top(datalength(@input)) row_number() over (order by (select null)) as N

from (values(1),(1),(1),(1),(1),(1)) a(x)

,(values(1),(1),(1),(1),(1),(1)) b(x)

) Tally(N)

where substring(@input,N,1)...

You're most welcome 🙂