SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Combine data of 3 tables into a single row

  HI, 😀 I have a situation where I am trying to collect information from three Tables in a single row…

  zaleeu

  33 replies

  14 years ago

  By: ACinAZ

• Maintenance Plan Not Working

  Hello everyone. I've set up a maintenance plan scheduled to back up a database after work hours. W…

  troe_atl

  12 replies

  14 years ago

  By: Ninja's_RGR'us

• I need help copying data within 2 tables

  I want to duplicate a row in table 1 changing only the uniqueidentifier (this I can do). Table 2 …

  wishIknewSQL

  10 replies

  14 years ago

  By: OTF

• How do we get the most resent row

  I have serval historical rows for a case on a history table and I need to get only the most rest up…

  laura.walker

  7 replies

  14 years ago

  By: laura.walker

• Can we implement

  Hi can we implement snapshot replication using the snapshot that is generated by Transactional Rep…

  RaviShankar1234

  3 replies

  14 years ago

  By: ps.

• Cant get my head around this error???

  Hi Guys, I am having some trouble getting a stored procedure to run, I think it is something to do …

  methexis

  6 replies

  14 years ago

  By: Gail Shaw

• RIGHT function error

  Hi everyone, PLease see the snippet below: this is a dataset from my ssrs report. Wonder, whats mi…

  SQL_path

  3 replies

  14 years ago

  By: checkai

• Simple Update Query

  Hi, This is really simple. This is what I have: UPDATE Community Set NetworkLogin = 'c' & ID W…

  bduff

  5 replies

  14 years ago

  By: Ian Scarlett

• string concatenation

  I should have three columns in custom export segment,fieldid and fieldpipedId. Segment has segments…

  sreeya

  1 replies

  14 years ago

  By: Ninja's_RGR'us

• Check for replication tables

  Hi, Can any one let me know what are system tables that we need for for XXX publication on which se…

  RaviShankar1234

  2 replies

  14 years ago

  By: Steve Jones - SSC Editor

• How can I sum the number of attributes from one table and export the count to a temp table as columns with 1 row per unique key?

  Hi Guys, I have a table of data with invoice line data in it (each invoice line = 1 row so invoice …

  markie76

  7 replies

  14 years ago

  By: markie76

• Please help with Query

  I am running a query collecting data from multiple tables and connecting it to a master part number…

  david 98157

  9 replies

  14 years ago

  By: Jeff Moden

• SSIS -> Lookup Transformation Override

  Hi, I am new to SSIS and practicing Lookup Transformation. I am trying implement the following quer…

  Joice

  8 replies

  14 years ago

  By: Joice

• Which SQL Server version to buy?

  Hi, I'm trying to confirm the right version of SQL server. I'm after SQL Server 2008 Standard - 5 c…

  Floob

  6 replies

  14 years ago

  By: Floob

• Move sqlServer to different drive w/o re-install - is it possible ?

  Hello all. I do sys admin work for a small network but I rarely do anything with sqlserver and don…

  usersafesql

  3 replies

  14 years ago

  By: george sibbald