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!

  • Congratulations Chriss Miller 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: *

  • Users: pdbowling
  • Content: Threads
  • Order by date
  1. pdbowling

    SMO db.StoredProcedures not finding stored procedures in different schema by name.

    Hello, Everyone. I am using Sql Management Objects (SMO) in Visual Studio 2012 C#. I am attempting to instantiate a new StoredProcedure object from the db.StoredProcedures Collection. When I try to find a stored procedure in the [dbo] schema. It works fine. StoredProcedure sproc =...
  2. pdbowling

    Querying a table name that contains underscore.

    Hello, All. I have a query where I am looking for tables that end in _AM. SELECT sch.[name] AS SchemaName, tab.[name] AS TableName FROM sys.Tables AS tab JOIN sys.Schemas AS sch ON tab.schema_id = sch.schema_id WHERE tab.[name] LIKE '%_AM' AND sch.[name] = 'dbo' I get back: dbo...
  3. pdbowling

    Smo stored procedure creation.

    Hello, Everyone. I am new to SMO, so I do not know the accepted methodologies. From my attempts, it appears that I am way off track on how to use this set of tools. Suggestions and guidance appreciated. This is the error. "An unhandled exception of type...
  4. pdbowling

    Where can I query clustered or nonclustered table pk?

    I was curious if there was a way to query in tsql whether or not a table's key in clustered or not using table_name or object_id or whatever is best? Here is a table that has a clustered primary key set. I know that there are tables in my database that are Not clustered on the pk and I will...
  5. pdbowling

    Is there a way to query "Script table as"

    Hello, Everyone. I am trying to do some automated re-creation of some tables in Sql Server 2008. When you right click a table, you can choose 'Script table as' and get everything you need to know to re-create the table. I was curious if there was a way to do this using tsql that I could read...
  6. pdbowling

    Not clustering on identity.

    Good day everyone. My boss said to me 'Do not put a clustered index on the identity. I want to look at the data later and decide what to cluster on.' I have a snippet of code. It functions, but I am not sure that I completely grasp what is happening when I run it. Here is my snippet that I...
  7. pdbowling

    Sort an html table by day of week.

    Hello, All. I have an html table. The first column is a drop list with the days of the week in it Sunday through Saturday. Second column is two text boxes for start time and end time. The other column is a drop list (true/false). In the html, each row (other than the header) has a GUID for...
  8. pdbowling

    What version of Outlook am I using?

    Hello, Everyone. For years I went to the File Menu and chose Help->About and that would tell me everything about my version on the About Page. Then Outlook switched to the Ribbon and Tabs and got rid of the File Menu. At that point, I would click the File Tab and 'Help' was an option there...
  9. pdbowling

    Dynamic query result set

    Hello Everyone. I have been given an assignment that has me perplexed. I am curious if there is a way to get the result set of a dynamic query returned to the calling stored procedure. Since dynamic sql runs in it's own context, I can't just assign variables in the @SqlString. I am open to...
  10. pdbowling

    Variable disappears when cursor closes

    Hello, everyone. I am setting a variable equal to a data point in a cursor row. Snippet below. Is there a way to get a persistent variable assignment to the variable 'id'? This is clearing out when I close the cursor. I know that it is getting set from the cursor since it is showing in the...
  11. pdbowling

    Newbie formatting question

    Hello, Everyone. A little bit new to Crystal Reports. I have an old report. I am being told to duplicate it with some small modifications to the source query. I create the report using the Report Wizard. It's a cross-tab report. The wizard creates the report with the cross-tab in the...
  12. pdbowling

    Procedure expects a parameter which was not supplied.

    Hello, All. Is there a way to make these two lines of code one line. comm.Parameters.Add(new SqlParameter("@p1",SqlDbType.VarChar,3)); comm.Parameters["@p1"].Value = textBox1.Text; Thought it would be simple.... like comm.Parameters.Add(new SqlParameter("@p1",SqlDbType.VarChar,3).Value =...
  13. pdbowling

    Newbie, summarizing a group CR10

    Hello, Everyone. I am new to Crystal. I am coming from SSRS, so the tools are quite unfamiliar to me. I have a report that looks like this. Jones $5 Jones $10 Jones $20 Smith $1 Smith $5 Smith $5 Smith $10 Carter $5 It is a simple "Select LastName, Amount From myTable". I want to...
  14. pdbowling

    Updating a comboBox on a different tab.

    Hello, Everyone. I am using MS Access 2010 Version 14.0.61.29.5000. I have a form that I am supporting. It has several tab pages. I need to get a combox on page3 to update when I change a combobox on the main tab (page1). I tried to do this on the onchange event but ran out of intellisense...
  15. pdbowling

    Increasing allocated disk space.

    Hello, All. I have a citrix server that filled up. It had 132KB left. I cleared out the temp folder freeing up about a Gig so that production could move forward for a little while. I really need to increase the size of the allocation for c: This is the current allocation: c: 1.07 GB Free of...
  16. pdbowling

    Drive taking up more space than all of its files

    Hello, Everyone. I am supporting a production environment while the network guy is on vacation. I go and look (remote in to a server) and see this: C:\ 13.8 GB Free of 71.9 GB 59 GB of files +13 GB Free ~ 72 GB Drive E:\ 1.58 GB Free of 64.6 GB 46.8 GB of Files + 1.58 GB Free != 64.6...
  17. pdbowling

    rdl shows as html

    Hello, All. Alright, I have a project solution (sln file) for BIDs on a server. When I typically work on SSRS reports, I just go double click that project (sln file). Today I was toying with the idea of starting a new project, so I launched BIDs from my start menu. I added one of the server...
  18. pdbowling

    Column in recordset is null

    Hello, Everyone. I am maintaining javascript code from another developer on Internet Explorer 8. I have a recordset that returns only one field and that field is null. A record exists but the value of the field is null. I tried testing for null in the field value but I am missing something...
  19. pdbowling

    How does joining without 'JOIN' work?

    Hello, Everyone. I am using SQL Server 2008. I am reviewing code from a previous developer and I do not understand something I am seeing. I get the concept but the specifics of how it works are escaping me. I was trained to use JOIN to join tables, not list tables and force comparison in a...
  20. pdbowling

    Displaying Multi-Select parameters.

    Hello, Everyone. I am using BIDS 2008 with SQL Server 2008. I am troubleshooting someone else's report that is giving bad results. Firstly, it has a parameter where 'Allow Multiple Values' is selected. When passing the multiple parameters to the report, the author did not...

Part and Inventory Search

Back
Top