T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Union all fields of tables with conditions

  I have 3 tables A(A1,A2), B(B1,B2), C(C1,C2) Create table A(A1 int,A2 int) Create table B(B1 int,B2…

  nguyennd

  4 replies

  15 years ago

  By: ColdCoffee

• Print Column names vertically from table

  I want to print column names from table vertically without using pivot/unpivot .

  rav999

  8 replies

  15 years ago

  By: ColdCoffee

• Help using Exists in stored procedure

  I have two tables. Customer and Case. The 2 tables are related by CustomerID. Each table has a date…

  paulmac106

  2 replies

  15 years ago

  By: LutzM

• How to select top 3 rows and convert the rows to columns for each group

  I have a table with customerID,caegory,cnt. I want select the top 3 cnt and category names (order …

  sliu

  4 replies

  15 years ago

  By: WayneS

• Updating dates

  I want to update all Start_date fields that have a time of 00:00:00.000 to 07:00:00.000. If I try a…

  Rog Saber

  3 replies

  15 years ago

  By: Rog Saber

• Query with column name as parameter

  Hi , I have a functios that will return the column name like column1,column2,column3,column4 but …

  Saravanan_tvr

  3 replies

  15 years ago

  By: Nevyn

• CASE clause not working as expected in a SELECT statement. Help

  SELECT CASE WHEN ROUND(18.00,2) = CONVERT(INT,18.00) THEN CONVERT(INT,18.00) ELSE 18.00 END …

  srinivas pallikonda

  6 replies

  15 years ago

  By: Alex M-728960

• Comma Seperated Values

  Hi May you please help how do I insert comma seperated values into a temp table. eg. i have procedu…

  Trybbe

  7 replies

  15 years ago

  By: WayneS

• Need help in complex search query optimization

  Need help in optimizing following query. I am having long delay if i am opening the commented lines…

  Kamran Shahid

  3 replies

  15 years ago

  By: Kamran Shahid

• how to get the count of all the tables in a database

  HI, How can i get the row count of all the tables in a db Here is the example i got a DB with three…

  tripri

  3 replies

  15 years ago

  By: Cory E.

• Any performance improvement

  Hi is there any performance improvment in sql 2008 while providing comma(,) at the left side of the…

  SQL006

  8 replies

  15 years ago

  By: Philipp Post

• check if Row exists in the table

  Hi I have a table CurrencyAccount CREATE TABLE CurrencyAccount ( CurrencyAccountID int PK CurrencyC…

  SQL006

  9 replies

  15 years ago

  By: SQL006

• Get values from tables based on tables mapping

  Hi, I have a mapping table named TableMap that indentify some columns from some tables: TableMap P…

  ioani

  2 replies

  15 years ago

  By: ioani

• Does MERGE MATCH on current data?

  When you do a MERGE ... WHEN MATCHED THEN UPDATE ... WHEN NOT MATCHED BY TARGET THEN INSERT ... …

  David Data

  2 replies

  15 years ago

  By: David Data

• Get values from tables based on xml mapping

  Hi, I have a table that indentify some columns from some tables: Param | SchemaName | TableName …

  ioani

  1 replies

  15 years ago

  By: Mike01