SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Calculate Totals for ID numbers that have more than one entry

  Hi, I have a table with about 700 rows, 100 ID numbers that have more than one entry. I need to add…

  emmettjarlath

  4 replies

  13 years, 2 months ago

  By: emmettjarlath

• stored procedure slower than query sql server 2000

  friends, When I running a Stored Procedure in sql 2000 query analyzer, it take 35 seconds. But when…

  ssa2010

  2 replies

  13 years, 2 months ago

  By: Sean Lange

• Disable email notifications in SQL Server Agent

  I'm trying to disable the email notification that I originally set up in the Job Properties of a SQ…

  kathy o

  3 replies

  13 years, 2 months ago

  By: Lynn Pettis

• Unable to connect to Database from sqlserver enterprise manger

  Hello All, I have all the credentials handy but still I couldn't connect to a database from enterpr…

  pragyan.banerjee

  1 replies

  13 years, 2 months ago

  By: Lowell

• DBCC Transaction Logs - How to read/interpret

  Hi Guys, How to read/interpret the transaction logs displayed by DBCC command? can I convert the re…

  Klarence A.

  8 replies

  13 years, 3 months ago

  By: Eric M Russell

• Update the duplicate records in SQLserver

  Hi, i am loading data from text file to the db using a dts package.it involves follwing stages 1)l…

  giribabugeda-633679

  3 replies

  13 years, 3 months ago

  By: avanch-990710

• Error 512: Subquery returned more than 1 value....

  Hi everyone, Can anyone plz help me to solve this issue. In my SQL Server Enterprise Manager, when …

  Muneeb Ahmed

  6 replies

  13 years, 4 months ago

  By: fcastilloa

• Change Excel file name when exporting with DTS Package

  Hello, I need to export data from SQL Server 2000 to an Excel file daily. I'd like the file to be n…

  teddy.sincire

  3 replies

  13 years, 4 months ago

  By: TeraByteMe

• Updating Table Approach

  All, I have 2 tables Provider_Status_Meta_Data with columns (Code, Display_Status, Description, ...…

  pawana.paul

  2 replies

  13 years, 4 months ago

  By: krishnavamshi24

• How to Eliminate SET QUOTED_IDENTIFIER ON and SET ANSI_NULLS OFF from generated scripts

  When I do some setting ONCE (7 years ago) and never need to do it again, I tend to forget where it …

  CartoonHead

  1 replies

  13 years, 4 months ago

  By: blandry

• Update Script to select

  Hello everyone, any can help me to this script i want to enhance this script into fastest way, beca…

  Ayie

  10 replies

  13 years, 5 months ago

  By: jswong05

• Script or formula to calculate Fiscal Week.

  Hello. I have been asked to create an excel spreadsheet as a template for tracking projects usiing …

  k.kue.vang

  1 replies

  13 years, 5 months ago

  By: GSquared

• How to display the first and second Doctor to see a patient?

  I have to create a table where there are lots of columns pulling date from one table and two views.…

  t_bolden

  2 replies

  13 years, 6 months ago

  By: ChrisM@Work

• Retrieving extra rows........

  Hello everyone, I have this SQL that returns the correct amount of rows which should be 2: Select D…

  marge0513

  8 replies

  13 years, 6 months ago

  By: marge0513

• Update script NEEDED... Help.

  I have a BIG need to figure out an update script that will search through table MODS and checks for…

  kipp

  7 replies

  13 years, 6 months ago

  By: sgmunson