T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Open Query to Oracle

  Hi, I have used select,insert and delete in open query(from mssql to oracle) , but I don't how can …

  thbaig

  6 replies

  11 years, 4 months ago

  By: thbaig

• System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'INFORMATION_SCHEMA.Columns

  Hi, Below is the Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'I…

  suresh0534

  7 replies

  11 years, 4 months ago

  By: Koen Verbeeck

• How to find who installed the sql server?

  Can some one please provide me the script to find who installed the sql server and if it is a group…

  hydbadrose

  7 replies

  11 years, 4 months ago

  By: webrunner

• T-SQL Counting: difference of two methods?

  Got this sample which works: SELECT TOP (5) ROW_NUMBER() OVER(ORDER BY somefield DESC) FROM somet…

  rodeliorodriguez 26453

  8 replies

  11 years, 4 months ago

  By: Luis Cazares

• Begin End Block inserting too many records

  I have a temporary table that can have anywhere from one to maybe 15 records each day. I am trying…

  dorisdelaney

  6 replies

  11 years, 4 months ago

  By: dorisdelaney

• Setting a column to the same value for each associated group of rows in a table

  Hi, I need help with the sql to update column values in a table. I have a table of imported data f…

  contact 8308

  2 replies

  11 years, 4 months ago

  By: contact 8308

• T-SQL to add 7 days to ship date

  Hello All, A quick question to all regarding my query. Below statement adds 7 days to the shipment …

  SSRS Newbie

  1 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• Primary key violation error when I'm not violating the primary key

  I need to insert some rows from a temporary table into a persistent table. The persistent table ha…

  chris.mckeever

  2 replies

  11 years, 4 months ago

  By: Gail Shaw

• User View

  I have 2 tables - a user table (TB_USERS) and a user customer table (TB_USER_CUST). I want to selec…

  Rog Saber

  2 replies

  11 years, 4 months ago

  By: MMartin1

• Date range selection error for a table view

  Hi, I have created a view using the query below which is based on dates within my RMMarketingPrice …

  DerbyNeal

  6 replies

  11 years, 4 months ago

  By: DerbyNeal

• Need help converting Dynamic Pivot output to XML / HTML

  G'day. I need some help converting the output from a pivot statement to HTML. I can't seem to get m…

  Cees Cappelle-442904

  1 replies

  11 years, 4 months ago

  By: Cees Cappelle-442904

• Concatenating fields into one

  Hi all I'm running SQL 2005 with SSMS 2012. I've got a table with the following fields: Visit ID Ab…

  richardmgreen1

  6 replies

  11 years, 4 months ago

  By: richardmgreen1

• finding gaps between termination date and next enrollment date and filter by gap >= 45 days for year 2013

  Hello experts! I need your help. I would like to calculate the date gap between the first terminati…

  Tammy-274861

  47 replies

  11 years, 5 months ago

  By: Tammy-274861

• Transpose cloumns into rows and rows into columns

  my result set is like this.But i want to pivot the result. I used both the cobination of pivot and …

  malleswarareddy_m

  7 replies

  11 years, 5 months ago

  By: Stun-Dexim

• Concatinate the String with in single row

  HI all I have a master table with item_no as one of column Ex: table name:Table1 ITem_no 1 2 3 Tabl…

  Saravanan_tvr

  6 replies

  11 years, 5 months ago

  By: Ed Pollack