Most likely, you don't need looping in what you are trying to achieve!

If you would post your question in line with the forum etiquette, I believe you will get relevant...

Looks like nothing special.

I cannot believe that data is missing from the view in your case.

It could be:

a.) you are looking into different environments

b.) you are applying filters

c.)...

Looking into your setup, balance should be updated within the same transaction as insert into Loads.

The one way to achieve it SQLServer is to have a trigger on Loads table:

--...

If view underlying table(s) DDL is not changed, data should not be missing in the view.

Can you please post your view DDL.

Jeff Moden (2/24/2012)

---

... Adding a couple of comments as to what each part of the code is doing just might help sway the OP away from loops and maybe even...

There is no direct analogue for this in SQLServer.

You can build recursive queries using CTE, but it will be quite far from using sys_connect_by_path.

Try to base you query on the following:

select *

from INFORMATION_SCHEMA.VIEWS v

join INFORMATION_SCHEMA.COLUMNS c on c.TABLE_SCHEMA = v.TABLE_SCHEMA

and c.TABLE_NAME = v.TABLE_NAME

Use check constraint as adviced in previous post. See the sample:

CREATE TABLE [dbo].[MyTbl](

[Id] [int] NOT NULL,

[AlphaNumericValue] [varchar](50) NULL

)

GO

ALTER TABLE [dbo].[MyTbl] WITH CHECK ADD CONSTRAINT [CK_MyTbl_AlphaNumericValue] CHECK...

It would be completely mad! :w00t:

But it's possible!

If...

Just one of the way of combining subtotals in SQL:

select [month], SumType, high_office, division, LOWER_OFFICE, AU, Revenue from

(

select 1 lo, 1 do, 'Lower_Ofice Total:' SumType,high_office, division, LOWER_OFFICE, [month],...

Pivoting may not perform well enough especially for large datasets (I guess your GL is not a small table :-))

Would be great if you could provide exact espected results for...

Kindly suggesting you the solution:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

You follow the above and the relevant answers will flow in...

Bipinkumar Yadav (2/24/2012)

---

hi Friend,

Try This way..

DECLARE

@start_date DATETIME,

@end_date DATETIME,

@start_date1 DATETIME,

@end_date1 DATETIME

...

You can use DATEPART function to calculate week number.

-- SELECT DATEPART(WEEK,[DateTime])

SELECT DATEPART(WEEK, '1 Jan 2012')

He need to label rolls...