T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Read .Doc or excel files direct from SQL Server 2005 database

  Read .Doc or excel files direct from SQL Server 2005 database .Doc file already stored into databas…

  kanhaiyapankaj

  2 replies

  15 years, 4 months ago

  By: kanhaiyapankaj

• combine two columns into a single column

  select month_value, year_value, answer from transaction the output is like as ---------------------…

  ramya.praba

  3 replies

  15 years, 4 months ago

  By: ramya.praba

• Read Error Log

  Hi all, As I am aware that we can read errorlog through sp_readerrlog and xp_readerrorlog and both …

  RaviShankar1234

  2 replies

  15 years, 4 months ago

  By: TakeITeasy

• Pivoting Multiple Columns

  I need to pivot multiple columns. I am better off doing 2 different Pivots and joining them, or usi…

  Khades

  8 replies

  15 years, 4 months ago

  By: Jeff Moden

• export to excel file

  hi all. i have table that store excel files to varbinary column,now i want export this data from ta…

  elham_azizi_62

  1 replies

  15 years, 4 months ago

  By: danschl

• How to group by where we have char data type

  Hi All, I have five distinct rows in table, something like id col 100 A 100 B 100 C 100 D…

  srikantzs

  1 replies

  15 years, 4 months ago

  By: LutzM

• BCPing out a Table without xp_cmdshell

  declare @cmdstr1 varchar(500) select @cmdstr1='BCP "select * from AdventureWorks.dbo.Employee" quer…

  prasadau2006

  7 replies

  15 years, 4 months ago

  By: Jeff Moden

• Filter a table to get unique rows in a certain logic

  Hi, I'm trying to select specific rows from this table: CREATE TABLE MVTS (idMvt1 int, idMvt2…

  moadh.bs

  75 replies

  15 years, 4 months ago

  By: SwePeso

• Adding a Table - Merge Replication

  I've managed to use sp_repladdcolumn to add columns to replicated tables. By golly, the new table a…

  Half Bubble

  2 replies

  15 years, 4 months ago

  By: Half Bubble

• select max len pattern that matches with column

  Hi, Please help me on the following, create table address(postcode nvarchar(100),Country nvarchar(1…

  Deepthy

  6 replies

  15 years, 4 months ago

  By: Deepthy

• loop in function

  Is it possible to write a loop in a function? I'm getting the following error: "Cannot access tempo…

  L09041975

  3 replies

  15 years, 4 months ago

  By: Jeff Moden

• Very Complicate Query....

  Hi, this is my table with records CREATE TABLE [dbo].[Person]( [RtnSetId] [int] NOT NULL, [FirstN…

  rajesh-303966

  10 replies

  15 years, 4 months ago

  By: WayneS

• delete help using output.deleted option

  I AM TRYING TO DELETE CONTACT ID FROM CONTACT AND SALESHEADER TABLES USING OUTPUT.DELETED OPTION( C…

  Smash125

  2 replies

  15 years, 4 months ago

  By: Smash125

• Where is place to store description of Columns?

  I was created a table with some columns inside it. For example, I have a table with name "TableX". …

  eko indriyawan

  3 replies

  15 years, 4 months ago

  By: Vedran Kesegic

• Just closed the wrong page!

  I just closed without saving the wrong page (I was doing a comparison) Is there a place to go to re…

  shannonjk

  5 replies

  15 years, 4 months ago

  By: mister.magoo