T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Transaction Isolation Level

  Hello Everyone I have a medium sized SSIS Package, with multiple steps, that call a single sproc ea…

  AndrewSQLDBA

  1 replies

  13 years ago

  By: j.miner

• TRIGGERS...

  Hey guys, Our team ran into a problem over the weekend and Im confused over it... We are in the pr…

  asm1212

  9 replies

  13 years ago

  By: Jason Wolfkill

• Need to unpivot a table

  Hello, I have a table like this CREATE TABLE [temp]( [Country] [varchar](200) NULL, [Country_Grou…

  arvindharitus

  5 replies

  13 years ago

  By: Sean Lange

• 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 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 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 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 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 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 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 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 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 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 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 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 ago

  By: Lowell