T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Create dummy data from Sub Table

  Hi, I need advise on how to create dummy data from sub table. 1. I have 2 table, 1 is Main Table an…

  fjchairul

  2 replies

  10 years, 9 months ago

  By: fjchairul

• find whether a upper case letter is there in a given string

  Hi all, i want to know whether a upper case letter is there in a given string or not? if i provide …

  from corporate

  10 replies

  10 years, 9 months ago

  By: guptashailesh.87

• Select second row of a table

  i have this query to count people who are in different deployment SELECT Trade.Trade, Trade.Auth, …

  baijuep

  5 replies

  10 years, 9 months ago

  By: Luis Cazares

• pivot 3 columns

  I've used PIVOT before but it was for a single column. How do I pivot 3 columns while concatenatin…

  is250sp

  11 replies

  10 years, 9 months ago

  By: is250sp

• updating column with data validation from other master table

  I have two tables CustomerOrders Country I would like to write a Update statement on customer order…

  skb 44459

  2 replies

  10 years, 9 months ago

  By: rahul.rahuzz

• Deleting all characters to the right of char(13) or char(10).

  I have a table that has a varchar(255) column. In that column, there are instances where data has …

  gcook 48147

  1 replies

  10 years, 9 months ago

  By: Lynn Pettis

• cross apply behaves like outer apply

  In my example, cross apply generates 5 rows when sum is used and 3 rows when no aggregate statement…

  atsql

  3 replies

  10 years, 9 months ago

  By: atsql

• How to get user roles

  When a user logs into my application, I would like to see which DB roles are assigned to that user.…

  Rog Saber

  9 replies

  10 years, 10 months ago

  By: nishav2

• Working with coalesce on a view

  I am creating a view with below script from 3 tables. I am having problems when a HCPCS is found in…

  MadRazzi

  4 replies

  10 years, 10 months ago

  By: Luis Cazares

• Append record

  I heed to append a record to my table. It contains may columns (about 90) .The fist column is Cust…

  dosia2

  9 replies

  10 years, 10 months ago

  By: gbritton1

• Union With IF

  Hi

  nandu.chowdary412

  2 replies

  10 years, 10 months ago

  By: nandu.chowdary412

• Distributed query - variable performance

  Hi, I was wondering if anyone could help me out with this one. I have a query (view) which resides …

  NicHopper

  3 replies

  10 years, 10 months ago

  By: NicHopper

• using select union all using multiple databases

  I would like to create a view for a very complex query and it should run for multiple databases. I …

  skb 44459

  3 replies

  10 years, 10 months ago

  By: Jason Wolfkill

• append record from the same table , change customer field based on parameter

  test

  dosia2

  2 replies

  10 years, 10 months ago

  By: dosia2

• Problems with a order of the rows

  People, I am new here in the forum. I have a table that contains a list of equipment. The equipment…

  rodrigo_fabiam

  6 replies

  10 years, 10 months ago

  By: rodrigo_fabiam