T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Adding Missing data for one person

  Hi, ;WITH cte2 AS ( SELECT a.personkey as APK, --b.personkey BPK, a.BaseLocationKe…

  Mr. Kapsicum

  1 replies

  12 years, 1 months ago

  By: Eugene Elutin

• Including the filename in a bcp load.

  I'm loading a bunch of csv-type files via bcp using an xml format file, and triggering the load fro…

  David McKinney

  3 replies

  12 years, 1 months ago

  By: David McKinney

• Fudging time

  Hi All, I am working on a report that demonstrates how much time a room is on use between parameter…

  Eliza

  3 replies

  12 years, 1 months ago

  By: Jeff Moden

• Getting the 'next' occurance of historic dates

  Hi All, I'm using SQL Server 2008 r2. I have a table with lots of dates, some in the past, some in…

  SQLQuestion 35902

  4 replies

  12 years, 1 months ago

  By: SQLQuestion 35902

• Using OVER Clause to instead of multiple selects

  Hi I think I should be able to do this with a single query using OVER clause, but I cannot get it t…

  terry999

  3 replies

  12 years, 1 months ago

  By: ChrisM@home

• Syntax Error with Multi-Table Joins

  Newbie here. Having trouble with a multi-table join exercise, code below. A two-table join works fi…

  timSF

  4 replies

  12 years, 1 months ago

  By: pietlinden

• How to write a Query to get related result

  I need help to write a query like below oupt put. create table #table (id int, cid int , startdate …

  suresh0534

  16 replies

  12 years, 1 months ago

  By: SQLRNNR

• Count NULL columns

  Hi All, I am working on the below requirement. use css go create table test ( eno int, t1 int null,…

  karthik M

  4 replies

  12 years, 1 months ago

  By: ScottPletcher

• Brand new error - Invalid object name in T-SQL insert statement

  I've been using SQL Server 2008 R2 for my web development for years and it's been working perfectly…

  kahanu14

  6 replies

  12 years, 1 months ago

  By: Luis Cazares

• Filter out records from table

  Hi, I have a table where I want to filter out some records. I want to get maximum OF enddate BY U…

  PSB

  1 replies

  12 years, 1 months ago

  By: HanShi

• SELECT * INTO TABLE

  Hi how can I archive to SELECT * INTO existing table without listing column names?

  hoseam

  4 replies

  12 years, 1 months ago

  By: Abu Dina

• variable Scoping

  Hi all, DECLARE @batchSize INT Declare @siteid nchar(3) DECLARE @Instanceid nchar(3) set @siteid =…

  kapil_kk

  3 replies

  12 years, 1 months ago

  By: Dwain Camps

• Job to delete folders older than X days old ?

  Hi I wanted to run a job nightly that would delete folders within a folder that where older than 3 …

  jbalbo

  2 replies

  12 years, 1 months ago

  By: SQLRNNR

• AVOID JOINING ON TO THE SAME TABLE MULTIPLE TIMES?

  Hi there, I need to join onto a table (Class_TB) twice because one of the conditions (Airline_FD) c…

  James Millar-305032

  5 replies

  12 years, 1 months ago

  By: ScottPletcher

• Need help on SQL script

  Hello, I am learning SQL and wondering if someone can help me with script below – not sure if I am …

  jds-685721

  13 replies

  12 years, 1 months ago

  By: jds-685721