SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Joining tables with sub-queries and count

  HI, Here my sample data and query. I am getting error while using the count with sub queries. Sampl…

  salman-pc

  2 replies

  9 years, 7 months ago

  By: The Dixie Flatline

• remove duplicate values in a view , without affecting main tables

  I just need at the end of the view remove the records where if StudentTransportOrder has two instan…

  joanna.seldon

  12 replies

  9 years, 7 months ago

  By: joanna.seldon

• Query output not display in HTML format

  Hi.. I have tried and developing one email report from database server. Email Notification received…

  SQL Galaxy

  18 replies

  9 years, 7 months ago

  By: Ed Wagner

• Do not SELECT if in Table B

  I have the following query for auditing contained sql logins in my sql server instance: SET NOCOUNT…

  Michael_O

  1 replies

  9 years, 7 months ago

  By: Gail Shaw

• Table Row Counts

  Hi Is there a single query that will list the table row counts for all the databases in an instance?

  jdbrown239

  6 replies

  9 years, 7 months ago

  By: jdbrown239

• Remove 'spaces' from DB backup filename

  I need some help to remove the spaces from my backup job... Its outputting as: "dbname_DD MMM YYYY.…

  J2B

  4 replies

  9 years, 7 months ago

  By: Jeff Moden

• CALCULATING DELAY SECONDS

  CREATE TABLE DELAYSECONDS( ProgramID INT, ID INT, ContractHeaderID INT, ContractStartTime TIME, Pro…

  JALLY

  13 replies

  9 years, 7 months ago

  By: Phil Parkin

• Create Unique identifier from text

  Hi, I have a text example given below : SPIT10IHOPIGACSystem SPMGS2IHOPIForecastingandPlanningProce…

  PSB

  9 replies

  9 years, 7 months ago

  By: Alvin Ramard

• query that returns seconds

  hello, i need help with this query. i will work you through the process maybe ii can be assisted …

  JALLY

  13 replies

  9 years, 7 months ago

  By: JALLY

• Finding Friends and Mutual Friends.

  I am trying to build a query. The requirement is to get the number of mutual friends between two us…

  KnowledgeSeeker

  4 replies

  9 years, 7 months ago

  By: Joe Celko

• BULK INSERT from multiple objects

  Hello All, Need your advise, please: I have to scan a folder for a given type of files, e.g. ".sql…

  BOR15K

  2 replies

  9 years, 7 months ago

  By: BOR15K

• Do Not Return Matching Rows

  Hello Everyone I hope that you all are having a wonderful Database Day. I ran into a rather odd kin…

  AndrewSQLDBA

  9 replies

  9 years, 7 months ago

  By: ScottPletcher

• Help with a PIVOT

  Hi All I am having a bit of nightmare with a pivot query. When I say nightmare... I am nearly there…

  pnr8uk

  13 replies

  9 years, 7 months ago

  By: The Dixie Flatline

• Check if both fields from table B are in table A

  Hello, I have a table, we can name it table B that has two fields, parent_id and child_id. I wan…

  Franco12

  9 replies

  9 years, 7 months ago

  By: Franco12

• Duplicate Record In Result

  i have problem in my below query.. when i select record separately.. 2 records shown as desired. b…

  Messi

  3 replies

  9 years, 7 months ago

  By: ChrisM@Work