T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• grouped running totals

  Hi all. Firstly, here's some background and then some test data. I have a table that has lots of st…

  greg.bull

  9 replies

  13 years, 11 months ago

  By: Jeff Moden

• Concatenate today's date and tomorrow's date

  I have to Concatenate today's date and tomorrow's date in the below format using T-SQL. 2012.04.21.…

  Jay Pete

  3 replies

  13 years, 11 months ago

  By: Jay Pete

• sql server date time

  i am having the following sales details table with product code, date , time columns Product Code…

  varshini

  1 replies

  13 years, 11 months ago

  By: Thinknook

• BCP In Issue

  I have done a bcp queryout form a table to a csv file. Now when I'm trying to perform a bcp in from…

  sqlnaive

  8 replies

  13 years, 11 months ago

  By: sqlnaive

• Getting Last row in a partitioned list

  step 1: Please create a table below CREATE TABLE [dbo].[testPartition]( [testCol] [varc…

  pawan.boyina

  6 replies

  13 years, 11 months ago

  By: Lynn Pettis

• Partitioned Last row finding

  step 1: Please create a table below CREATE TABLE [dbo].[testPartition]( [testCol] [varchar](50) COL…

  pawan.boyina

  1 replies

  13 years, 11 months ago

  By: Kingston Dhasian

• T-SQL Server 2008 Questions

  Is this the correct place/thread to be created to for ask questions about T-SQL for SQL Server 2008…

  sean.ellefsen

  1 replies

  13 years, 11 months ago

  By: Kingston Dhasian

• Conditional select of identical fields from joined tables

  Please find script to create tables below. With a record in [ads], of the boolean columns [iscompan…

  petervdkerk

  3 replies

  13 years, 11 months ago

  By: CapnHector

• Deduplicating data question

  Hi all - I've been tasked with de-duplicating some customer data and am having difficultly getting …

  TheRealDJ

  6 replies

  13 years, 11 months ago

  By: Orlando Colamatteo

• How to I trap the first error in a process that has failed (Only using restore DB snapshot as an example)

  Hi All, I'm testing a stored proc to restore a database snapshot and not able to trap the first err…

  pjl0808

  1 replies

  13 years, 11 months ago

  By: Orlando Colamatteo

• WHERE (NOT (column_name IS NULL))

  Is their a best practice for re-coding this ? (this predicate is being applied to a 500 M row ta…

  Express12

  4 replies

  13 years, 11 months ago

  By: Lynn Pettis

• Multiple Table Join to display records where 2 columns don't exist in a table

  I have 2 tables: TableA TableB TableA contains 2 columns: EmployeeID and Code (plus a handful of ot…

  wdodds

  3 replies

  13 years, 11 months ago

  By: wdodds

• write dbcc command result to excel

  I want to write a SQL job that generates an excel file containing the result of DBCC SQLPERF(LOGSPA…

  CraigIW

  5 replies

  13 years, 11 months ago

  By: CraigIW

• HOT -- Multiple SUM, AVG on Multiple rows in an aggregated query

  Good Day All First of all am new here not really familiar with IFCode Shortcuts but will try my bes…

  shani19831

  4 replies

  13 years, 11 months ago

  By: shani19831

• Merge two select statements

  Hi I hope someone can help I am relativley new to using sql so i apoligise before hand if this is a…

  mark.doyle

  8 replies

  13 years, 11 months ago

  By: Jared