You searched for the word(s): userid:691362

More Search Options

RSS Available

• need to pick row if the following conditions in a column is met

  Hi, I have table that has following fields T_Id client_Id Submit_dt asam_values 1 15 1/1/2009 1,2,3,4,5,6 2 15 1/1/2009 1,1,1,1,1,1 etc. I want to select those rows if the asam_values 1 or top 3 or first value is 3 and 2 of the bottom 3 is a 3 then i want to select that row else omit it? How can i do it.. Any help will appreciated. Thanks, Karen

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Karenros on 11/24/2009

• How does sql server handle two jobs that start at the same time?

  Suppose if I have 2 sql jobs that start at 2am how does sql server handle them in terms of running the jobs. Any help will be appreciated Thanks, Karen

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Karenros on 11/10/2009

• Help needed to in designing a table and then querying off it...

  Hi, This is my scenario.. For July08 to June09 the rate should be 87% and for July09 to June10 the rate should be 89% so if i pass a datetime to that sproc based on the Date i want return 87% or 88%.. I have created a small table and written a query off it but i am not sure if its the best design... This is what i have done so far declare @str_dt datetime, @end_dt datetime set @str_dt = '9/1/2008' set @end_dt = '9/30/2008' Create table #temprates ( StartMonth nvarchar(25), EndMonth

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Karenros on 11/10/2009

• Re: Help needed to in designing a table and then querying off it...

  I ended up changing my table design from varchar to smalldatetime and it easy to work off datetime instead of strings select * from #temprates where @str_dt between startmonth and endmonth or @end_dt between startmonth and endmonth

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Karenros on 11/10/2009

• Re: How to display each page per each id

  Put a list on your report and then group by studentID.. Hope this helps.. Thanks, Karen

  Posted to SQL Server Reporting Services (Forum) by Karenros on 11/6/2009

• Re: Staging Path does not exist

  Does the report server exists on that computer... or is it on a different server?

  Posted to SQL Server Reporting Services (Forum) by Karenros on 11/4/2009

• Re: how to transfer data from Excel file to Sql Server Database

  That piece of code goes in the button click event...I dont have access to the source code anymore...

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Karenros on 11/4/2009

• Re: Report Viewer Error

  Do you have a images in your reports that been missing? like a image that was suppose to be on the report server but not there or a link to a image that was changed?

  Posted to SQL Server Reporting Services (Forum) by Karenros on 11/3/2009

• Re: How to fix the position of controls, so table expands into whitespace and doesn't push lower controls down (invoice report in SSRS 2005)

  Have a list on your page.. and then put those controls so that the controls will stay togther..If you right click on that the list and select properties in the general tab please check the check box "fit on one page" and put a rectangle inside the list to have the controls in the bottom of the page stay in the same spot.. Hope this helps, Thanks, Karen

  Posted to SQL Server Reporting Services (Forum) by Karenros on 11/3/2009

• Re: how to transfer data from Excel file to Sql Server Database

  If Not Me.FileUpload1.PostedFile Is Nothing And FileUpload1.PostedFile.ContentLength > 0 Then Dim fn As String = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName) Dim SaveLocation As String = Server.MapPath("..\finance\" & fn) 'folder path Try FileUpload1.PostedFile.SaveAs(SaveLocation) Dim excelConnectionString As String = ("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("..\finance\" & fn) & ";"

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Karenros on 11/3/2009