T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Delete query with like option is not working

  Hi friends , I need to Delete from table with conditions : Example of my query!!! Delete from TAb…

  komal145

  2 replies

  13 years, 10 months ago

  By: komal145

• Delete query with like option is not working

  Hi friends , I need to Delete from table with conditions : Example of my query!!! Delete from TAb…

  komal145

  2 replies

  13 years, 10 months ago

  By: Lynn Pettis

• Store output in Tables of Store Procedure which gives OUTPUT in more than 1 DataSet (Table)

  Dear All, Hi I have a Store Procedure which gives OUTPUT in 2 Data Sets (Tables). Now I need to sto…

  bharat sethi

  2 replies

  13 years, 10 months ago

  By: SQL Padawan

• IN vs Exists

  Hi All, I have a basic doubt on using IN/EXISTS. When to use IN over Exists/Exists over IN? I heard…

  SQL*

  9 replies

  13 years, 10 months ago

  By: FunkyDexter

• Pull Out Min Date in QUERY

  Hi FOrumer's I have my query to get the min date from sample2 table using the ESN andreturndate as …

  Kaniguan_SQL

  3 replies

  13 years, 10 months ago

  By: Dwain Camps

• Max value in the table

  Hello all, I was expecting the maximum value for the code mentioned below to be "005", but it is di…

  ssc_san

  19 replies

  13 years, 10 months ago

  By: ssc_san

• trying to rename column

  I have a table with a PK called '[ID]'. I want to rename it so that it is without brackets. How…

  polkadot

  1 replies

  13 years, 10 months ago

  By: Lynn Pettis

• Unexpected results when I Join, use View or Cross Apply - mysterious

  If I do a simple select from my table independently, I get the correct number (I confirmed this out…

  brosspaxedi

  6 replies

  13 years, 10 months ago

  By: brosspaxedi

• Multiple Counts as seperate columns in a single SQL query

  I've the two below queries which I've identified as 1 and 2. All I want is to get the 'Denied Cust…

  sql1411

  3 replies

  13 years, 10 months ago

  By: Sean Lange

• Combining Code

  Any idea how I can list the alternate parts on the same row as the parent part? There may be severa…

  bpowers

  4 replies

  13 years, 10 months ago

  By: bpowers

• foreign key in tble

  I have two tables that I am questioning in a sql server 2008 r2 database. The table called [dbo].[A…

  wendy elizabeth

  5 replies

  13 years, 10 months ago

  By: ACinAZ

• update table

  hi ,i have 1 table Declare @temp1 table( id int, code char(10), value float) insert into @temp1 val…

  harri.reddy

  6 replies

  13 years, 10 months ago

  By: Lynn Pettis

• Create XML file using TSQL

  I am trying to create a xml file from a sql table. Please see the sample data below. Any help is ap…

  UnionAll

  5 replies

  13 years, 10 months ago

  By: joe-871382

• Displaying multiple rows into single column

  Hi I Have distinct values like 1 game1 2 game2 3 game4 I want output in 1 game1 game2 game4 Below…

  sqlbi

  6 replies

  13 years, 10 months ago

  By: sqlbi

• TSQL Query

  Hi all I am struggling to understand the following code SELECTCOUNT(*) AS UserCount, LogDate, Lo…

  Kwisatz78

  4 replies

  13 years, 10 months ago

  By: Kwisatz78