T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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

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

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

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

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

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

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

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

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

  14 years ago

  By: sqlbi

• TSQL Query

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

  Kwisatz78

  4 replies

  14 years ago

  By: Kwisatz78

• Query to find the size of data of a query using built-in functions

  Hi all, Good morning Can anybody help me to find the size of data of a query resultset other client…

  DURGESH-769360

  3 replies

  14 years ago

  By: Robert Davis

• Count Rows of a table Without using Count() Function

  Hi, Is there any way we can Count the rows of a table without using the Count() Function? Vinu Vija…

  vinu512

  7 replies

  14 years ago

  By: Dwain Camps

• SQL Query

  Hello All, I am working on a procedure that just creates 2 temp tables and insert the records into …

  SQL Prog

  4 replies

  14 years ago

  By: SQL Prog

• Need help with where clause

  Hello, I have the following query in which I need help with the substring join: select x.labtest_…

  oradbguru

  1 replies

  14 years ago

  By: oradbguru

• Build string from table data

  I have a table with 1 column containing the following: SELECT * FROM TEST STYLE HK82382 HK82386 HK8…

  JayWinter

  3 replies

  14 years ago

  By: JayWinter