T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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

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

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

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

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

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

  12 years ago

  By: KGJ-Dev

• Check my query

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

  djj

  2 replies

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

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

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

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

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

  12 years ago

  By: mpdillon

• Combine to tables to display iteratively

  Hi I am looking for a way to combine the following two tables to get a result set that would look l…

  Marcus Farrugia

  6 replies

  12 years ago

  By: Marcus Farrugia

• UPGRADTION FROM SQL EXPRESS TO STANDARAD EDITION 2008r2

  Hi, We need a calarification about upgradation sql 2008 r2 Iam going to upgrade sql express edtio…

  pradeep.k 50453

  1 replies

  12 years ago

  By: free_mascot

• How to use stored procedure to query data in anohter server?

  Hi I am a newbie to sql server so please help me! Say I have to server, A and B. Now I want to wri…

  x1029cloud

  4 replies

  12 years ago

  By: x1029cloud