Do not use database locking for this. You need to implement your own locking strategy.

See this link for a writeup of your options.

http://www.agiledata.org/essays/concurrencyControl.html

Try this link

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Cant take the credit for it ...

http://windowsitpro.com/article/articleid/14267/how-can-i-calculate-someones-age-in-sql-server.html

Try this for starters...

select Hour = number,

count(date)

from master..spt_values left outer join #temp

on datepart(hh,date)= number

where TYPE='p'...

Dont discount that possibility that your .Net app could be pulling the rows slower than SSMS

I think you are wrong in your assessment of round though,

round(60.444445,1) = 60.4

This

PRINT ROUND(ROUND(ROUND(ROUND(ROUND(60.444445, 5), 4), 3), 2), 1)

works because you are rounding a rounded , rounded,...

Heres how to calculate an age

select CASE

WHEN dateadd(year, datediff (year, d1, d2), d1) > d2

THEN datediff (year, d1, d2) - 1

ELSE datediff (year, d1, d2)

END as Age

I'll take a look...

Maybe something like this ?

DECLARE @Survey_Thank_You_Page_Config TABLE (

acct_id int,

survey_stub uniqueidentifier,

allow_invitation_forward_flag bit

)

DECLARE @Survey_Page_Detail TABLE (

acct_id int,

survey_stub uniqueidentifier,

page_detail_value int,

page_detail_id int

)

INSERT INTO @Survey_Thank_You_Page_Config (acct_id, survey_stub) SELECT

1, '0C23194A-2A5E-4EEB-9050-930A59E953A7'

INSERT INTO @Survey_Page_Detail (acct_id, survey_stub, page_detail_value, page_detail_id)...

But according to your query NULL is a equally valid value to update the column to.

I dont know enough about what you are attempting to do but are...

If you change your update to a select you can see what is happening

DECLARE @Survey_Thank_You_Page_Config TABLE (

acct_id int,

survey_stub uniqueidentifier,

allow_invitation_forward_flag bit

)

DECLARE @Survey_Page_Detail TABLE (

acct_id int,

survey_stub uniqueidentifier,

page_detail_value int,

page_detail_id int

)

INSERT INTO @Survey_Thank_You_Page_Config (acct_id,...

Just for completeness, quirky merge goes out of order to...

create table #TransTest(

InsOrder integer identity,

TransactionDetailId integer null,

Test ...

Have a look at my blog entry here which , if i understand you requirement correct should help you nearer your goal

Apologies for the big lump of code before , kind of obvious that everyone else hasn't gone through the same process i have to reach that point.

Just to recap.

The...

Use a calendar table...

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Presumably you know the first date of the quarter so finding the third thursday would be straight

forward.

Can you post the same for the months table ?

Even with completely empty KPI table , you should still be getting all the rows in the months table.