T-SQL

• Topics

  Started by

  Posts

  Last post

• How to juxtapose ( pivot horizontally ) Author names, and group by Book title

  I have 3 tables - Book, Author, BookAuthorReference A book can have multiple authors, and when I do…

  BikeDude

  1 replies

  10 years, 11 months ago

  By: Jeff Moden

• Could not complete cursor operation 16958

  Has anybody seen the following error message: "Could not complete cursor operation because the set …

  Michael A. Martin

  17 replies

  10 years, 11 months ago

  By: TCCaines

• start time of a job while it is running

    I posted this on the admin forum yesterday and did not get much response, I know I am cross …

  andrewkane17

  5 replies

  10 years, 11 months ago

  By: John Mitchell-245523

• calling application initiating background process

  let me try to explain........... there is an application that calls a procedure say sp_BatchOrSingl…

  daniarchitect

  4 replies

  10 years, 11 months ago

  By: daniarchitect

• Split the data without loop

  Hello Team, In the old design, i have the data in a table like below: ID value 1 …

  NewBeeSQL

  14 replies

  10 years, 11 months ago

  By: pietlinden

• Concate all rows into single one row

  Using SQL Server 2000 EE On Winodws Server 2000 create table abcx ( deptname varchar(10), doctorid …

  gksharmaajmer

  3 replies

  10 years, 11 months ago

  By: Jeff Moden

• Data Conversion Error

  Good Morning Guys, I Would Like to ask. when I run this particular Select Statement inside a stored…

  Stylez

  1 replies

  10 years, 11 months ago

  By: daniarchitect

• Multiple Conditions on a Case Statement

  Good Evening Guys, I would like to ask if is it possible or is my syntax correct for the Select Cas…

  Stylez

  4 replies

  11 years ago

  By: Stylez

• SUM() using ROW_NUMBER() without resorting to multiple CTEs

  I have a table (named Data) with the following structure: Server, Database, File, Type, Size, Modif…

  Pete Bishop

  1 replies

  11 years ago

  By: ChrisM@Work

• Select rows with AFTER INSERT trigger?

  Hi experts, Is it possible to do a SELECT in a trigger? I have the following: [dbo].[TR_Insert] ON…

  simflex-897410

  7 replies

  11 years ago

  By: g.britton

• variable char

  Hello, I want to filter data by group but it doesnt work... I can not find a mistake...could you pl…

  peter478

  19 replies

  11 years, 1 months ago

  By: peter478

• Creating file with the help of BCP and xp_cmdshell. But blank file.

  Hi guys, I am trying to execute the following script to get the object script in a file. SELECT @…

  C.K.Shaiju

  2 replies

  11 years, 1 months ago

  By: C.K.Shaiju

• TSQL Statement Help Please

  Hi I have an update statement which performs UPDATES to column when the WHERE condone = 'Yes' .. U…

  AarionSSQL

  1 replies

  11 years, 1 months ago

  By: Gail Shaw

• Create a View with OPTION (FORCE ORDER)

  Query works fine, but when I make the query a view, I get Server: Msg 156, Level 15, State 1, Proc…

  John F

  10 replies

  11 years, 1 months ago

  By: balbidon

• Select multiple rows for column into single row, w/hard return

  Context: > SQL Amateur > SQL Server is 2012 > I am selecting data per Order# from an Order…

  mahler9

  10 replies

  11 years, 1 months ago

  By: mahler9