SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• To Get fixed periodic rownumbers by rounding the number to closest integer

  I am giving example of what I am looking for below: Any help is appreciated we have 43000 records a…

  harishyarlagadda2020

  5 replies

  10 years, 2 months ago

  By: Eirikur Eiriksson

• Help me about Attach database

  I attach a DB from soucre on Disk then I get an error message from SQL

  Mr Phong

  2 replies

  10 years, 2 months ago

  By: Jeff Moden

• Comma separated values

  Hi, I need a comma separated list of values for GeoMarkets when it falls into a certain criteria CR…

  PSB

  4 replies

  10 years, 2 months ago

  By: Jeff Moden

• LEAP and LAG behind the scenes

  I read an article that LEAP and LAG reduces the efforts of writing code to do a self join in order …

  rs80

  21 replies

  10 years, 2 months ago

  By: Jeff Moden

• Interpreting JSON data in SQL Server for Reporting purpose

  Hi Folks, We have a gaming application which generates transactional data in MongoDB which eventual…

  chandan_jha18

  10 replies

  10 years, 3 months ago

  By: SQL Daddy

• Problem: DELETE table_or_view FROM table_sources removes all rows

  We recently discovered an error in a simple DELETE statement. Due to a missing line the (oversimpli…

  gserdijn

  3 replies

  10 years, 3 months ago

  By: gserdijn

• Changing the column name dynamically

  Hi All, Below is the sample query Select Month1,Month2,Month3......Month24 from #temp I need to d…

  koti.raavi

  7 replies

  10 years, 3 months ago

  By: Jeff Moden

• Using Count(*) Over incorrectly?

  I am trying to write a query solution based on the following requirements: "The FinalCalledPartyNum…

  Dobbs77

  6 replies

  10 years, 3 months ago

  By: Dobbs77

• change the element position on join and xml auto

  HI, in the following query i've this result: <Main> <Tags> <Docs> </…

  fabriziodb

  2 replies

  10 years, 3 months ago

  By: drew.allen

• Getting analysis sums for each row in a table

  Hello, I am able to get various totals summed up from varying row numbers of this table CREATE TA…

  stevennjuki

  16 replies

  10 years, 3 months ago

  By: stevennjuki

• How to do IN statement as a parameter

  I'm trying to convert some dynamic SQL in .NET into a Stored Procedure. What is the best way to pas…

  Sean Grebey

  14 replies

  10 years, 3 months ago

  By: Eirikur Eiriksson

• Collation Issue with Restore on different SERVER

  Hi Gents, I have just restored a database from another Server but after restoring realised that the…

  Shazme

  4 replies

  10 years, 3 months ago

  By: Shazme

• Using SELECT as 'IN' predicate condition for PIVOT

  Hello, I am trying to use a SELECT statement as my IN condition in a PIVOT and I am not having any …

  matt.warren 33350

  10 replies

  10 years, 3 months ago

  By: matt.warren 33350

• MDX error : The restrictions imposed by the CONTRAINED flag in the STRTOSET function were violated

  Hi, I'm getting the error "The restrictions imposed by the CONTRAINED flag in the STRTOSET function…

  pmaceke

  1 replies

  10 years, 3 months ago

  By: gsc_dba

• Cast as Numeric

  I was trying to divide by 0, but then learned I have to Cast as Numeric. not sure how that works, I…

  jeffshelix

  6 replies

  10 years, 3 months ago

  By: Eirikur Eiriksson