T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Creating a custom column

  Hello I have question regarding creating a custom column that will put a list of 5 values for each …

  npatel 17252

  4 replies

  11 years, 10 months ago

  By: npatel 17252

• Update/Insert Trigger with Condition

  Hi, I am currently in the process of writing an INSERT/UPDATE trigger in SQL 2012, the scenario is,…

  tress

  1 replies

  11 years, 10 months ago

  By: Sean Lange

• Making a record set horizontal

  Hello everyone I have a client with a fairly simple table as illustrated in my sample code. Their …

  jshahan

  3 replies

  11 years, 10 months ago

  By: Sean Lange

• Aggregate Monthly values from interval values

  I want to aggregate to monthly values for the reading. I want to display Reading value for Oct 2010…

  smart_analyst

  4 replies

  11 years, 10 months ago

  By: rhythmk

• horizontal to vertical rows conversion

  create table #temp1 ( col1 float, col2 float, col3 float, clo4 float) insert into #temp1 values (1.…

  mxy

  1 replies

  11 years, 10 months ago

  By: Eirikur Eiriksson

• how to aggregate interval data to hourly values?

  Hi, I am using the below script and I am getting data for 15 minutes interval. I would like to agg…

  smart_analyst

  7 replies

  11 years, 10 months ago

  By: smart_analyst

• ?? on First and last day on 4 months prior

  Hi Not sure how to setup how to setup a statement to get the first and last day of the month for 4 …

  jbalbo

  1 replies

  11 years, 10 months ago

  By: jbalbo

• Select * if null passed else by INT

  Hi, I'd like to be able to offer the option of selecting a project by the ProjectID number, and if …

  Marcus Farrugia

  10 replies

  11 years, 10 months ago

  By: Gail Shaw

• Help Need in combining Result in Column level

  Hi, Below is my sample table and data With Item as( Select 1 as ItemId,'ItemName1' as ItemName,100 …

  KGJ-Dev

  5 replies

  11 years, 10 months ago

  By: KGJ-Dev

• Check my query

  I have the following DECLARE @NocMsg VARCHAR(MAX) = ''; SELECT @NocMsg += ISNULL(TD.RefNum + ' ', …

  djj

  2 replies

  11 years, 10 months ago

  By: djj

• SQL Stored Procedure help

  So my company had a report created by a consulting group before I came on board, and now I am basic…

  npatel 17252

  7 replies

  11 years, 10 months ago

  By: npatel 17252

• Can it change columns of a table values to rows

  Hello, I have a table with this info: NrCard numberPersonAuto123456789101112 1111…

  Myke85

  2 replies

  11 years, 10 months ago

  By: Myke85

• Search Logic Fails

  Hi, Below is my table structure. please assume that below CTE as real tables. with Market as ( sele…

  KGJ-Dev

  6 replies

  11 years, 10 months ago

  By: ScottPletcher

• how to load oracle database data to sql server with the help of SSIS

  how to load oracle database data to sql server with the help of SSIS

  krishna.sqlbi28

  4 replies

  11 years, 10 months ago

  By: ocean3300

• Is there a better way to constuct this reverse Wildcard Select statement

  I am trying to find all the patterns that match a specific item number. This is the reverse of what…

  mpdillon

  5 replies

  11 years, 10 months ago

  By: mpdillon