SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Update statement will not update data beyond 7 million plus rows out of 38 millions rows. HELP!!!

  Hi All, I run the following statement and it will not update beyond 7 million plus rows and I have …

  davidsalazar01

  5 replies

  11 years, 1 months ago

  By: Jeff Moden

• Load Folder name and Images into SQL Tables

  Hello Everyone. I need to load images from folders into a SQL Server table and I have done it succe…

  robertdba

  17 replies

  11 years, 1 months ago

  By: Jeff Moden

• Convert column data into row data

  Hello, I have data like this in a table ID test_date Score 001 4/1/2014 …

  fliu2265

  1 replies

  11 years, 1 months ago

  By: Luis Cazares

• SSRS: <Flat File Source Error Output Column> CodePage=65001, how to set it to 1252 ?

  Hi, all I got that weird situation when I tried to get SSIS error redirection sample, my flat file …

  mario17

  2 replies

  11 years, 1 months ago

  By: mario17

• Strange result....

  Hi,first of all, sorry for my English... After 8 years in oracle we are moving to MSql and i'm havi…

  adiaz 16837

  4 replies

  11 years, 1 months ago

  By: adiaz 16837

• Query that generates values by date range

  Hi, I have a table that stores Terminal ID, Product Name, Cost and Effective Date. I need to genera…

  legeboka

  4 replies

  11 years, 1 months ago

  By: Jason-299789

• How to clear MSmerge_genhistory table data

  Hi friends, I noticed in my one database the table update query is slow in merge replicated tables.…

  manju.ccc

  1 replies

  11 years, 1 months ago

  By: Shafat Husain

• 42% of 100% taken in clustered index insert

  I have a query which is primarily a victim of blocking and a blocker itself for other queries. I st…

  npranj

  12 replies

  11 years, 1 months ago

  By: Grant Fritchey

• Help with number / percentage format

  I'm trying to get a calculation based on count(*) to format as a decimal value or percentage. I kee…

  jsqldba

  5 replies

  11 years, 1 months ago

  By: Jeff Moden

• SELECT a String

  Hi I have string as below: InvoiceTemplateId= SOURCE.InvoiceTemplateId ,Name= SOURCE.Name ,Detail…

  Steve Dell

  3 replies

  11 years, 1 months ago

  By: Jeff Moden

• growth above normal log database!

  I have a 800GB database and have done the maintenance reindex dawn that is taking on average four h…

  rmedeiros

  7 replies

  11 years, 1 months ago

  By: Jeff Moden

• In SQL Server 2012 Imports (using SQL Server Import And Export Wizard) from web server where a datatype - "datetime" but in local sql 2012 server change datatype to "smalldatetime"

  how to solve In SQL Server 2012 Imports (using SQL Server Import And Export Wizard) from web serve…

  haldar.dinesh

  2 replies

  11 years, 1 months ago

  By: Phil Parkin

• Pivoting hierarchial data

  I'm having some issues getting this one. I have a table that has a hierarchical employee structure…

  Jeff Shurak

  8 replies

  11 years, 1 months ago

  By: Jason-299789

• Wrapping CASE in MAX() - Performance hit?

  Hi guys, I have 'adopted' a view written by someone else on my team. The view creates a GROUP BY a…

  aaron.reese

  4 replies

  11 years, 1 months ago

  By: Luis Cazares

• evidently confused on temp table scope

  I have a stored proc that calls a few other stored procs. I've included an edited version of it at…

  DSNOSPAM

  30 replies

  11 years, 1 months ago

  By: sqldriver