SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How to insert from Table 1 to Table 2 only if record doesn't exist in Table 2.

  I'm inserting from TempAccrual to VacationAccrual . It works nicely, however if I run this script a…

  shezi

  4 replies

  11 years ago

  By: WayneS

• Can I have a few design ideas for my survey table design?

  Greetings experts, I am trying to design a survey with 6 questions and some comment text boxes. Use…

  simflex-897410

  5 replies

  11 years ago

  By: Michael L John

• Dynamic dataset and tables in ssrs

  Need to change a Excel report to SSRS. Excel report has around 15 tables all with different columns…

  sunnysoni88

  3 replies

  11 years ago

  By: sgmunson

• Query for LastYear same Month

  Assume I have a query like this select a.period, a.kode_lang, a.namaprod, a.kode_comp, a.k…

  yayan.m

  7 replies

  11 years ago

  By: Jeff Moden

• Issue returning unique rows

  I have the following query: Select p.Id [SenderId], p.Username, up.PhotoId, CASE WHEN…

  .Netter

  1 replies

  11 years ago

  By: ChrisM@home

• Getting duplicate data when connecting to another table.

  I have the following two tables: CREATE TABLE [MailBox].[Message]( [Id] [bigint] IDENTITY(1,1) NO…

  .Netter

  3 replies

  11 years ago

  By: Jeff Moden

• Preallocate locks a good idea?

  We have engaged a consultant that is recommending we, "preallocate the locks table" for better perf…

  jallmond

  3 replies

  11 years ago

  By: Gail Shaw

• SSIS challenge

  I have three tables in data base: customer product sales and i want to use SSIS package dynamically…

  nightowl23

  5 replies

  11 years ago

  By: Luis Cazares

• Help selecting records not between 2 dates

  I’m trying to extract a list of records that don’t appear between 2 dates and could use a bit of he…

  greggg

  14 replies

  11 years ago

  By: greggg

• Trigger to encrypt a column

  Can I accomplish encrypting a column with a trigger similar to below, but without the 'SSN' column?…

  triloba

  3 replies

  11 years ago

  By: ScottPletcher

• backup a table

  Hello, can you help me? I need to backup a single table in SQL server. I use SQL Server 2008 r2 and…

  brownjms34

  4 replies

  11 years ago

  By: Jayanth_Kurup

• Server is slow after restart

  Hi, We were getting below error 10 days ago: Timeout expired. The timeout period elapsed prior to …

  shirish_padekar

  2 replies

  11 years ago

  By: kkanaya

• SSIS "Unexpected error from external database driver (????????)." when run by a job on the server.

  I have an SSIS package that I created and it works fine in BIDS and when I deploy it to the server …

  Lenochka

  2 replies

  11 years, 1 months ago

  By: Lenochka

• How to delete tables in a database whose table names match a criterea

  The database has approx. 2500 temporary tables. The temp tables match a pattern such as APTMP... I …

  mpdillon

  11 replies

  11 years, 1 months ago

  By: Lynn Pettis

• Robocopy help

  Hi all, So I got the following example below to try to help me get these files copied from one loca…

  jonathanm 4432

  2 replies

  11 years, 1 months ago

  By: x