T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to report on historical movements within a changing hierarchy

  I'm in an IT environment where we're wanting to: 1. run queries which will show rates of consumptio…

  polkadot

  12 replies

  13 years, 1 months ago

  By: polkadot

• Simple update to opposite

  Hi I am struggling to find out how can I do the following in my SP. UPDATE EmployeeData SET selec…

  meelan

  1 replies

  13 years, 1 months ago

  By: meelan

• Custom sp_who

  Hello All, Couldn't find anything that addresses this specifically, so here goes. I have a group th…

  datwungai

  17 replies

  13 years, 1 months ago

  By: Vedran Kesegic

• Add variable number of rows into a table based on the values in another table (without cursors/while loops)

  Below is a simplified version of my tables: set nocount on drop table #x create table #x (docid int…

  charles99

  16 replies

  13 years, 1 months ago

  By: Jeff Moden

• Debugging stacked CTEs efficently

  I'm curious if anyone else has figured out a good system for performing analysis on a query that ma…

  Banana-823045

  2 replies

  13 years, 1 months ago

  By: Orlando Colamatteo

• Running Query on Multiple Database/Servers

  Hi I have a database table that contains all the server details. I have a query and wanted to run …

  ShuaibV

  2 replies

  13 years, 1 months ago

  By: Orlando Colamatteo

• Optimization of dynamic SQL

  Hi All, I have a stored procedure with many optional parameters. Following is one of the code block…

  rajawat.niranjan

  1 replies

  13 years, 1 months ago

  By: Orlando Colamatteo

• Calculate percentage

  Hi, I need to make a report from a table contains following data (I made a simple structure as the…

  RZ52

  3 replies

  13 years, 1 months ago

  By: SwePeso

• i want update the 2nd column based on first column:

  hear i have id column based on that getting one more column as mid and data as belo: id 100 200 300…

  DBA.k

  13 replies

  13 years, 1 months ago

  By: carlosaamaral

• index re-build on trucated table

  hi, i've seen a couple of cases where huge staging tables containing c/nc indexes are truncated and…

  _rohit_

  2 replies

  13 years, 1 months ago

  By: Orlando Colamatteo

• Need help with recursive query

  Hello, Here is my scenario. Let's say I have two tables "Car" and "CarPart". The car consist of m…

  Misha_SQL

  9 replies

  13 years, 1 months ago

  By: Misha_SQL

• how create sql str with special condition

  create sql str with special condition hellow I have 2 table Table a(code, price, check) Table b(…

  armm1388

  1 replies

  13 years, 1 months ago

  By: Lynn Pettis

• Execution Plan with Sort

  I am playing around with and continuing to learn SQL. I am using the AdventureWorks2012 database wi…

  ken_cox

  3 replies

  13 years, 1 months ago

  By: ken_cox

• Store Procedure Help

  Hi Guys, I need big favor. I create new table Table_Track (ID, StoreProcedureName, CreatedDate, C…

  rocky_498

  4 replies

  13 years, 1 months ago

  By: Sean Lange

• BCP Error : Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.EXTGEN_InitSessionContextSp'.

  DECLARE @Cmd VarChar(4000) DECLARE @SProcName VarChar(40) DECLARE @SP_Parm1Value VarChar(4…

  skb 44459

  19 replies

  13 years, 1 months ago

  By: Orlando Colamatteo