Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hrhadin

    Trouble logging on to SQL Server Express

    I've been successfully using a local installation of SQL Server Express for about 6 months. I recently changed my network/PC password and I've been unsuccessful in loging on to SQL since. I changed my password in SQL Server Configuration Manager, and it seems to start up OK. In the SQL Server...
  2. hrhadin

    Trouble with select statement using a variable

    Thanks to SQLDenis for your help. Your tips allowed me to complete the stored procedure I was working on.
  3. hrhadin

    Trouble with select statement using a variable

    It's a variable. I left out the Declare statement for simplicity.
  4. hrhadin

    Trouble with select statement using a variable

    I'm trying to open a cursor using an SQL statement based on a DB whose name changes from month to month. I have the following code: SET @dProcDate = '02-01-2007 00:00:00' SET @cMonth = 'Test_' + CASE WHEN MONTH(@dProcDate) < 10 THEN '0' + CAST(MONTH(@dProcDate) AS char(1)) ELSE...
  5. hrhadin

    Pass by reference

    Thanks for all your help George. It works!
  6. hrhadin

    Pass by reference

    Thanks George - That's a big step in the right direction. However it's still not working. What's the difference between running the above code, which returns the error message: Msg 3701, Level 11, State 5, Line 1 Cannot drop the table 'XXX_012007.Dbo.PT', because it does not exist or you do not...
  7. hrhadin

    Pass by reference

    Tried your code, received this error: The name 'drop table [XXX_012007.Dbo.PT]' is not a valid identifier.
  8. hrhadin

    Pass by reference

    I am attempting to write code that drops tables/databases based on a date. I have several databases/tables with the following names: Database - XXX_122006 tables - PT_122006 PD_122006 Database - XXX_012007 tables - PT_012007 PD_012007 I have the following...
  9. hrhadin

    Trouble accessing web config for connection string

    Thanks to you both. I'm a beginner with ASP.NET and it's a steep learning curve.
  10. hrhadin

    Trouble accessing web config for connection string

    I have the following entry in my web.config file: <connectionStrings> <add name="ConnectionString" connectionString="Server=XXX\SQLEXPRESS;Database=Test;Uid=sa;Pwd=XXXXX"></add> </connectionStrings> I am trying to access the connection string as follows: Dim lcConStr As String lcConStr =...
  11. hrhadin

    Keyword Not Supported: dsn

    Thanks for your help TipGiver. The ConnectionString.com provided me with correct format for my string.
  12. hrhadin

    Keyword Not Supported: dsn

    Dsn. It's an ODBC Data Source
  13. hrhadin

    Keyword Not Supported: dsn

    I have the following code in the page_load event of page Default.aspx: Imports System.Data Imports System.Data.SqlClient Partial Class _Default Protected Sub page_load(ByVal sender As Object, ByVal e As System.EventArgs) If Not IsPostBack Then Dim conn As New SqlConnection...
  14. hrhadin

    Error on calling SP with output parameter

    I have a simple sp: create procedure [dbo].[sp_GetClinicLocation] @cCID char(5), @cLocation varchar(50) output AS BEGIN SELECT @cLocation = cLocation FROM AC WHERE cClinic = @cCID END I'm trying to call the procedure as such: declare @Test varchar(50) exec...
  15. hrhadin

    Aggregate field math

    Thanks to all who replied. Your tips were valuable in resovling my problem
  16. hrhadin

    Aggregate field math

    I have a written a query which asks for the results of a couple of aggregate calculations: count(*) as nTotal, SUM(nTVC) as nVTotal Results nTotal = 4754 nvTotal = 11911 However, when I add this line to the query: count(*)/SUM(nTVC) AS nVPercent Results nTotal = 4754...

Part and Inventory Search

Back
Top