T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• openquery worked in SQL 2005 but not in 2008

  I have a querythat works in SQL Server 2005, but has an error using it in SQL Server 2008. select …

  Denise McMillan

  11 replies

  10 years ago

  By: shrirohit

• Combine two working queries to get this month and last years this month numbers shipped

  I need to combine these two to get the results as smlPartID, TMT, LMT select sl1.smlPartID, sum(…

  kat35601

  2 replies

  10 years ago

  By: ScottPletcher

• Help creating a SP

  Hi All, I work for a community center and we offer many classes/programs to community. I need to be…

  SQLisAwe5oMe

  43 replies

  10 years ago

  By: Sean Lange

• Linked server error Msg 7202

  Hi.. Requirement: I want SQL server database backup status in single reports from all remote DB ser…

  SQL Galaxy

  2 replies

  10 years ago

  By: spaghettidba

• Please help to extract xml.

  Hi, I have a following xml. '<Item> <Item customerid="101" customername="Ram" gender="Male…

  panneermca35

  1 replies

  10 years ago

  By: drew.allen

• Help with SUBSTRING and CHARINDEX

  I have the following in a column by the name of Text in a table: Login failed for user 'User1'. Rea…

  GBeezy

  3 replies

  10 years ago

  By: GBeezy

• Only one expression can be specified in the select list when the subquery is not introduced...

  Hello, I want to combine the result sets from two multiple query using union all operator and send …

  kiran 4243

  6 replies

  10 years ago

  By: kiran 4243

• Does it possible to bind different table column data in original table column in computed column specification properties?

  Hello, I want to add different table column in original table's computed column .In Biograph_Maste…

  Virtual Reality

  4 replies

  10 years ago

  By: Sergiy

• Populating table of shifts

  I need help writing a script to populate a table with shift times (start date and time and end date…

  stacey doran

  1 replies

  10 years ago

  By: Luis Cazares

• SQL Pivot help

  How would I pivot this query I need uompschedulenumber to be the ROW, QTY to be the summary data an…

  kat35601

  3 replies

  10 years ago

  By: kat35601

• Adding quotes to dynamic SQL

  This is driving me nuts. I know I'm missing something really simple, but I can't figure out what it…

  Brandie Tarvin

  15 replies

  10 years ago

  By: Brandie Tarvin

• sql substring help

  Hi, sample data: declare @Test table(Code varchar(18)) insert into @Test select aa.code from ( sele…

  KGJ-Dev

  4 replies

  10 years ago

  By: KGJ-Dev

• Query Help

  My requirement is list of Students registered to both music(TSM) and dance(PADA) school along with…

  SQLisAwe5oMe

  10 replies

  10 years ago

  By: ScottPletcher

• Character string conversion to date type. char(8) to Date ( from char(8) (23022016) to date(dd/mm/yyyy) (23/02/2016)

  Hello i have problem with conversion from string to date type: In one column i have Date data like …

  GKR 52789

  6 replies

  10 years ago

  By: ChrisM@Work

• Count of Records in a Table by Military Time.

  I wrote the query below to get the number of episodes of restraint each hour. I wanted the hour to…

  thomaswellington

  8 replies

  10 years ago

  By: thomaswellington