T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Linked server queries

  I have a view that is built on OPENQUERY function calls to linked server (Oracle db). When I run q…

  Mark Harley

  1 replies

  13 years ago

  By: Mark Harley

• Text Search for age-group related words

  Hi Everyone, I have an app that creates groups and designates members based on their age. Now I wou…

  kevinp81

  2 replies

  13 years ago

  By: kevinp81

• OPENXML query problem

  Hi, I need help with querying an xml file with openxml. My xml file looks like that (it is longer, …

  marton.fritz

  2 replies

  13 years ago

  By: marton.fritz

• Hierarchical Child Records with Multiple Parents

  Hello, In my limited experience I have used a cte to write simple hierarchical result sets but this…

  nfs_john

  14 replies

  13 years ago

  By: geoff5

• add a new column to a table with conditions

  hi friends i want to add a column to a table with conditions below : 1- it has a default value=0 2-…

  pooya1072

  5 replies

  13 years ago

  By: Lowell

• WHERE clause

  I am trying to write a where clause that tests for a string which may or may not contain a specific…

  Mark Harley

  2 replies

  13 years ago

  By: geoff5

• I want to validate where each parent intermediary is also a parent to itself?

  Hi All', I want to validate where each parent intermediary is also a parent to itself. So t…

  manoj.ramaiah

  1 replies

  13 years ago

  By: Kingston Dhasian

• OFAC Compliance queries

  Hi, I am trying to implement OFAC Compliance check using sql queries to search for data in our data…

  Sridhar-137443

  10 replies

  13 years ago

  By: wbar

• Query Help

  Hi,Can some one throw some light on how to approach this.... CREATE TABLE A (ID1 VARCHAR(10),ID2 VA…

  ivar_SQL

  10 replies

  13 years ago

  By: ivar_SQL

• need help with my SQL

  greetings all, I'm trying to return a row of data for each licence and want that row to include the…

  robert.williams 82816

  3 replies

  13 years ago

  By: Mansfield

• Which is faster, Sub Query or Join? and Why ?

  Hi Friends, I'm new to SQL. And I wand to know Which is faster, Sub Query or Join? and Why ? Thanks…

  vignesh.ms

  4 replies

  13 years ago

  By: Gail Shaw

• Query Help

  Create table #temp ( ID int identity(1,1), ActivityName varchar(max), ActivityDate datetime ) In…

  kapil_kk

  6 replies

  13 years ago

  By: Aadhar Joshi

• Querying Snapshot Data

  Can someone help me with querying the snapshot data as show in the attached file?

  rka

  1 replies

  13 years ago

  By: HanShi

• having problem in creating table from another table

  Hi all, I have a table with 2 columns named Depot_Id & Depot_Name, i have to make another tabl…

  abhishekagrwl25

  8 replies

  13 years ago

  By: Kingston Dhasian

• Why would you ever use EXECUTE AS CALLER?

  Since it is the default, I don't understand what the point of this option would be.

  Golfer22

  1 replies

  13 years ago

  By: Andrew G