T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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

  14 years 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

  14 years 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

  14 years 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

  14 years 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

  14 years 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

  14 years 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

  14 years 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

  14 years 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

  14 years 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

  14 years 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

  14 years 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

  14 years ago

  By: Jared

• Need help with query to find out which sprocs that reference another db

  I have 2 databases, DB A and DB B. I have stored Procedures on DB A and I need to find which ones a…

  dndaughtery

  7 replies

  14 years ago

  By: OTF

• Using group by

  Hi there, Is it possible to use group by in a way that it uses a specified range rather than the di…

  oolawole

  4 replies

  14 years ago

  By: oolawole

• TOP 10 of each Division

  Hi Is it possible to have a query to return top 10 items from each division. Example Table columns:…

  meelan

  13 replies

  14 years ago

  By: ColdCoffee