SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Please Give Me the Query For Below Mentioned Resultant Tables.

  Hi All, I have two tables for example, tblCategories(CategoryID[INT],CategoryName[VARCHAR]) tblEmpl…

  venkidesaik

  8 replies

  12 years, 2 months ago

  By: saltpepo

• Simpler way to join all unique columns for a join?

  Here's the Union that I clearly can't do.... I have 30 tables of inspections, deliniated by *Inspec…

  kinderdesign

  2 replies

  12 years, 3 months ago

  By: Evil Kraig F

• HTTP 500 Error Occured when clicked on REPORT MANAGER URL

  Hi, I installed SQL Server 2012 on Windows Server 2008 R2. And I installed Enterprise Edition. Afte…

  Scott1336

  8 replies

  12 years, 3 months ago

  By: cporteous

• How to run.bat file via SSIS package

  I like to run the .bat file every 1/2 hr via SSIS package. Can you please help me how to write SSIS…

  premtg

  4 replies

  12 years, 3 months ago

  By: kiril.lazarov.77

• Multiple Aliases for a single Column

  Hello, I am new to SQL and have been asked to perform a query of our Dispatch database. Although I …

  dirtyshorellc

  4 replies

  12 years, 3 months ago

  By: Dwain Camps

• Generate sql script of a table schema in SQL 2000 through script

  I wrote some scripts for correcting my old sql 2000 db schema compared to new sql 2000 db. This is …

  ssa2010

  1 replies

  12 years, 4 months ago

  By: PaulB-TheOneAndOnly

• Modifying Column Size

  I have a 22gb database with a column called [var]. I need to change this column from decimal(12,5)…

  gbloom-998285

  10 replies

  12 years, 4 months ago

  By: Gail Shaw

• SQl server2008-split delimited values into three rows

  Hi, Iwould like to have the delimited values in one of the columns in sql server table to be split …

  arubala75

  1 replies

  12 years, 4 months ago

  By: Ron McCullough

• Syntax error converting datetime from character string while calling a function

  Hi Friends, I am trying to call a function (which returns month value when passing date as paramete…

  Neetu Sharma

  3 replies

  12 years, 5 months ago

  By: ChrisM@Work

• xp_sendmail - empty subject

  Hi, I am trying to send mail from SQL Server 2000 but when the email is delivered, the subject line…

  Rupert Woodman

  27 replies

  12 years, 5 months ago

  By: bhsim

• SSIS data retrieval

  I want to retrieve data from another DB to my warehouse using SSIS. Is it possible for the automati…

  simplekarthi

  1 replies

  12 years, 5 months ago

  By: Suresh B.

• Database Configuration

  Hi, I want to open Primavera P6, but the system asks me for configuration, when I started the follo…

  z_popal

  2 replies

  12 years, 5 months ago

  By: Stephen_W_Dodd

• How to update just the year in date fields (non datetime data type)

  Hi Guys, I have to write a script to update ALL date fields in the database my company's software u…

  nic79

  4 replies

  12 years, 6 months ago

  By: Ron McCullough

• SQL Server automatic startup

  I'm having a problem starting SQL Server service. I'm using SQL Server 2008 R2. It's troublesome fo…

  kampate

  1 replies

  12 years, 7 months ago

  By: Peter Maloof

• Track a stored procedure progress on front end.

  hi all, I have a VB dot net allplication which calls a stored procedure.This stored procedure is r…

  shweta-210049

  6 replies

  12 years, 7 months ago

  By: ig_feldman