T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Pivoting based on bit column

  I have three column Questionid int type varchar checked bit data is getting stored in format like: …

  gaurav-404321

  8 replies

  15 years, 5 months ago

  By: Paul White

• Get top 5 highest value columns using tsql

  Table score_id, usernm, points 1 ABC 5 1 BBC game 1 who are the top 5 pp…

  Sql Student-446896

  4 replies

  15 years, 5 months ago

  By: Jeff Moden

• How to order by

  Hi i have situation where i need to order by not by desc or asc but according to given report Ex if…

  dheer

  6 replies

  15 years, 5 months ago

  By: Paul White

• patindex - search for either value

  I am looking for a pattern that will help me do the following... I have a table with a column i wan…

  Mr Guy-323725

  9 replies

  15 years, 5 months ago

  By: Mr Guy-323725

• EXECUTE AS inside a SP that has also SET IDENTITY_INSERT tablename ON

  Hi guys, I have this looong SP that I need to run with elevated privileges but not from the context…

  JJ Duru

  4 replies

  15 years, 5 months ago

  By: Paul White

• Stopping Duplicates with INSTEAD OF INSERT Problem

  We have a table which gets thousands of new records per hour from a web app. This app needs to gen…

  Eric Zierdt

  37 replies

  15 years, 5 months ago

  By: Paul White

• Removing Null and keep them blank

  Hi, I am working on a big table with around 600 columns and 33000 rows.... now for each column the…

  hemalchalishazar

  6 replies

  15 years, 5 months ago

  By: Paul White

• UPDATE to new column creates 'Invalid column name' error

  I have a script to insert a new NOT NULL column into a table and give it a default value. Within t…

  JustANumber

  9 replies

  15 years, 5 months ago

  By: JustANumber

• XML Paramter VS Table Valued Parameters

  Hi I have a small question regarding the parameters in a Stored Procedure. Is there any considerabl…

  Azzu

  1 replies

  15 years, 5 months ago

  By: Paul White

• Bulk insert issue

  How to use bulk insert to impot the data . Sample data is below 1"11321993-00""SO"4"0410""SP…

  srikant maurya

  1 replies

  15 years, 5 months ago

  By: Lowell

• Split column values into multiple rows using sql

  NA

  sqluserr

  7 replies

  15 years, 5 months ago

  By: nguyennd

• What the problem with substring

  I have a SQL code select SUBSTRING('市市市市市市市市市市',40,1) select SUBSTRING('市市市市市市市市市市',20,1) Why resul…

  nguyennd

  17 replies

  15 years, 5 months ago

  By: Paul White

• Load txt to datbase repeatedly

  Hi, I want to ask you, if is it possible to load data from txt to database always when new txt is c…

  1manik

  3 replies

  15 years, 5 months ago

  By: Ben Teraberry

• any tips on anonymising data

  Hi guys, I am being asked to restore a live database to a training environment. The database conta…

  aaron.reese

  2 replies

  15 years, 5 months ago

  By: Paul White

• Problems with 'ROUND'

  Hello, I have some strange messages. After SELECT ROUND(.7545, 0) I received: An error occurred whi…

  jassr

  4 replies

  15 years, 5 months ago

  By: jassr