T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• ServerSizes

  I would like to find the difference  for any two past 30 days i.e if I select date1 as 5/24/20…

  mtz676

  1 replies

  9 years ago

  By: Joe Torre

• SQL QUERY Rows where TotalScore=@TotalScore in the range of value by using group by Date and Time

  Dear Expert,I am seeking your help .here is the scenario , please see the Figure -1 I have 3 parame…

  imneaz

  11 replies

  9 years ago

  By: drew.allen

• Build the calendar table for current year including weeknum divided to semester

  for the below query i need divide the semesters starting from 1 to 26 .. first semester as 1 to 26 …

  sunitha 20026

  1 replies

  9 years ago

  By: John Mitchell-245523

• Looking for best approach

  I have two tables. I am looking for an approach where 1)I need to display the data from Table1 if t…

  Anjan@Sql

  13 replies

  9 years ago

  By: Jeff Moden

• Slow query with multiple subs on the same table with counts

  I wrote a query that calculates, for each item on an invoice, how many other items are on the same …

  emenard 46273

  6 replies

  9 years ago

  By: Ed Wagner

• Calculating Hours worked in particular shift

  I am looking to calculate the Night_Start_Time,Night_Shift_End,Night_Shift_DurationWe have defined …

  SQL006

  5 replies

  9 years ago

  By: SQL006

• How to get row values as column values in a table

  Hi I am having table 'tblcalculate'  with field names 1)Hardness ---numeric, 2)tower ---int I …

  ramachandran narayanan

  2 replies

  9 years ago

  By: Joe Torre

• Check if Function EXISTS before adding

  I'm trying to write of script that checks if a certain Function exists, and if it does not, create …

  dan-572483

  13 replies

  9 years ago

  By: Gail Shaw

• ServerSizes

  My table data.date column values sample : 2017-05-16 03:14:59.647Server1    100…

  mtz676

  5 replies

  9 years ago

  By: Sue_H

• Get RowCount from all Tables in DB on RemoteServer

  Hi,from my current SQL-Instance, i want to get the RowCount from all User-Tables of a  DB on a…

  info 58414

  1 replies

  9 years, 1 months ago

  By: Kenny Jozi

• Dynamic variable error

  Not sure why is this working. Any help is appreciated. "Msg 241, Level 16, State 1, Line 8"Conversi…

  curious_sqldba

  2 replies

  9 years, 1 months ago

  By: Chris Harshman

• Insert data into a table without disabling the constraints (pk and fk)

  Hi I am working with a t-sql code in SQL Server 2008 and would like to know if it is possible to in…

  sergiobonfim

  9 replies

  9 years, 1 months ago

  By: jcelko212 32090

• looking for value in xml string

  I have a table defined as id intordertxt varchar(3000) in the table called INQ you will have v…

  tcronin 95651

  1 replies

  9 years, 1 months ago

  By: DesNorton

• Dynamic SQL - Run formula in field

  I have a field in my table that consists of formulas.....the formulas are tied to field name from a…

  rwr901012

  6 replies

  9 years, 1 months ago

  By: Sergiy

• Concurrency data access with UPDLOCK and READPAST

  Hello, I have the following code in a SP to deliver the next available lead for users. There a…

  NushAngel

  7 replies

  9 years, 1 months ago

  By: Ken McKelvey