SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Count of accounts per zipcode

  Can anyone advice how to do this. I am looking to count the account number per zipcode of a state.

  cbrammer1219

  8 replies

  11 years, 1 months ago

  By: aaron.reese

• Global Temp Table

  What is the maximum no.of global temporary tables can create in sql server

  satishthota

  4 replies

  11 years, 1 months ago

  By: Gail Shaw

• Insert xml(with multiple nodes ) into table with query

  Hey guys, please help me My xml is in below format: DECLARE @MyXML XML SET @MyXML = '<RS> &…

  suhailquadri

  2 replies

  11 years, 1 months ago

  By: suhailquadri

• Question on Stored Procedure

  Can some one tell me what should be the OUTPUT format of this query: I was expecting some average n…

  Port1433

  4 replies

  11 years, 1 months ago

  By: Alan Burstein

• Alternative to SQLDiag for diagnostic, DMV, and performance tuning... preferably portable solution

  I've googled and researched many different tools, but haven't found one that would be flexible like…

  Sheldon Hull

  2 replies

  11 years, 1 months ago

  By: Sheldon Hull

• TempDB Database

  how to know the limitation of number of objects(Maximum no.of objects allow tempdb database) in a t…

  satishthota

  2 replies

  11 years, 1 months ago

  By: Ed Wagner

• update query is slow

  Dear friends, I have a table which is using merge replication. So when I update the table by simple…

  manju.ccc

  13 replies

  11 years, 1 months ago

  By: Grant Fritchey

• Joining Three Tables with multiple record

  Dear All we need some help. We have Three Tables in sqlserver2012 Master Table OrderID P…

  umair2756

  2 replies

  11 years, 1 months ago

  By: ChrisM@Work

• CTE query - Long Load Time

  I have a CTE query that is used to fill in nulls on a history table. The With statement executes ju…

  pike_nicky

  6 replies

  11 years, 1 months ago

  By: ScottPletcher

• Dynamically grow a data file

  Is it possible to dynamically grow a data file for TempDB? I have some TSQL that I want to execute …

  MyDoggieJessie

  7 replies

  11 years, 1 months ago

  By: Jeff Moden

• Select All matches that clubs played with an interval less than three days between games

  Hi guys! I am trying to solve this select statement, but I can't do it. :/ ----- I have two tables:…

  rDrigu

  4 replies

  11 years, 1 months ago

  By: rDrigu

• Dynamically hourly data extraction in SSIS 2012

  Hi Folks, Please help me in below query. I am using SSIS package for pulling the data(last 2 months…

  BI_NewBie

  15 replies

  11 years, 1 months ago

  By: Jeff Moden

• t-sql 2012 not using parameters correctly

  I want the user to be able to select various customers based upon if the first name, last name, or …

  wendy elizabeth

  2 replies

  11 years, 1 months ago

  By: TheSQLGuru

• Bowling SQL

  1.How can I write a code for a stored procedure to pass data to make changes to a player’s score in…

  tabubere

  3 replies

  11 years, 1 months ago

  By: Jack Corbett

• create filestream for filegroup for a DB in SQL Server 2008

  Hi i have a DB in SQL Server 2008. and i wants to store file in DB. how can i create filestream for…

  armm1388

  1 replies

  11 years, 1 months ago

  By: Phil Parkin