Search results for query: *

I'm new bee and need help I'm trying to write store proc but getting error here is what I'm trying to do any help would be great SELECT Import_Date, FileName as Import_File, DeletedDateTime ErrorLine, ErrorsDetected, Notes,DELETED FROM tblimporterrors WHERE customerid = @customerid...

I am opening a pop up window but the google toolbar blocks it, i want to unblock that window using javascript. here is code I'm using to open aspx page Private Sub showReport(ByVal url As String) Dim reportScript As String = " <SCRIPT language='javascript'>" & _...

I have a report published on server now we found there is a bug and need to fix that how can I get that published report from report server and work on it any help will be nice

I am using this to transfer data from asp page to excel sheet. Response.AddHeader("Content-Disposition", "attachment; filename=" + ExportReportName) Response.AddHeader("Content-Length", bytes.Length.ToString()) Response.ContentType = "application/octet-stream"...

I have following query I need to parse field name "l.ErrorMsgEntry" which has long string all I'm interesting in to get the value left side of ';' (semi colon) I try but it's not working any help SELECT COUNT(l.ErrorMsgEntry) AS Error_Qunatity, parsename((l.ErrorMsgEntry,';'), 1) FROM...

How to retreive yesterday's date I have to build a report which gets every day data for yesterday date I tried with datepart("d", getdate()-1) and it's not working Any help will be greate

Hi I need to build a routing with sql server 2005 notification services that send email to all subscribers every night at 12:00 this day data changed. would you please guide me the best approach to develop this routine with C# or if you have any sample I am glad to see Thanks

ihave a page with popup calendar when a user clicks a button. I have tried it with a normal page (that is a page without Master Page) and it works well. But when I apply it to a page which uses a Master Page, the program does not execute as expected. I tried to output the line that sends back...

I have a master page name master page which has td style="vertical-align: top; height: 388px;"> <asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server"> </asp:ContentPlaceHolder> </td> I made other page(default) as child by adding...

I have a two databases running on one server I want to update table in current database from other database name sitemgr on same server So data on both table will be synchoronize Update tblUser set UserName = p.UserName, LoginID =p.LoginID...

How can we execute query from button event of form

I have build small program and allowed user to build query for search is there any way I can restrict them to modify data like disable menu bar when user see query in desing view Thanks

How can I set password for my vba code so no one can edit .

I have two table A and table b Both tables have the same DB structure i.e. siteID,userid I am trying to write a query to compare the userid in both table where there is siteid matched Both table are from different databases some records do not match their userid and some are missing user id...

I have two table A and table b Both tables have the same DB structure i.e. siteID,userid I am trying to write a stored procedure to compare the userid in both table where there is siteid matched Both table are from different databases some records do not match their userid and some are...

I have a table name tbluser in database A has fields userid and siteid then I have tablename tblhelper in database B with "userid" and "Entityid" fields I want write store procedure to move record from database a to database b I check data type are matching I'm using following INSERT...

I trying to run code IF(ISNA(VLOOKUP(h2,i7:i9,1,FALSE)),"No","Yes") and/or Application.WorksheetFunction.VLookup(Look_Value, Range(h7:i9), cwfR + 1, False) From MS access (vba) and getting error any suggestion how to make it run thanks

I have a spreadsheet and two of the columns are called SiteDeveloper and WFDeveloper SiteDeveloper WFDeveloper ID 2658 1. Cortright, John Cortright, John 2. Goldberg, Glenn Berberich...

I need to compare username in Active directory with username in MS Access Does any one know of a way to do this? Any help will be appreciated Thanx