T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Update on large table using SELECT

  Hello comunity I see a TSQL script to make UPDATE on large table : select 'update fl set radicaltip…

  luissantos

  8 replies

  14 years ago

  By: Sean Lange

• Refactoring an SP - stuck on a query

  I'm rewriting a cursor-riddled SP and I'm stuck on one particular part. Basic testbed: CREATE TAB…

  Pam Brisjar

  15 replies

  14 years ago

  By: Jared

• bcp issues "Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file"

  So i'm converting a feed file process from dot net to sql based. I've got a select that needs to be…

  Snargables

  5 replies

  14 years ago

  By: Snargables

• order by COUNT(x) in rank

  Hi folks, This is an excerpt from a piece of old code I'm dealing with: RANK() OVER (PARTITION BY …

  Jonas Bergström

  3 replies

  14 years ago

  By: Jonas Bergström

• How to get all rows of a table having NULL in all columns?

  Dear All, I am looking for a solution without compromising on Performance & without writing al…

  bharat sethi

  11 replies

  14 years ago

  By: TomThomson

• Getting the average of a row

  I wish to get a formula which will enable me calculate the average of a row. I am working on studen…

  Joses Wagugwe Wakabi

  3 replies

  14 years ago

  By: Joses Wagugwe Wakabi

• Contents of a script file and output file into a table

  Hi, I'm trying to keep a copy of all scripts run against a database and their output into a table, …

  Seth Kramer

  4 replies

  14 years ago

  By: OTF

• foeign key in table

  Basically I am tyring to decide how to load the history table on a daily basis. (The history table …

  dianerstein 8713

  1 replies

  14 years ago

  By: CapnHector

• Vertical to Horizontal

  Hi, i want to bring rows in a Detail-Table (vertical) into horizontal Form with a T-SQL Query (max.…

  info 58414

  11 replies

  14 years ago

  By: Dwain Camps

• Running Totals on PIVOT in T-SQL

  I have the following query SELECT * FROM ( SELECT Product ,[201101],[201102],[201103],[201104],[201…

  SQL STEWIE

  7 replies

  14 years ago

  By: SQL STEWIE

• clubbing a group of column values orderwise

  Hi, could you please help me to get a T-SQL statement for a scenario where if there is a table with…

  DataAroma

  2 replies

  14 years ago

  By: Dwain Camps

• Grouping by month with null months

  So I've been working on this for a little while now and I just can't get it. Consider it a real big…

  calvo

  2 replies

  14 years ago

  By: Gazareth

• Error while bcp

  I'm trying to bcp in data from a text file in unix to my sql server. It gives error as Unexpected E…

  sqlnaive

  5 replies

  14 years ago

  By: sqlnaive

• Get the course which has maximum no.of students enrolled

  Hi , We have 3 tables for ex student(sid,sname,dob), course(cid,cname,duration) and enroll(sid,cid,…

  ralm

  5 replies

  14 years ago

  By: ralm

• PIVOTING on more than One Col. to get data in given format.

  Dear All, Hi! I am searching a solution to PIVOT more than one column to get output in below mentio…

  bharat sethi

  1 replies

  14 years ago

  By: Dwain Camps