T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Subquery returned more than 1 value. This is not permitted when the subquery follows

  I cant run the query because of subquery returned more than 1 value due to coalesce. But, we need c…

  EasyBoy

  2 replies

  8 years ago

  By: EasyBoy

• Count from joins

  Hi,Is there a better way of doing this? I'm joining back to the same table 4 times and counting fro…

  lanky_doodle

  5 replies

  8 years ago

  By: lanky_doodle

• How to duplicate a record

  Hey, If I have a set of records, keep it simple with ID, User and Department: ID---------User-…

  lanky_doodle

  1 replies

  8 years ago

  By: lanky_doodle

• How do I avoid multiplied results when adding a subquery?

  I've created a query that includes a subquery.  When I run the subquery alone, it gives me the…

  sqlnoob2015

  1 replies

  8 years ago

  By: sqlnoob2015

• Use a case statement within a function parameter.

  Hi, I have a problem which is as follows: I have a function that calculates working days betwe…

  paul.stevens 24552

  1 replies

  8 years ago

  By: ScottPletcher

• Show data based on MAX Action date - end of the month

  Hi, I have the below query and like to show only the values highlighted in yellow in 2018-01-31. Th…

  jaggy99

  5 replies

  8 years ago

  By: jaggy99

• error:- Unhandled Exception: System.Data.SqlClient.SqlException: Incorrect syntax near t he keyword 'as'.‌

  HI All,I'm trying to use this sql query in my asp.net application but i keep getting error:- Unhand…

  Patrick.I

  4 replies

  8 years ago

  By: Sean Pearce

• Send HTML Mail Using T-SQL

  Hello,I'm trying to create a SP that will take a Temp Table and will send it as an HTML mail.The fo…

  dudik

  1 replies

  8 years ago

  By: Jeff Moden

• Data roll up

  Hi all,I have one table which contains data like this:Col1,Col2,Col3A,before,100A,after,10A,after,8…

  sqlenthu 89358

  4 replies

  8 years ago

  By: drew.allen

• Maximum Date with Status

  I have table where i have Status (Delete and RQT) with Entry_Date (DateTime) and Vin number. 3KPA35…

  syed_3177

  1 replies

  8 years ago

  By: Sean Pearce

• Question Regarding Date logic

  Hi, I need to get Year, monthname in three letters, startdate and enddate  of the month for l…

  KGJ-Dev

  104 replies

  8 years ago

  By: Sergiy

• what's the best way to get rows to columns for this?

  create table temptest (lid varchar(10), dat varchar(20)) insert into temptest (lid,dat) values ('11…

  foxr4

  3 replies

  8 years ago

  By: Sergiy

• Strip SAON from the beginning of an address

  For those who don't know, a PAON is the part of an address that identifies a building.  A SOAN…

  FunkyDexter

  11 replies

  8 years ago

  By: FunkyDexter

• Top 1 record order by column and random

  Hi,Please find the below sample records to play with. basically i am looking to get top 1  ram…

  KGJ-Dev

  2 replies

  8 years ago

  By: KGJ-Dev

• Get the most recent active value

  HI, I’m trying to get the last active data and insert that in the current row of the table. Create …

  sindhupavani123

  1 replies

  8 years ago

  By: Gail Shaw