SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• 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

  10 years, 1 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

  10 years, 1 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

  10 years, 1 months ago

  By: Eirikur Eiriksson

• divide by zero error even after predicate filters zero values inside cte with LEAD function

  Hello community! The following code has baffled me and my friend (he found this). Sample data is at…

  ColdCoffee

  3 replies

  10 years, 1 months ago

  By: ChrisM@Work

• What are the advantage of using cross apply over union all?

  What are the advantage of using cross apply over union all?

  mynkdby

  9 replies

  10 years, 1 months ago

  By: Jeff Moden

• Filtering within a group or figuring out how to loop through results

  I have the following data DROP TABLE mytable; CREATE TABLE mytable( cst_org_name_dn VARCHAR…

  Stephen crocker

  5 replies

  10 years, 1 months ago

  By: Stephen crocker

• difficult group question

  Hi, I want to group the following table but it must be grouped using a data range. Difficult to exp…

  yvesql

  4 replies

  10 years, 1 months ago

  By: drew.allen

• Inserting rows into the pivoted and updating the date intervals and values based on input.

  My resultant table holds data as: Id A B C ValidFrom Val…

  arihantjain121189

  1 replies

  10 years, 2 months ago

  By: ChrisM@Work

• Recreating tables from a list of tables

  Hi I need a script to recreate a list of tables stored in a table. The fields have to be in the sam…

  Andre 425568

  21 replies

  10 years, 2 months ago

  By: Andre 425568

• Beginning and End of Year, Month, Etc.

  Our weeks run Saturday through Friday. The month the week falls in is determined by Saturday's date…

  swansonm

  7 replies

  10 years, 2 months ago

  By: swansonm

• insert into the table based on intervals

  Create table FinalResult (Id int, A int, B int, C int, D int, E int, Va…

  arihantjain121189

  1 replies

  10 years, 2 months ago

  By: John Rowan

• Geting the Date from the record with max value

  Hi Hope someone can help me out I have a table like the one Below TagIndex DateAndTime …

  tinojoergensen

  7 replies

  10 years, 2 months ago

  By: R.P.Rozema

• SQL authenticated logins and passwords

  Any ways to generate SQL logins with passwords ... Revlogin and other scripts will give the passwo…

  Abhishek

  2 replies

  10 years, 2 months ago

  By: R.P.Rozema

• Convert to CSV

  Hi there, Following code will do the job for me. But I wonder is there any other way to accomplish.…

  squvi.87

  5 replies

  10 years, 2 months ago

  By: ChrisM@Work

• Error while parsing a string with " & " as XML

  I have a snippet of T-SQL code that I use as a function. All it does is, take a string that has sev…

  SQLCurious

  6 replies

  10 years, 2 months ago

  By: R.P.Rozema