Search results for query: *

or in other words iif(@deleteonly = 1,Deleted=1,Deleted=0)

I'm just trying to do if parameter @deleteonly = 1 then in where caluse field name DELETED = 1 else DELETED=0 thanks

BUT HOW CAN i RUN THIS SCRIPT

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 do not know which user is using popup blocker in my application I need to used calender and other pop up stuff not all user are computer savvy so I need to disable popup blocker so they do not need to any thing and can be able to see the popup windows what I search so far there is property...

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"...

Thank you guys very much it is working now

Hi SQLDenis when I tried your suggestion I get this error Msg 536, Level 16, State 5, Line 1 Invalid length parameter passed to the SUBSTRING function.

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...

Thanks for your help

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...

thanks

can you share with us how did you figure it out

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