SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Substitute for First function

  Looking for assistance, converting from access, I want the first temperature from a list of persons…

  te_<3

  3 replies

  11 years ago

  By: Lynn Pettis

• However, a series of effects

  However, a series of effects on the basis of the masculine and the level of testosterone. Manufactu…

  vtcxoihmmhdx

  1 replies

  11 years ago

  By: Lynn Pettis

• Virtual Labs

  Hi Guys, Does anyone know where I can make use of virtual labs to practice some things. I have trie…

  crazy_new

  3 replies

  11 years ago

  By: crazy_new

• selecting data from sql server and outputing the data to multiple tabs in a Excel spreadsheet

  Does anyone have an example of writing data extracted from sql server to mutliple tabs within an Ex…

  ericwenger1

  1 replies

  11 years ago

  By: KS

• Query execution plan

  Hi Guys, Is it possible to check query execution plan of a store procedure from create script (befo…

  salamlemon

  1 replies

  11 years ago

  By: Gail Shaw

• Reset Admin Password

  Hi, I have a local instance of SQL 2012 express, somehow my admin privileges have been lost, and th…

  Simon Hundleby

  1 replies

  11 years ago

  By: Simon Hundleby

• msdb suspect pages from log file? SP1 CU9

  Good Day SQL Gurus, We found an interesting 'issue' in one of our productive user database: The out…

  JimmyJones

  1 replies

  11 years ago

  By: JimmyJones

• Dope 2015 Movie Review

  Watch Inside Out 2015 Online Watch Dope 2015 Online Watch Infinitely Polar Bear Online Watch Mangle…

  shametony

  1 replies

  11 years ago

  By: Stuart Davies

• Help me with the SQL SYNTAX Please

  A table had values like NOTRPT'D ( Wjhat I mean is there can be one or more single quotes in the …

  mw_sql_developer

  5 replies

  11 years ago

  By: TomThomson

• converting fahrenheit to celsius

  I'm knew to Sql, I've tried many variations, and I keep getting errors, assistance would be greatly…

  te_<3

  1 replies

  11 years ago

  By: Luis Cazares

• xml to pdf using sql server

  Hi, Convert 100 xml files individually to pdf's and zip them in a folder along with the source file…

  gosven07

  3 replies

  11 years ago

  By: gosven07

• Adding T272 trace did not correct identity column 1000 jump

  Hi - After SQL server service restart, a column which is set to auto increment jumped 1000. To fix…

  lsalih

  3 replies

  11 years ago

  By: lsalih

• How do I do a search on a string ( But I need it to be case sensitive )

  Select * FROM TAB1 wher AI_TEXT_VALUE like '%PE%' The unfortunate thing is i get entries like <…

  mw_sql_developer

  7 replies

  11 years ago

  By: Jeff Moden

• Indexing a view

  Hi all I've created a table which will hold staffing data (name, grade, etc.) and any shifts that a…

  richardmgreen1

  3 replies

  11 years ago

  By: sgmunson

• Group By in Sub query

  Hello All, I have to use a Group By in Sub query that will give me my desired results. SELECT coun…

  sakmsb

  8 replies

  11 years ago

  By: sakmsb