T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Get one row from query

  Hi, (SELECT COUNT(ID) AS TCount from dbo.Listing where StatusPriorMonth ='Active' ) SELECT COUNT([A…

  PSB

  4 replies

  15 years ago

  By: SQLRNNR

• Invalid In Select List Because Not In GROUP BY Clause

  Hello - I am trying to run the following query: Select column1, column2, column3, CASE WHEN ((sel…

  Triality

  15 replies

  15 years ago

  By: SQLRNNR

• Truncating string Characters

  Hello All, I’ve been researching this all morning and so far have not come up with a solution and t…

  Ronnie Jones

  4 replies

  15 years ago

  By: Ronnie Jones

• problem about ' charachter when saving record.

  hi. i have problem about a query with dinamic insert. i have a few table that i set their column na…

  sa.ordekci

  7 replies

  15 years ago

  By: m_cg

• Merge join and Hash join

  Can any body tell me what is merge join and hash join in sql server and what is the use of that?

  ghanshyam.kundu

  2 replies

  15 years ago

  By: Grant Fritchey

• Calculations in query

  Hi, I have the following schema and sample data. CREATE TABLE [dbo].[sscSignalTypes]( [signalTypeI…

  keymoo

  5 replies

  15 years ago

  By: keymoo

• adding preyear column besides year column

  Hi, I need your expertise on this issue. Basically the reason to do this is to calculate YTD values…

  yingchai

  2 replies

  15 years ago

  By: Sriram.RM

• Please give me an example of a T-SQL Statement that does user maping

  Please give me an example of a T-SQL Statement that does user maping

  martin.s.ransome

  10 replies

  15 years ago

  By: Orlando Colamatteo

• Splitting qualified name into table and schema

  is there an easy way to split a fully qualified name into schema and tablename? My issue is the nam…

  tshad

  12 replies

  15 years ago

  By: seth delconte

• Find identity of table if exists

  I was trying to get the identity for a table and whether one exists. I tried the following I had f…

  tshad

  7 replies

  15 years ago

  By: tshad

• How to duplicate a record but with different values...........

  I am having difficulty in trying to wrap my head around, maybe it is just that I am back from vacat…

  Brandon Carl Goodman

  2 replies

  15 years ago

  By: Brandon Carl Goodman

• Convert ColumnValues to a row.

  Query: ------- SELECT RoleName FROM ROLES Output: -------- RoleName --------- Admin User Process Qu…

  Hafeez Mohamad

  1 replies

  15 years ago

  By: Orlando Colamatteo

• count occurrences of unique 2 column combination

  I want to select the number of occurrences in table [extlinks] with a count on unique occurrences o…

  petervdkerk

  10 replies

  15 years ago

  By: lgonzales 69796

• help about dinamic query

  hi. i have a dinamic query like below: ALTER PROCEDURE [dbo].[Update_DinamikGal] @baslik varchar(ma…

  sa.ordekci

  5 replies

  15 years ago

  By: sa.ordekci

• How to create a Login with T-SQL

  and then Login to Management Studio

  martin.s.ransome

  1 replies

  15 years ago

  By: Sean Lange