to be honest i think that its not worth looping through, your better off using the CTE in my previous example to sum the total grouped by ID and use...

perhaps this is a better way of achiving what you want to achieve

;with add_points

as

(

select userid,sum(points) as points

from #a

group by userid

)

UPDATE #users SET total=total+points

from #users a inner join add_points b...

Yup it was past 6 oclock and the kids where killing me lol i...

When you say that when you run your select statement the rows are inconsistant in SQL do you mean after inserting say 100 rows and then running your select statement...

apparently not, i get about 7999 characters into a varchar(8000), have you considered using varchar(max)?

declare @str1 varchar(10),

@str2 varchar(10)

set @str1 = 'Lokesh'

set @str2 = 'Gowda'

select left(@str1,3)+replicate('*',len(@str1)-3), left(@str2,3)+replicate('*',len(@str2)-3)

why anyone would validate against the version is beyond me however, one can only assume that your stored procedure can only be run against versions > 7 im assuming version...

Also if you want to make full use of the new functionality in SQL2008 you will need to update your database comparability level to 100, then do a complete test...

Have a look at the stairways and indexing, there is plenty of information for you on there.

as for pages, data is stored on pageses therefore if you have a page...

have a look at this link, it shows you the joins in picture form too

http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

have a look at this post http://www.sqlservercentral.com/articles/Best+Practices/61537/

Forum Etiquette: How to post data/code on a forum to get the best help

By Jeff Moden,

post in your new table structure and...

why not eliminate the space by using replace

REPLACE ( string_expression , string_pattern , string_replacement )

select replace (column,' ','')

Look up how to use PIVOT tables

can you add in what you have so far please so much easier to help you when we know what your looking at 🙂

are you trying to update this new field how many times a person enters a building? or do you need to report on how many times a person enters a...