T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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 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 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 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 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 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 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 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 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 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 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 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 ago

  By: Jeff Moden

• select boolean resultvalue based on column value

  I have a table which has a column thumbid of type int I want to select if the column thumbid holds …

  petervdkerk

  3 replies

  15 years ago

  By: WayneS

• Help with inserting NULL into test table

  I am in the process of creating some test data which will include NULL values. I looked around for …

  Paul Morris-1011726

  9 replies

  15 years ago

  By: WayneS

• Help with query

  Hi , I wanted to match the names like "Robert"="Robart" …

  dheer

  5 replies

  15 years ago

  By: Derrick Smith