SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Return query with concatenating values.

  I have two tables i am working with, they are "Institutions" and "InstitutionOversights". The relat…

  djacobos

  3 replies

  11 years, 10 months ago

  By: djacobos

• SQL works fine, but doe's not work called by a Stored Procedure

  Hi, I have this code working fine: DECLARE @startdate datetime = convert(datetime, '2013-05-24 20:…

  lukavog

  5 replies

  11 years, 10 months ago

  By: Keith Tate

• A "special" stored procedure problem

  Hi guys! I'm not saying that actually have a problem... 😛 I have this table: ID(int) | START(date…

  lukavog

  6 replies

  11 years, 10 months ago

  By: lukavog

• Read all values from an xml node

  Hi All, I have the following code and trouble reading values of Bank Accounts. If i remove the line…

  kumar-378458

  2 replies

  11 years, 10 months ago

  By: kumar-378458

• query to return top 10 tables on each db on server

  i need a query to return the top 10 tables in each database on a server. have used EXEC sp_msforeac…

  gchappell

  3 replies

  11 years, 10 months ago

  By: gchappell

• Stored procedure - how to return a single table

  Hi 😛 I have this SP ALTER PROCEDURE GetDelayIntervalData(@start datetime, @stop datetime, @step in…

  lukavog

  1 replies

  11 years, 11 months ago

  By: Sean Lange

• 2 records at a time?

  Hi everyone, I'm not even sure how to word this succinctly enough to search for this topic, so I ap…

  jessica.green2312

  8 replies

  11 years, 11 months ago

  By: jessica.green2312

• Select Data from XML - Objects within Objects

  I am toying with the idea of passing serialised objects to a stored procedure for the purpose of da…

  BeerBeerBeer

  1 replies

  11 years, 11 months ago

  By: BeerBeerBeer

• BCP for .xml Export Error

  Hi All, I'm trying to export some tables from SQL Server 2012 into .xml format in a local drive and…

  nathans 30006

  1 replies

  11 years, 11 months ago

  By: Eric Nordlander

• How to reduce the joins in sql querry

  Hi I have select query with 10 Joins in place with different i want to improve the performance of …

  mpradeep23

  11 replies

  11 years, 11 months ago

  By: TheSQLGuru

• SQL Report Builder

  Hi, Not sure where to put this... Im working in SQL Report Builder (sorry dont know which version) …

  mark.johnson 26410

  12 replies

  11 years, 11 months ago

  By: mark.johnson 26410

• Comma separated column output.

  Hi There, I need a query which results the output as comma separated for example , select name fro…

  vignesh.ms

  2 replies

  11 years, 11 months ago

  By: vignesh.ms

• Improving DELETE performance

  Hi, in a my stored procedure I need to use a DELETE statement and I cannot use the TRUNCATE TABLE. …

  pmscorca

  6 replies

  11 years, 11 months ago

  By: pmscorca

• How to insert data into table from linked server

  Hi all, I wonder if it possible to move data from tables on a linked server to a "normal database"?…

  SpeedSkaterFan

  8 replies

  11 years, 11 months ago

  By: Luis Cazares

• How to find whether an object is used by any sp , view ?

  How to find whether an object is used by any sp , view ? I need a query which will result the sp ,…

  vignesh.ms

  6 replies

  11 years, 11 months ago

  By: Lowell