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

More Search Options

RSS Available

• Using the "GO" directive

  I was reading about CTE on MSDN and I notice that they use the word "GO" both before and after the script. I can't find any info on thes command "GO". Obviously it must be saying that the script is ready to be run. Is "GO" really necessary and when should it be used? USE AdventureWorks; GO WITH DirectReports (ManagerID, EmployeeID, Title, DeptID, Level) AS ( -- Anchor member definition SELECT e.ManagerID, e.EmployeeID, e.Title, edh.DepartmentID, 0 AS Level FROM HumanResources

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

• Returning data from a stored procedure

  I have a stored procedure that is recursive. I can call it using the Query Analyzer command line. My ultimate goal is to return the result of the call to this stored procedure and to store it in a data set. Does anyone know how to do this? Here is my C# code and the stored procedure I am using. I am sure the problem is with my stored procedure, but I need help? SqlCommand getHeirarchyList; SqlConnection DocsConn = new SqlConnection(connString); getHeirarchyList = new SqlCommand("ShowHierarchyList"

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

• Re: Returning data from a stored procedure

  1. The second data set is a typo 2. SQL Server 2005 3. The requirement we have is to not use CTE.

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

• Re: Returning data from a stored procedure

  Thanks. I need to read up on CTE. Thanks a bunch!

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

• Re: Need help determining error in SQL query

  Hi Naom, Not type of magic good or mad made that change. Just a mistake on my part when reviewing my post. I didn't mean to press that button. My apologies!

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

• Many methods to handle hyperlinked row being pressed. Which one should I use ?

  I have a GridView control that I am maintaining that somoene else created. It has an ItemTemplate that defines a hyperlink on the Grid. When the hyperlink is pressed, I need to implement some code that will perform some C# logic. I am confused as to what method I need to add the C# logic code to? As you can see I have four different methods I could use. Also I am wondering which methods are even necessary? So my main question is what method should I use to handle the hyperlink being pressed. LinkButton2_Command

  Posted to Data Presentation Controls (Forum) by brgdotnet on 9/9/2009

• Re: Need help determining error in SQL query

  Well the last outer join I believe should have operated on the primary key so that needed to be corrected. Thanks for the reply

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brgdotnet on 9/9/2009

• How to turn off output from being displayed when sql stored procedure is executed?

  I have a sql stored procedure that performs several select statements and then eventually calls EXEC msdb.dbo.sp_send_dbmail to send out email messages. When I test run the stored procedure in Query Analyzer, I get the result of the query outputted in query analyzer so that I may see the result. How can I turn this off so that output is not displayed when the query is executed. Thinking back the command "Echo off" comes to mind, but I could be wrong. Can someone help me out? How do I turn

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brgdotnet on 9/8/2009

• Re: How to turn off output from being displayed when sql stored procedure is executed?

  I appreciate the help. I tried turning it on and off, but the results of the query are still being displayed in query analyzer. Anything else you can think of, or am I using the command correctly? SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON SET NOCOUNT OFF ------Tried this as well---- SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON SET NOCOUNT ON GO

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brgdotnet on 9/8/2009

• Re: Sending out bulk emails. I don't think EXEC msdb.dbo.sp_send_dbmail will workEXEC msdb.dbo.sp_send_dbmail?

  I appreciate the reply, but I think we are talking about two different things. This is what I need to figure out. 1.) Must be able to send out around 70,000 emails max. Same email message, but just different recipients 2.) What is the best way to do this? Because sending out one at a time in a loop could take a very long time 3.) If I send out the emails in bulk, there most likely is a limit on the number of emails being sent out. Currently I am using the SQL stored procedure EXEC msdb . dbo . sp_send_dbmail

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brgdotnet on 9/8/2009