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

    Need Help Calculating Months Excluding Same Month

    SQL Server 2005 sp3 This is driving me nuts. It's probably a simple solution but I'm just not seeing it. We have a table of employment records like this (simplified): ID fromDate throughDate type ---- ---------- ----------- ---- 1 2009-08-02 2010-09-12...
  2. DatabasePrincess

    Replication Monitor 2005 and 2008 – Publishers Missing or Deleted

    I have SQL Server Management Studio 2005 (9.0.4035) and 2008 (10.0.2531) installed on my computer (Windows XP). Today when I opened the replication monitor in SSMS 2005 connecting to a SQL 2005 server, all of my publishers (SQL 2005) were either missing or had a red X on the name. I re-added the...
  3. DatabasePrincess

    SQL 2005 SP3 Error 17310 Severity 20 EXCEPTION_ACCESS_VIOLATION

    Hello all! When I run T-SQL to drop and re-create a specific stored procedure on a development server, I get a stack dump every time and it disconnects my session from the server. Server Info: SQL Server 2005 SP3 (9.0.4035) Windows Server 2003 Standard SP2 2 GB RAM The procedure contains a...
  4. DatabasePrincess

    Rotate text so writing mode is from bottom to top

    Using Reporting Services 2005, does anyone know how to format a column cell in a matrix so that it reads from bottom to top? I have the writing mode set to tb-rl but it reads from top to bottom. Can this be rotated so that it reads from bottom to top instead? Any help is appreciated! Thanks! :-)
  5. DatabasePrincess

    Join Question

    Hello all, I'm a bit rusty with database development and am hoping someone could help me figure something out. Normally when I write select statements with joins, I don't include things such as "and codeDeleteFlag = 'N' " as part of the join clause. I usually put this in a where clause. Is it...

Part and Inventory Search

Back
Top