T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Percentage Calculation with two decimal digit rounded off

  Hi, I am using the following query to find the top 10 transaction and percentage of transaction w…

  Soundari

  6 replies

  5 years, 11 months ago

  By: Jonathan AC Roberts

• Comma seperated Join vs INNER JOIN

  Hi guys, I read once that the inner join was better. This morning I tried to prove it and came very…

  Ryan Naude

  5 replies

  5 years, 12 months ago

  By: jeffstubing

• Date Format (mm/dd/yyyy hh:mm), no seconds or milliseconds

  Does anyone know syntax to use to format a date field with as follows (02/09/2009 14:34)? Any help …

  jpalmer-755805

  17 replies

  6 years, 1 month ago

  By: Jason A. Long

• sp_send_mail question

  I am trying to convert all our main application to use sp_send_db_mail; here is my question though;…

  washawgolla

  1 replies

  6 years, 2 months ago

  By: RBarryYoung

• Performance issue with tally solution

  Hello everybody! I have a performance issue with a set based solution. Please could you advice me w…

  Florian Reischl

  522 replies

  6 years, 2 months ago

  By: Paul White

• Remove DATE ONLY from datetime column

  Hello, I need to remove DATE from a date time column in SQL 2005? All I keep finding on Google is h…

  DaveDB

  22 replies

  6 years, 5 months ago

  By: Jeff Moden

• Automatically inserting foreign keys

  Hi, i have to build a database for my university coursework, i have 5 tables and 1 of them has 2 fo…

  mattysut57

  2 replies

  6 years, 5 months ago

  By: drew.allen

• Set a Variable Inside a Case Statement

  I need to set a variable inside a Case that is inside a Select. I am using this is for counting pu…

  Jason Leadbetter

  5 replies

  6 years, 5 months ago

  By: Jeff Moden

• SELECT TOP 1 on Primary Key?

  I have a table (let's call it TableA) with a primary key defined (let's say the column is called Co…

  lisalee

  31 replies

  6 years, 7 months ago

  By: Lynn Pettis

• WinHttp.WinHttpRequest

  Hello, I have a stored proc that calls a web service via WinHttp.WinHttpRequest.5.1. For years, I …

  DB Dude

  1 replies

  6 years, 8 months ago

  By: francesco.mantovani

• Identify node and tag in XML data using T-sql

  Hi, I have XML data store in Sql table. XML structure will not be static.i want write the T-sql Cod…

  unnati.patel513

  6 replies

  6 years, 9 months ago

  By: subrat.shasank

• Alias in a CASE Statement

  Hello Everyone Where does the Alias reside when using a CASE Statement? I have tried a couple place…

  AndrewSQLDBA

  3 replies

  6 years, 10 months ago

  By: Greesh

• How to convert INTEGER to TIME

  Hello, I have a column which is integer data type and it represents number of seconds. I need to co…

  pshvets

  19 replies

  6 years, 11 months ago

  By: Jeff Moden

• Create Mailing List from Query Results

  I have a query below which gets data for a mailing list to be generated.  What I need to know …

  lmarkum

  1 replies

  6 years, 11 months ago

  By: Sue_H

• Each GROUP BY expression must contain at least one column that is not an outer reference.

  Hi, i'm raising the summary tables by using the following query, INSERT INTO ClientTbl_SummarySales…

  Anamika

  8 replies

  7 years ago

  By: zaguarman