SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• SQl if statement in where clause

  How do I make this a sql statement? ---------------------------------------------------------------…

  cvlasak

  4 replies

  10 years ago

  By: cvlasak

• Unable to dynamically add multiple excel files into SQL Server 2008

  Dear forum members, I have several hundreds of excel files that I must transfer data to SQL Server …

  Ashish Dutt

  4 replies

  10 years ago

  By: Ashish Dutt

• SP TO UPDATE COLUMNS MONTHLY

  I have 13 columns based on each month like 01MONTHAGO,02MONTHAGO,03MONTHAGO,...13MONTHAGO. I need t…

  navie22

  6 replies

  10 years, 2 months ago

  By: Jack Corbett

• Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

  SELECT ValveSections.PipeSystemID, ValveSections.PipelineID, ValveSections.OrionStationSerie…

  Tom-173069

  7 replies

  10 years, 3 months ago

  By: ChrisM@Work

• extracting column values when a part of the column value is known

  hi How can we extract a column values from database if we know a part of that column value. For ex:…

  t.mounika01

  6 replies

  10 years, 3 months ago

  By: Eirikur Eiriksson

• Sending email alert when SQL Server restarts

  Hi, Is there a way to setup email notification to be sent whenever SQL server (or server agent) res…

  vinayachandran_v

  10 replies

  10 years, 4 months ago

  By: dastagiri16

• something better than TRIGGER to send email after table populated with 20 items?

  In our SQL Server 2008 database is a table used to track success or failure of the refreshing of 20…

  KoldCoffee

  2 replies

  10 years, 4 months ago

  By: KoldCoffee

• Sum Three Columns From Two Tables

  Here is Table A: USE [C:\INETPUB\WWWROOT\ITARENA\APP_DATA\ITALCATALOG.MDF] GO /****** Object: Tabl…

  nkweke

  8 replies

  10 years, 5 months ago

  By: nkweke

• Stored Procedure drop table

  I am attempting to create a stored procedure that checks for a table and drops the table if it exis…

  brandy.britt

  8 replies

  10 years, 10 months ago

  By: brandy.britt

• Begginer in SQL Procedures

  Hi , below procedure with if else statements.Single query updates well but when i trying to do with…

  hvl.kala

  3 replies

  10 years, 10 months ago

  By: ChrisM@Work

• how open a excel from stored procedure

  Hi all i need open a excel file using store procedure, someone know how do it? claudia

  anonimato36

  1 replies

  10 years, 11 months ago

  By: Lowell

• How join two tables? Hierarchical table

  I have two table. Department is hierarchical table. Department --- id (int primary key) --- name (v…

  mesteruh

  1 replies

  10 years, 12 months ago

  By: Jeff Moden

• CTEs and UNION SELECT in STAR Schema

  Hi there, It seems I can't use old standbys like CTEs and UNION SELECT statements with STAR Schema …

  Janie.Carlisle

  5 replies

  11 years ago

  By: Koen Verbeeck

• regarding validations in stored procedure

  Hi all, 1.I have input parameters like @age,@date, @time And @gender and output parameter was @paid…

  p.avinash689

  1 replies

  11 years ago

  By: Stuart Davies

• SQL Server 2000

  Hi SQL Masters, Greetings! Do you have any idea where to pull these fields from sql server 2000? Se…

  Tsinelas

  6 replies

  11 years, 1 month ago

  By: Tsinelas