T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Help with Query

  Hi I have a query which returns the following Key segment Value A001 001 3 A001 002 4 …

  Johnny H

  4 replies

  13 years, 1 months ago

  By: Johnny H

• Get summary of column values from a result set

  good morning everyone, I have a procedure taking some input parameters that are used for a select s…

  WolfgangE

  3 replies

  13 years, 1 months ago

  By: Mark Cowne

• Stored Procedure using huge IO?

  Hi, one of the SQL SP written like this as below. it is getting blocking every time due to waiting …

  SQL Galaxy

  3 replies

  13 years, 1 months ago

  By: Gail Shaw

• How do i line up the weeks in T-SQL ?

  How do i line up the weeks ('Weeks-2013' and 'Weeks-2012') in T-SQL ? Below is sample data to test …

  kevin_nikolai

  7 replies

  13 years, 1 months ago

  By: vinu512

• Creating code objects within a single script

  I need to deliver a large number of code objects (views and functions, not stored procedures) to ou…

  jhager

  8 replies

  13 years, 1 months ago

  By: jhager

• Looking for a query to return rows in tableA that are inclusive of ID in tableB

  I am looking for a query to get all records from tableA that exists in tableb inclusive. tableB con…

  Todd Bernstein-449184

  3 replies

  13 years, 1 months ago

  By: Sean Lange

• Return 1 record with data from multiple tables

  All, I have data in numerous tables. The first 2 tables are simple: tblProducts ----------------- …

  Mark Eckeard

  13 replies

  13 years, 1 months ago

  By: vinu512

• SELECT FROM Multiple tables with names in a table

  I am trying to do a query that I am not sure can be written without using a cursor and building dyn…

  SQLKicksButt

  11 replies

  13 years, 1 months ago

  By: SQLKicksButt

• Update Help..

  Hi Guys, Need favor. Here is the e.g. I am using TABLEA.ID (as an e.g) in my SP.I am not sure how …

  rocky_498

  4 replies

  13 years, 1 months ago

  By: umarrizwan

• Get sum of averages - a challenge

  I have a need for a query that groups data, returns averages for the groups, but also sums those av…

  Ken Davis

  11 replies

  13 years, 1 months ago

  By: Sean Lange

• harnessing sp_msforeachdb to return one result set

  I found a nifty but unsupported stored procedure that loops through all databases on your server an…

  KoldCoffee

  2 replies

  13 years, 1 months ago

  By: KoldCoffee

• Alter Column with Identity

  Hi All, The following one is the Table definition. After inserting some rows ...i want to add ident…

  Pulivarthi Sasidhar

  7 replies

  13 years, 1 months ago

  By: Lowell

• Reorder a custom order column

  Hi, Been stuck on this for a little while and hoping that someone can help me figure out my logic p…

  matak

  12 replies

  13 years, 1 months ago

  By: matak

• How to show Carriage Return Char(13) in XML as real CR instead of tag.

  Hi, I'm using a neat query to concatenate strings. It is using XML to do. I had 200.000 rows to be …

  Harry Drenth

  9 replies

  13 years, 1 months ago

  By: Lynn Pettis

• Combine multiple combinations to one

  Hi, The following test condition : IF object_id('tempdb..#testEnvironment') IS NOT NULL BEGIN DRO…

  RZ52

  2 replies

  13 years, 1 months ago

  By: RZ52