SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Update a column in the most recent record within a partition/group

  Hello All!! Greetings and Happy holidays! I am a newbie in SQL and I am trying to solve a problem. …

  skpanda4u

  2 replies

  9 years, 9 months ago

  By: skpanda4u

• How to dynamically create 12 rows per customer in a SQL Table

  I have a staging table of customer names, numbers, and sales data etc. I've been trying to write a …

  ciskypete

  9 replies

  9 years, 9 months ago

  By: ciskypete

• Rounding Multiplication of Decimal Field

  I am trying to create a script for a price increase. The current price displays as 4 decimals (20.…

  aberndt

  3 replies

  9 years, 9 months ago

  By: JustMarie

• How can I get the result like this? from one to many relation tables

  Hi,how can I get result like this: Create table T1 ( pid INT primary key identity(1,1), name var…

  Banbo Bird

  3 replies

  9 years, 9 months ago

  By: Banbo Bird

• Insert records that do not exist

  The below query parses correctly, but I'm not getting any records to insert. I want to insert recor…

  shank-130731

  9 replies

  9 years, 9 months ago

  By: MMartin1

• Transaction log-Error 9002

  Help appreciated here. I'm emptying a SQL server back end with ~15 tables, one of them is an Audit …

  a_ud

  5 replies

  9 years, 9 months ago

  By: Gail Shaw

• SQL Severity 22 alert.

  Early this morning we got a SQL Severity 22 alert. We have a SQL Server Enterprise environment (2 …

  jralston88

  1 replies

  9 years, 10 months ago

  By: jralston88

• converting xlsm to xls using a script task in SSIS

  i need to import a file that has macros without additional drivers installed. If I use the existing…

  NewbieCoding

  6 replies

  9 years, 10 months ago

  By: Jeff Moden

• Log file full-Unaable to run Backup log

  Good morning Experts, The transaction of log of a database got full.It is in FULL recovery model. I…

  coolchaitu

  8 replies

  9 years, 10 months ago

  By: Gail Shaw

• Update to remove trailing special characters

  Hi, I have a varchar column, DeliveryAddress, which, due to user-entry issues, occasionally ends up…

  tarr94

  7 replies

  9 years, 10 months ago

  By: tarr94

• 4 Table Cross Join

  Hi, I creating a database to manage license key usage within my organization. We reimage company co…

  acarre

  1 replies

  9 years, 10 months ago

  By: Luis Cazares

• Update a table with an aggregate function

  I have a table as below Table A ProbID 1 Describe Test the theory TableAID 1 an…

  SQLTestUser

  1 replies

  9 years, 10 months ago

  By: Alan Burstein

• writing queries that easily readable

  I have been told my queries are hard to read... Besides using #comments to explain blocks of code, …

  polkadot

  53 replies

  9 years, 10 months ago

  By: Gail Shaw

• DECLARE table variable explicitly or by using type?

  Hello, Just wondering if anyone has any performance measures with regard to declaring table variabl…

  bdcoder

  2 replies

  9 years, 10 months ago

  By: Gail Shaw

• replication error SQL 2008 R2

  I am trying to replicate a database to a remote location. I keep getting this error and a period of…

  teflonken2010

  2 replies

  9 years, 10 months ago

  By: SoHelpMeCodd