View Complete Post
I got a requirement to create a view with current months qty, value and same month last year qty, value
Im facing a issue when im trying to create a Index on a view which created using table-valued function. following is a script I used to create the view followed by script to create index on that view.
CREATE VIEW vSales WITH SCHEMABINDING AS
FROM dbo.Table1, dbo.Table2, dbo.Table3
WHERE dbo.Table1.DateCol = dbo.Table2.DateCol
AND dbo.Table1.ProductCol = dbo.Table3.ProductCol
Can we create indexed view from the base table which has no index?
This is because i don't want any indexes in my base table but for better query performance i want in view..
Thanks in advance,
Hey ASP Guru's,
I am working on a form that has a det
There is a table with 100 million rows in my DB. Thus, I create an indexed view as below
Create view dbo.try
select a.id, a.name, a.desc from dbo.a
where a.codeType='G' and planner in (4567,899)
Create unique clustered index IDX on dbo.try(id)
Then When I run the SQL statement as below
select * from try
when I look at the execution plan, it seems to still fetch the data from the indexes created in the underlting table <a>, Instead , as I thought it should fetch data from the materialize
What is the best way to replicate data from a view containing a LEFT OUTER JOIN (so cannot be indexed) to a physical fact table on the subscriber in as real time a fashion as possible?
I have heard of the use of custom sync objects etc.. can anyone suggest the best way forward and any references?
Is CDC a candidate for this type of task?
Thanks in advance
If the view state is the data entered into the form fields then they are supposed to be available in the request parameters or request body. Then why would we need view state for?
i have a database and i create a form with button edit,delete, New Registration..using Formview in asp.net..
everything was working good...
And i write SQL statement to get New ID number into dropdownlist/TextBox when i click button "New Registration".
i can get new(next) ID number after read database
it's also working good
Now i want change it to get ID which was deleted from table and replace
the ID with new record...what i need is when i click "New Registration" i
want get deleted "ID" first and then go to new record ID...
my code is here:-it working for get next ID after read database.
FROM (SELECT ID + 1 AS PANG
EXCEPT SELECT ID FROM Table1)
AS boon WHERE PANG >300000
This is my first visit to the forums, I hope someone here can help me
I'm writing a small webapplication for creating repair tickets and adding comments, really basic
now I'm writing this in MVC2
So I have 2 controllers, 1 HomeController that does everything related to the tickets (listing tickets, creating new ones, editing) and 1 controller for the comments
the edit view for the homecontroller contains a partial view for /comment/create
so /home/edit/ticketnumber can edit the title and status of the ticket on the left side of the screen, the right side of the screen contains the partial view for adding comments
this is done like this:
but if I look at the generated html code when running the app, both save buttons go to /home/edit/ticketnumber
so the comment is never saved.
I hope this makes sense and that someone can help me solve this
Hi, whenever I load an aspx page in vwde2008, I get the message in the subject of this post. After I click Ok on that, I get a dialog box, Unable to Connect to the ASP.Net development center. What can I do to troubleshoot?
I am using Windows XP SP3, vwde2008 with SP1, on a HP desktop. Also using Office 2003 if that is relevant at all.
Why is it that I see the same hash value generated when I use different algorithms for viewstate encryption. I have added below lines to the web.config file