T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to have cummulative sum of a column values based upon a condition?

  I have a query which brings the data using a view. I want to perform a cumulative sum of the amount…

  pradeep.kumar.jakhar

  6 replies

  15 years, 9 months ago

  By: sunitkrishna

• Patients who come in within 14 days

  Dear All, I'm trying to wriite sql query and i would like to know how would write the following in …

  jbon007

  14 replies

  15 years, 9 months ago

  By: jbon007

• Filling in missing data from one table to the other

  I need to populate a table's missing values with values from another table. Table USER_CUST should …

  Rog Saber

  1 replies

  15 years, 9 months ago

  By: Russel Loski

• Store Procedure Issue

  Hi All, I ran a sp from query analyser mode.. result came .. when i call this SP from applic…

  balaji.ganga

  4 replies

  15 years, 9 months ago

  By: sanmatrix

• To make a audit vertically in TSQL

  Hi Experts, I have a two table Table 1: Table 2_log, Table 1:(THis is Master Table will have 1 mill…

  Saravanan_tvr

  2 replies

  15 years, 9 months ago

  By: sanmatrix

• Query help

  Hi All, create table #abcd (id int, code varchar(10), relt_id int ) insert into #abcd (id, code, r…

  ssc_san

  2 replies

  15 years, 9 months ago

  By: ssc_san

• Can we execute multiple Alter statements in an IF else block for One tbale

  Rt not i am performing Alter statements for a tabe one at a time as shown below, I have to add 4 co…

  SQLTestUser

  5 replies

  15 years, 9 months ago

  By: Sean Lange

• UPDATE statement

  I have a table with multiple years of data but the state_average_percent & district_average_pe…

  Opus

  7 replies

  15 years, 9 months ago

  By: J-F Bergeron

• Replacing part of a substring with the substring

  I'm attempting to use the following query to update the substring %/themes/old/% with '%/themes/ne…

  rabisco

  1 replies

  15 years, 9 months ago

  By: WayneS

• How to move the SQL server table insert rows from test server to Prod server

  Hi All, I have situation. I have some rows in the sql server 2005 database table, need to be move f…

  p.ravirao

  3 replies

  15 years, 9 months ago

  By: p.ravirao

• count on several colum

  Hi all, I'm working on a small project which happened to use a SQL Server 2008 DB developed in the …

  ilbric-762008

  6 replies

  15 years, 9 months ago

  By: ilbric-762008

• how to preaggregate data in table

  Hi, there is a report generated with a proc and it uses a smry tbl (million plus records)... the pr…

  charuhelaiya

  2 replies

  15 years, 9 months ago

  By: The Dixie Flatline

• Write a SELECT statement that answers the question

  NotFlix Database Your SQL test will use the NotFlix database. This database has two tables for an …

  varunkum

  5 replies

  15 years, 9 months ago

  By: The Dixie Flatline

• sum by each quarter

  Hi, I ahve a period table like this. SELECT [PeriodID] ,[StartDate] ,[EndDate] ,[…

  cpinky01

  3 replies

  15 years, 9 months ago

  By: cpinky01

• Perform logical AND/OR base on number of rows without dynamic SQL

  Hi there, I have entity where the fields are expressed in rows rather than columns.. I know it is p…

  shield_21

  13 replies

  15 years, 9 months ago

  By: Jeff Moden