SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Specified SQL server not found

  All: We have VB.net application that connects to the SQL server 2005 DB. Occasionally we get the fo…

  ucbus 92278

  2 replies

  15 years, 5 months ago

  By: ucbus 92278

• Start Date of the Month

  Hi , Can Any one tell me how to get start date of the month.

  itskumar2004

  5 replies

  15 years, 5 months ago

  By: Jason Selburg

• How to get a stored proc to run on last day of month

  Since there's no way to schedule a job for the last day of the month, I've been working on a method…

  david.l.mulholland

  7 replies

  15 years, 5 months ago

  By: itskumar2004

• SQL Query from Excel VBA

  I've been receiving Run-time error 1004 when executing the macro. The error is being generated by t…

  photonicman

  15 replies

  15 years, 5 months ago

  By: RBarryYoung

• How to add a "Rank" column to a view on the fly using a self join.

  In an interview yesterday I was given this question: Given a table "Test" that has three columns …

  dtguin

  4 replies

  15 years, 5 months ago

  By: Jeff Moden

• convert non ansi join

  I am new to the sql server. I have below query which runs in SQL server 7 I need help to convert it…

  ritu.thatola

  17 replies

  15 years, 5 months ago

  By: SQLRNNR

• Query how to?

  I have to code a query to return a result set containing only the MemID's that are in the 2 org fro…

  nixaler

  2 replies

  15 years, 5 months ago

  By: Jeff Moden

• Removing duplicates and keeping 1 record with no PK

  I have an issue with my database with multiple duplicate customers that I need to get rid of. Basic…

  olie480

  22 replies

  15 years, 5 months ago

  By: Jeff Moden

• Cascade delete rule on multiple tables

  Hello: We have a database with multiple tables with primary foreign constraints defined. For some o…

  ucbus 92278

  3 replies

  15 years, 5 months ago

  By: Ron McCullough

• Statement referencing column that doesn't exist yet

  Hi, I am new, self taught etc. Im am trying to write a statement that will add a column to database…

  Matthew24

  11 replies

  15 years, 5 months ago

  By: Jeff Moden

• Cannot seem to get INSTALLSQLDATADIR to work for me

  I'm trying to install a default instance of sql server 2005 enterprise. I am working with a virtual…

  tnk

  4 replies

  15 years, 5 months ago

  By: tnk

• Selecting Contents from one table into another (Resolved)

  Hello community..., I seem to be having one of those senior moments this morning :w00t: I wanted to…

  SQL_Enthusiast

  1 replies

  15 years, 5 months ago

  By: PaulB-TheOneAndOnly

• SQL Exception : System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

  I have a vb.net application that calls a stored procedure to get the data. The stored procedure is …

  ucbus 92278

  3 replies

  15 years, 5 months ago

  By: ucbus 92278

• SSIS package seems to do the intended job, but hangs/doesn't close without reporting errors

  Okay, I’m an SSIS rookie, but I can take the heat. Let me have it if I’ve left out important detail…

  Kman

  2 replies

  15 years, 5 months ago

  By: Kman

• Enterprise Edit or Standard

  Hi All I have always thought that you can only use Enterprise edition when setting up mirroring but…

  little1

  9 replies

  15 years, 5 months ago

  By: SQLRNNR