T-SQL

• Topics

  Started by

  Posts

  Last post

• Old brain, new question

  Rather than posting all of my failed queries, I'll just show what I'm trying to do. auctions fields…

  vance.king

  2 replies

  9 years, 5 months ago

  By: Jeff Moden

• Dynamic SQL, functions, stored procs - What are best practices?

  Hello, While I would describe myself as "relatively competent" in TSQL to the casual observer, my s…

  EnigmaticSoul

  1 replies

  9 years, 5 months ago

  By: EnigmaticSoul

• sqlcmd interactive mode

  I like sqlcmd. The postgresql command line sql utilities allow users to execute an sql statement on…

  ioioioioioioioio

  1 replies

  9 years, 5 months ago

  By: ioioioioioioioio

• Find Closest Match Data

  Hi, I have a problem to find closest match data inputted with the one in Table. eg. In my Table, i …

  jsnv

  11 replies

  9 years, 6 months ago

  By: PappyBlueRibs99

• How to use a year and month fields to get a range of records

  Hello Everyone, I have a table that contain (besides other columns) 2 fields Year (2014, 2015, etc.…

  san1901

  13 replies

  9 years, 7 months ago

  By: Wayne Sheldon

• Combining Temp Table Results

  Hello, I have multiple temp tables that return one row of results each. What would be the best wa…

  giszzmo

  6 replies

  9 years, 7 months ago

  By: giszzmo

• DBO is Ambiguous

  Hello everyone. I am new to T-SQL but I have been working on a project. I am attempting to use a mi…

  Scubba-Steve

  15 replies

  9 years, 7 months ago

  By: TomThomson

• call DB2 procedure from SQL server

  Hello, i would lite to transfer data from DB2 stored procedure to SQL server 2005 new table. I cre…

  milospod

  1 replies

  9 years, 7 months ago

  By: Newbie2LinkedServer

• Count and Reset Row Numbers per Group

  I have a report where I need to get a random set <= 35 per group. I work in Sybase Rapid SQL so…

  gvschmidt320

  1 replies

  9 years, 7 months ago

  By: gvschmidt320

• Err: 'Val' is not a recognize function name.

  hi fellow DBA's...just need your little help....this is my query in SQL Server 2000. "SELECT tblSch…

  mhack122

  1 replies

  9 years, 8 months ago

  By: Gail Shaw

• Convert smalldatetime to int

  How can I go about converting smalldatetime into int(4)?

  JeremyE

  10 replies

  9 years, 8 months ago

  By: Sergiy

• Best approach as per industry standards for data cleansing

  Hi Experts, I have a database with more than 600+ tables. Some of the table are very big ranging fr…

  Naveen J V

  1 replies

  9 years, 9 months ago

  By: free_mascot

• Incorrect syntax near 'Index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required.

  I have written following query in which I have not written Index anywhere... declare @strColumns va…

  nishant.sagar

  3 replies

  9 years, 9 months ago

  By: v.pandoss

• Get file size

  Hi,             I need to get the file size in by…

  Rajesh-388763

  26 replies

  9 years, 9 months ago

  By: Anonymous

• How to remove Carriage Return from string?

  How can I remove Carriage Return -> char(13) from a normal string in tsql because I don't succe…

  neilswart

  3 replies

  9 years, 9 months ago

  By: mark.rote