SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to get metadata info on table? please

  Hello Good Morning, I am using sql server 2008R2, it has a database called "MetCar" it has several …

  asita

  6 replies

  10 years, 6 months ago

  By: SQLRNNR

• Correcting query that updates rows of a table sequentially.

  I have a leave table in the following format: IF OBJECT_ID('tempdb..#Leave') IS NOT NULL DROP TAB…

  KnowledgeSeeker

  4 replies

  10 years, 6 months ago

  By: KnowledgeSeeker

• limitation on number of tables joined

  Hi, Is there a limitation on how many tables can be JOIN-ed? I have close to 20 tables to join, ea…

  etl2016

  7 replies

  10 years, 6 months ago

  By: Hugo Kornelis

• distinct from STUFF

  Hi, SELECT DISTINCT t1.ProjectUID,t1.BWF , t1.Deliverable , --Supressed data columns STUFF( …

  PSB

  8 replies

  10 years, 6 months ago

  By: PSB

• Row Number in SQL Server - need certain rows only

  Hi, I have below table: Col1Col2 Col3 RowNumber 123AXC 12/1/2015 1 123AXCVV 1…

  monilps

  6 replies

  10 years, 6 months ago

  By: Eirikur Eiriksson

• how to get customized day and week numbers for a given date range.

  Hi, I have a table with Date ranges for a Plan every year as shown below., I need to generate anot…

  msumangupta

  3 replies

  10 years, 6 months ago

  By: msumangupta

• Issue with using isowk

  I built a report 6 months ago that graphs sales figure for the previous three weeks from the run da…

  ps_vbdev

  4 replies

  10 years, 6 months ago

  By: ps_vbdev

• How to update on target table with source table

  Hello All, Please help on my below task. Source Table: +---------------+--------------+----------+-…

  tibco29

  4 replies

  10 years, 6 months ago

  By: tibco29

• query for datetime

  Hi, I need to set run time(dynamic) values for Startdate and Enddate in below query Enddate sho…

  charipg

  38 replies

  10 years, 6 months ago

  By: Sergiy

• BCP out to template excel

  Is there possibility that I can bcp out data to existing excel template?

  PJ_SQL

  1 replies

  10 years, 6 months ago

  By: Hugo Kornelis

• Nested Case statements Help

  I have a table of tests where I have data in the tabular format: English 8:30 9:00 9:30…

  amar_kaur16

  4 replies

  10 years, 6 months ago

  By: MMartin1

• Seperate Date and Week

  Hi all, I have hours in table like Mon-Sat 9- 5,Sun 10 - 6 I want the output as Mon Tue …

  demin99

  4 replies

  10 years, 6 months ago

  By: demin99

• Resource governor

  Hi, I am new to sql server and trying to use resource governor to limit maxdop for DBCC CHEKDB and …

  have2much

  5 replies

  10 years, 6 months ago

  By: Eirikur Eiriksson

• the use of CTEs

  All Id just like peoples views on the use of CTEs. I work contracts and move from job to job, 1 or …

  erics44

  161 replies

  10 years, 6 months ago

  By: Sergiy

• Dynamic SQL and Parameters

  I am trying to execute the following script but need to pass two parameters, I'm not sure how too, …

  decreale

  10 replies

  10 years, 6 months ago

  By: Luis Cazares