Viewing 15 posts - 2,086 through 2,100 (of 2,894 total)
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...
February 28, 2012 at 4:50 am
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.)...
February 28, 2012 at 4:11 am
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:
--...
February 28, 2012 at 4:03 am
If view underlying table(s) DDL is not changed, data should not be missing in the view.
Can you please post your view DDL.
February 28, 2012 at 3:14 am
Jeff Moden (2/24/2012)
February 27, 2012 at 12:14 pm
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.
February 27, 2012 at 9:01 am
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
February 27, 2012 at 8:47 am
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...
February 27, 2012 at 6:50 am
AlexH89 (2/27/2012)
... but it would be great if the C# code could be actually created within the job itself. Is this possible?
It would be completely mad! :w00t:
But it's possible!
If...
February 27, 2012 at 6:34 am
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],...
February 27, 2012 at 5:57 am
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...
February 27, 2012 at 5:39 am
Kindly suggesting you the solution:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
You follow the above and the relevant answers will flow in...
February 24, 2012 at 6:40 am
Bipinkumar Yadav (2/24/2012)
Try This way..
DECLARE
@start_date DATETIME,
@end_date DATETIME,
@start_date1 DATETIME,
@end_date1 DATETIME
...
February 24, 2012 at 6:11 am
You can use DATEPART function to calculate week number.
-- SELECT DATEPART(WEEK,[DateTime])
SELECT DATEPART(WEEK, '1 Jan 2012')
February 24, 2012 at 4:58 am
CELKO (2/23/2012)
WHY? The last time I saw anything like this, the goal was to get physical labels for mag tapes. What are you trying to do?
He need to label rolls...
February 24, 2012 at 3:26 am
Viewing 15 posts - 2,086 through 2,100 (of 2,894 total)