T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Joining dynamic tables

  I am trying to write a stored procedure that joins a table or does unions that has the table name i…

  tshad

  5 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• T-SQL help

  Hi, How can I write a query to return only records when one ManagerID(1430857) is tied to multiple …

  Attopeu

  6 replies

  14 years, 10 months ago

  By: ColdCoffee

• Function for getting date

  Hi, I have an issue . The issue is that I need to retrieve data such that Travel Date should be gre…

  Hakuna Matata

  3 replies

  14 years, 10 months ago

  By: Hakuna Matata

• Help computing distances between multiple points

  I have a table with an ID (identity), State, City, Address, GeoRef(Geography), and I want to comput…

  rschaeferhig

  7 replies

  14 years, 10 months ago

  By: The Dixie Flatline

• join statement

  i have 2 table let say table A and table B. A have values 1,2,3 B has values 1,2,4 i want query us…

  scottichrosaviakosmos

  3 replies

  14 years, 10 months ago

  By: KMPSSS

• Is there a way to do this?

  I have TableA: Col1...Col2...Col3...Col4...Col5 joe.....111....aaa...null....xxx bob.....222....bbb…

  Rog Saber

  4 replies

  14 years, 10 months ago

  By: Rog Saber

• replace identifier by space

  Hi i have a table of 10 millions records,now what i want to do is i want to clean the item name, i …

  vineetbhargav

  4 replies

  14 years, 10 months ago

  By: Sean Lange

• Does anyone have a script to restore full + transactional backup?

  Hi there, On my production server, I have a daily full backup at 01:00, differential backups from 0…

  Raymond van Laake

  5 replies

  14 years, 10 months ago

  By: Wildcat

• Auto calculation in values of column at design time

  I have to create one table which has 4 columns like: Col1, col2 , col3,col4 now i want that when i…

  scottichrosaviakosmos

  2 replies

  14 years, 10 months ago

  By: Ron McCullough

• How to get following output..

  Hi I have a table containing following type of information YRF No DateCr. Dr.…

  amitsingh308

  8 replies

  14 years, 10 months ago

  By: The Dixie Flatline

• Output old/new values of a column from an audit table

  A third party vendor has given us read access to an audit table, allowing us to review historical c…

  hwells

  2 replies

  14 years, 10 months ago

  By: hwells

• passing parameter to view

  Hi! i have two question. First, i use views for showing datas(tables) that don't made changes on it…

  sa.ordekci

  4 replies

  14 years, 10 months ago

  By: chrisfradenburg

• Need help with Stored procedure

  Hello all, I am kinda new to sql. I need help with creating a Stored PROCEDURE for validating the …

  dmathew011

  11 replies

  14 years, 10 months ago

  By: dmathew011

• Query Linked Server not working Please help

  I have a linked server setup when I run the following script select top 10 * from s22.database.tabl…

  Stephen crocker

  8 replies

  14 years, 10 months ago

  By: Welsh Corgi

• From TableA, TableB. Whats happening here?

  I recently came across a TSQL statement that I haven't seen in so long I've forgotten how it works.…

  dndaughtery

  4 replies

  14 years, 10 months ago

  By: Sriram.RM