T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Variables, Sargability, and Indexes

  I have an SSIS package that pulls data from a datamart table down to a Dev environment for our repo…

  Brandie Tarvin

  12 replies

  11 years, 2 months ago

  By: Brandie Tarvin

• [sys].[procedures]

  I am querying this table to drop the Stored procedures in the database upon upgrade. DECLARE …

  JKSQL

  5 replies

  11 years, 3 months ago

  By: ScottPletcher

• Arithmetic overflow error converting expression to data type int

  Help in my sql statement, I don't have any datatype as INT, when I run it, give me error as 'Arithm…

  davidl 27298

  4 replies

  11 years, 3 months ago

  By: davidl 27298

• Need help with an indexed view

  Hello Im using SQL Server 2008R2 + SP2 .... I have a view defined as : CREATE view vwIndexedView WI…

  Tim-257797

  2 replies

  11 years, 3 months ago

  By: ScottPletcher

• SQL Script help - Records that do not have a completed date

  I have one table called PatentMaster (1) which links to another table called PatentAction (2). I'm …

  stevemr68

  2 replies

  11 years, 3 months ago

  By: stevemr68

• Use stored procedure result to insert into table

  Silly question: my stored procedure returns one row. I need to insert the result to a table. Can I …

  valeryk2000

  4 replies

  11 years, 3 months ago

  By: valeryk2000

• Get data changes from history table

  Hi, how to get products on which SalesPerson changed. Here is table with data.

  only_you

  9 replies

  11 years, 3 months ago

  By: Sean Lange

• convert from access to sql server please help

  PLEASE HELP TO CONVERT SQL ACCESS TO SQL SERVER PLEASE I HAVE THIS IN ACCESS BELLOW I NEED TO CONVE…

  draganl2000

  10 replies

  11 years, 3 months ago

  By: pietlinden

• Help with query

  Hi, I’ve got a query I’m working on and need some help. Below is the query and what it does is assi…

  krypto69

  4 replies

  11 years, 3 months ago

  By: krypto69

• Replace string after a specific index

  I have data like below Potter, James J Williams, Ted R Allen, Gary G I want to remove Middle Nam…

  sarath.tata

  3 replies

  11 years, 3 months ago

  By: ChrisM@Work

• TSQL Help

  I have a table with the structure below. I'm looking to get all records where the SAME record in eX…

  sc22

  1 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson

• New query option is not visible in SQL Server 2000

  I just inherited a few Servers that have SQL Server 2000. I cant find the new query Icon? Edit: typ…

  Welsh Corgi

  2 replies

  11 years, 3 months ago

  By: Welsh Corgi

• Cross Apply error

  Hi all, i hope some one can help me, i have this query but give me the error " Incorrect syntax nea…

  renato.mgomes

  7 replies

  11 years, 3 months ago

  By: ScottPletcher

• <> and = in where clause

  i am just double checking to make sure this has to be two stored procedures. I can't make this int…

  JKSQL

  3 replies

  11 years, 3 months ago

  By: ScottPletcher

• Insert subset of self-referencing table into that table

  IF OBJECT_ID('tTable') IS NOT NULL DROP TABLE tTable GO CREATE TABLE tTable (nRow_IdINTEGER IDENT…

  schleep

  5 replies

  11 years, 3 months ago

  By: schleep