General

• Topics

  Started by

  Posts

  Last post

• Multiply Select Rows in one query

  Hello, I'm new here. I do have one question in regards of forming up a select query. Imagine I have…

  Kristian123

  1 replies

  8 years, 1 month ago

  By: pietlinden

• Stored Procedure Help Required: Updating A Users Balance For Every Bet Won

  Hi, I'm just learning Microsoft SQL so please can anyone help me write the following..I am developi…

  marky.davies

  2 replies

  8 years, 1 month ago

  By: Lowell

• Is there a better way to do this sort of Case with counts, trying to re-organize to run faster

  SELECT  count(*),   (CASE       WHEN  wfstate =0 …

  gfry

  2 replies

  8 years, 1 month ago

  By: Luis Cazares

• Using a parameter in a procedure for sp_send_dbmail, the mail never gets received

  I have a peculiar problem here. I have a procedure that needs to be called at the end of each packa…

  a deslandes

  7 replies

  8 years, 2 months ago

  By: cbrammer1219

• Which actions cause tables to be recreated?

  Is there a concise reference that lists the data modifications which would cause SQL server to recr…

  nickm_GR

  2 replies

  8 years, 2 months ago

  By: Gail Shaw

• Speeding up this function??

  This function gets related streetname(s) and housenumber(s) and returns this as a string. I'm wonde…

  f.keler 18216

  9 replies

  8 years, 2 months ago

  By: John Mitchell-245523

• Stored Procedure help

  Ok, I'm trying to create a stored procedure that will count the certain conditions and display thos…

  actinicblue

  4 replies

  8 years, 2 months ago

  By: Sean Lange

• SELECT output formation

  Hi I'm very very noob at SQL so please forgive me if I'm missing something really obvious or seem l…

  kevv

  10 replies

  8 years, 2 months ago

  By: kevv

• T-SQL Code Analysis Tools

  I am researching T-SQL Code Analysis tools, like the equivalent of an FxCop for T-SQL that will sca…

  notarian@gmail.com

  13 replies

  8 years, 2 months ago

  By: Steve Jones - SSC Editor

• displaying 2 values when field same

  I have a field, stop.city_name, and it can be 2 different locations based on a stop.stop_type...so …

  rmcguire 28206

  32 replies

  8 years, 3 months ago

  By: drew.allen

• Using a value retrieved from a SELECT Statement

  Using MS SQL (vers 2008R2, 2012, 2014) Lately I have been getting my "feet wet" delving deeper and …

  mcooper 15906

  7 replies

  8 years, 3 months ago

  By: BrainDonor

• Hierarchy without cursor/loop

  Hi Experts I have a situation in which I want to avoid cursors/loops .Suppose I have a table in &nb…

  ansaryarshad

  11 replies

  8 years, 3 months ago

  By: Jeff Moden

• BCP OUT using Error file makes sense?

  Hi all, I use BCP very often, normally with the -e err_file option.When specified, t…

  Hans van Dam

  4 replies

  8 years, 3 months ago

  By: Hans van Dam

• SQL to display hourly count including zero

  I have been struggling with this for 2 days now and need some help I am trying to display hourly …

  mikek 50666

  3 replies

  8 years, 3 months ago

  By: DesNorton

• Dynamic Aggregate functions in SELECT

  Hi Experts I have a query regarding how to efficiently  do a SELECTI have data in the below fo…

  ansaryarshad

  4 replies

  8 years, 3 months ago

  By: Luis Cazares