You are welcome. Glad that worked for you.

The error message says it all. 🙂

However, there is no reason you can't use the same calculation again.

ALTER TABLE x

ADD CalcDt AS (dateadd(dd,-datediff(dd, [StrtTy], getdate()), [StrtLY]))

However, your original for DysBf...

Thanks to Erin for pointing out that you had posted ddl and sample data in your first post. :blush:

Now your most recent post does not match that new sample data...

No, NULL by definition cannot be greater or less than anything. It is...

I have to second what Dwain already stated. You don't have any way to force the order here. Why is Row 2 correct and Row 3 not correct? How do...

I see what you are saying about the row number but I am a bit confused about the process as a whole. Why would the rowNumber change based on return...

sharonsql2013 (7/8/2013)

---

I have a header table and a reporting table

(In Header table)If the product code selected is "health"

then In reporting table

ID should populate as H1

...

This looks a lot like homework. What have you tried so far? If you really need some help we will need a few things:

1. Sample DDL in the form of...

None here.

You should read this article from Gail. It is discussing this type of query and the performance issues that arise from it.

http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/%5B/url%5D

Why do you think you need to shrink it? Wouldn't you think that production will get a lot bigger than dev anyway?

http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/%5B/url%5D

riya_dave (7/8/2013)

---

i need up date records in a batch,not just bulk insert

can anybody give me script for example i have 1256789 records and i need to update 5000 at a...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE...

riya_dave (7/8/2013)

---

hi

i want to add column with no check constraint

like

alter table emp with nocheck

add column1 not null

and then i need to update with default values and then i need...

BOL is your friend.

http://msdn.microsoft.com/en-us/library/ms151254%28v=sql.105%29.aspx