SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Calculate Target Column

  Hi, I have below table Sum of AP1 = 1764. I need to sql query to calculate Target column for Week …

  selpoivre

  4 replies

  4 years, 11 months ago

  By: Mr. Brian Gale

• New 2012 r2 server & SQL 2012 set up

  I'm a novice at best working with servers and SQL so please bare with me as I learn. I've installed…

  alhusketh

  4 replies

  4 years, 12 months ago

  By: alhusketh

• MSSQLSERVER service will not start

  Good Morning - I have a SQL Server 2014 that I inherited that I use as backup server.  I would like…

  berndta

  8 replies

  5 years ago

  By: Jeffrey Williams

• Get the difference from one record to the one previous

  In it's simplest form I want a table that I can use to store my Household energy readings, Gas and …

  Meridian9300

  6 replies

  5 years, 2 months ago

  By: Meridian9300

• SQL Server – Transact SQL - varbintohexsubstring

  Hello there, I need your appreciated help. My version is : Microsoft SQL Server 2005 - 9.00.1399.06…

  guido1971

  1 replies

  5 years, 2 months ago

  By: Daniel Adeniji-180202

• export stored images to disk

  My movie collection has all dvd covers of every film stored inside the sql server database . Worked…

  SZ

  3 replies

  5 years, 3 months ago

  By: MVDBA (Mike Vessey)

• multiple result sets

  My work has a small database for our system. It's not maintained by a DBA but the programmer. So, i…

  doc1623

  5 replies

  5 years, 4 months ago

  By: Chris Harshman

• Extract pdf file from a sql db

  I have pdf files stored in my sql db and would like to extract them to a folder. I have a script th…

  Mark LaRosa

  3 replies

  5 years, 4 months ago

  By: mconroy

• Run a query against registered servers and insert results into table

  Hi all, Is it possible to run a query against multiple registered servers and have the results ins…

  Staggerlee

  19 replies

  5 years, 5 months ago

  By: a.spijker

• Table fillrate and other info!

  Hi Guys, Been looking for a really simple udf/proc.. I want to be able to quickly gather: - the min…

  super101

  16 replies

  5 years, 6 months ago

  By: Madhivanan-208264

• How do I know if my SQL server has sufficient physical memories?

  As I understand SQL server instance will reserve a chunk of physical memory once it's started thus …

  JasonO

  2 replies

  5 years, 6 months ago

  By: Brahmanand Shukla

• Where Clause on Dynamic Pivot causes error

  Hello Im having issues with my stored procedure. The procedure has this query that uses dynamic piv…

  kosaks

  6 replies

  5 years, 7 months ago

  By: kosaks

• Sql to update active row

  I have below two tables EMpbasetable: Skey,EmployeeNumber,Startdate,EndDate,Active 3,123,2019/06/1…

  selpoivre

  1 replies

  5 years, 7 months ago

  By: Steve Collins

• Best way to compare data/tables between SQL and Oracle

  Hi I have to do a data compare. Currently, we are running two databases in parallel. 1 database is …

  zwheeler

  4 replies

  5 years, 7 months ago

  By: sm111

• sql server Jobs Icon.

  I'm new to the SSA and I'm trying to track down why a job is "supposedly" not running. It looks li…

  CptCrusty1

  3 replies

  5 years, 7 months ago

  By: Billy The Mexican