T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Help! Get version for each set of rows

  In our concern, we have a table with lots of redundant rows, to avoid the redundant, we create some…

  thava

  10 replies

  12 years ago

  By: thava

• Calculating Bandwidth Data

  Here's a good puzzle that I need some help figuring out. I'm trying to calculate DSL bandwidth data…

  brickpack

  4 replies

  12 years ago

  By: brickpack

• Help me optimise this query

  SELECT a.claim_id, a.claim_created, "order" = ( select min(order_id) from dbo."o…

  Gaja

  6 replies

  12 years ago

  By: ScottPletcher

• Benchmark Difference

  I created a table called Performance_Statistics that have several columns with just about every SQL…

  SQLKicksButt

  2 replies

  12 years ago

  By: SQLKicksButt

• Count 2 if met criteria

  I have SQL view table to run my report. We want to count how many donations the donor contributed i…

  wanxzhu

  7 replies

  12 years ago

  By: wanxzhu

• CTE has more columns than were specified in the column list

  Hi, I get the following error , when I execute my CTE on SQL Server 2008 R2. Please help CTE1 has m…

  ms-techie

  2 replies

  12 years ago

  By: Sean Lange

• Help need in using same table having Parent and child relationship

  Hi, Below is my sample data of my table named "Groups" with Groups as ( select 1 as GroupId,'Orac…

  born2achieve

  5 replies

  12 years ago

  By: born2achieve

• Efficient way to get the lowest unused value of a nvarchar field being used as a primary key

  Hi all, Trying to get the lowest unused value of CrewID from the below table in a efficient manner …

  micalo

  10 replies

  12 years ago

  By: micalo

• Still get status - Y

  Hi SQL-GURU, I just make a simple qeury as following; select inc_cat.inc_cat_sc, inc_major.inc_majo…

  GG_BI_GG

  1 replies

  12 years ago

  By: Gail Shaw

• Create index question

  I would like to create an index with a few options but having issues trying to parse and run it suc…

  Peter D-251663

  4 replies

  12 years ago

  By: Peter D-251663

• carry forward values from previous rows

  Hi, I am working on a rewards program and I have a table whenever customer completes a trip, his t…

  ivar_SQL

  5 replies

  12 years ago

  By: J Livingston SQL

• Is View Cached somewhere in SQL Server 2008 R2

  Hi, Currently there is a view in PRODUCTION. When I do a SP_HELPTEXT VIEW1 , it gives me the VIEW C…

  ms-techie

  3 replies

  12 years ago

  By: Eirikur Eiriksson

• Find null values between 3 datasets, in one table

  I have a table with data in two columns, item and system. I am trying to accomplish is we want to c…

  tmac25

  2 replies

  12 years ago

  By: tmac25

• convert binary string to table value construct

  I'm about to start on this but my search revealed nothing. Anyone have a code snippet for changing …

  Erin Ramsay

  6 replies

  12 years ago

  By: Erin Ramsay

• Grouping of data based on moving time period

  Afternoon, looking to pick some brains here to what I think is a grouping problem. I hope my explan…

  Dohsan

  7 replies

  12 years ago

  By: Dohsan