T-SQL

• Topics

  Started by

  Posts

  Last post

• Select top 1 with disctinct

  My table has Order, Release, Line and many other columns. I want to select just the top 1 line for …

  mpv-1060508

  2 replies

  14 years, 11 months ago

  By: Evil Kraig F

• Join select statement to a 'list of dates'

  I'm trying to join a 'list of dates' Select statement to a simple query in an attempt to find missi…

  Dom Horton

  5 replies

  14 years, 11 months ago

  By: Ken McKelvey

• Quality control on multiple rows condensed into a single row and written

  G'day all, I need a push in the right direction here - I've looked around other posts, but I have a…

  damienbr

  1 replies

  14 years, 11 months ago

  By: damienbr

• How do I update 1 table with summary values from another table?

  Hello everyone, I have 2 tables that I'm working with. table 1 = Staff (contains staff code, a…

  jeff.cilcus

  6 replies

  14 years, 12 months ago

  By: jeff.cilcus

• CONVERT DATATYPE

  How to convert Money data type to Decimal or Double . SQL 2005 Give me sample pls

  sampathsoft

  2 replies

  14 years, 12 months ago

  By: Koen Verbeeck

• SQL query not returning all results

  I have the following query: select name, employeenumber, summinutes, sum(summinutes/60) as hours fr…

  doug 40899

  7 replies

  14 years, 12 months ago

  By: doug 40899

• Logic loop to check variables

  I am trying to create a SQL query that will check if 3 variables ('ETO', 'Sick Leave', 'Vacation') …

  doug 40899

  5 replies

  14 years, 12 months ago

  By: GSquared

• MS Access Query Locking up MSSQL 2000 SP4

  Hi everyone, I've been 2 days straight cracking up my head trying to fix an issue, here it is, let …

  Luk - ARG

  1 replies

  15 years ago

  By: Luk - ARG

• SQL Server and Active Directory: Query group members

  Hello, I have an urgent task: Retrieve all group members from active directory using SQL Server 200…

  Dr.D

  1 replies

  15 years ago

  By: latheesh.jaya

• Need to Exclude One Of The Following

  Hi There, I have the following query - SELECT INV.Reference AS 'Invoice Reference' ,INV.Invo…

  TSQL Tryer

  7 replies

  15 years ago

  By: TSQL Tryer

• Using Sum and Cast Together

  I'm trying to sum a column as well as round a column up to the nearest minute. Here's 2 queries I'm…

  doug 40899

  7 replies

  15 years ago

  By: GSquared

• Where in @someString

  Hi Dudes, I have a problem and if any body know what to do, please help me. I have to write a store…

  ashkan sirous

  3 replies

  15 years ago

  By: Gail Shaw

• Copying and comparing data

  I have a query that I run daily against a database that is dumped to me nightly. I want to be able …

  doug 40899

  4 replies

  15 years ago

  By: LutzM

• arithmetic operations over strings

  I'm migrating data from values in string format, but I need pass it to the new platform in numeric …

  Earl Downs

  7 replies

  15 years ago

  By: Ken McKelvey

• Easy way to convert long "CASE" statement into a LOOKUP Table

  Hi guys, Can you help pls. I've just "inherited" a very very long CASE statement (over 1000 whens /…

  askquestions

  5 replies

  15 years ago

  By: askquestions