SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Row number with Pivot

  Hi all, Need some expert help!. Have a pivot that I use to transpose rows to columns (dynamic pivot…

  kevin 26531

  10 replies

  9 years, 9 months ago

  By: kevin 26531

• jdbc and distributed transaction defaults

  Hello. It seems that the jdbc connector is defaulting to distributed transactions. We have a stored…

  PHXHoward

  1 replies

  9 years, 9 months ago

  By: PHXHoward

• Duplicates and ROW_NUMBER ()

  Dear All, We use ROW_NUMBER () to partition results and hand-pick the needed records, mostly to add…

  etl2016

  6 replies

  9 years, 9 months ago

  By: Matt Miller (4)

• Need to retrieve logon trigger from DB backup

  A logon trigger was added and dropped from our production DB. I have full DB backup after the trigg…

  G33kKahuna

  11 replies

  9 years, 9 months ago

  By: Sergiy

• Query taking 6 hrs and counting (HELP!)- how to concatenate rows into single string

  My table looks like this email project_name test@test.com lab1 test@tes…

  IA123

  22 replies

  9 years, 9 months ago

  By: Sergiy

• Sequential read from table

  I am fairly new to T-SQL and have some experience in Oracle PL/SQL. Here is the case: I have to rea…

  TomD-982312

  18 replies

  9 years, 9 months ago

  By: Eric M Russell

• PK/FK Relationship Question/Help

  Hi Guys, I have quick two quick questions. 1) I have a task where I have to read the data from a f…

  rocky_498

  3 replies

  9 years, 9 months ago

  By: GSquared

• "Conversion failed when converting date and/or time from character string" when using table that stores date functions

  Hello, I have a table that stores date functions as nvarchar that I would like to use in SQL to ex…

  erouse

  8 replies

  9 years, 9 months ago

  By: erouse

• ETL procedure for a Table with sparse columns

  Hi, I have got requirement to create store procedure for ETL process, ideally using merge and Match…

  Sangeeth Raj

  1 replies

  9 years, 9 months ago

  By: Lowell

• compare one Master table one column rows with other table column names

  Hi, I have come across the requirement to check whether the column name of 20 tables are same or no…

  Sangeeth Raj

  1 replies

  9 years, 9 months ago

  By: Igor Micev

• Looping across databases

  Dynamic SQL is not my forte. Can someone give me a hand and tell me how to loop this TSQL code acro…

  sql-lover

  7 replies

  9 years, 9 months ago

  By: Phil Parkin

• query calculation based on group by columns for different logic

  Hi All, I have table like below but i need to calculate divison of two columns based on group by de…

  aniletc37

  2 replies

  9 years, 9 months ago

  By: John Mitchell-245523

• can i use set xact_abort on, in place of begin try cashe to rollback, in reporting stored proc becasue they do not insert update in database.

  hi, due to some reason my report queries are blocking the entry ? so i decided to put following…

  rajemessage 14195

  4 replies

  9 years, 9 months ago

  By: rajemessage 14195

• Create or update rows on the basis of time interval

  SQLTeam.com Forums If someone answers your question or provides a helpful response, please take a s…

  arihantjain121189

  16 replies

  9 years, 9 months ago

  By: J Livingston SQL

• Calculating disk space

  Good day experts, I am going through some sql queries on my envronment.There is this query below wh…

  tmmutsetse

  3 replies

  9 years, 9 months ago

  By: Eirikur Eiriksson