T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Find all tables without a Primary Key

  Is there a script which will report all tables that do not have a Primary Key?

  dbalorenzini

  3 replies

  13 years, 10 months ago

  By: okbangas

• tset

  Hi SQL Gurus, I would like to run a query to display the amount in a debit and credit column from a…

  yingchai

  1 replies

  13 years, 10 months ago

  By: yingchai

• Simple select by max date

  Hello, I know there are many ways to return data based on the max date. I have data in which there…

  oradbguru

  9 replies

  13 years, 10 months ago

  By: Dwain Camps

• Problem using COALESCE with GROUP BY

  Hi All, It's been a while since I have posted in here 🙂 I am trying to update my query to add a cou…

  Ste_P

  5 replies

  13 years, 10 months ago

  By: dogramone

• Using datediff/dateadd function

  I need help on using date functions. I have to calculate the date on friday for past 8th week. Here…

  nehaCS

  6 replies

  13 years, 10 months ago

  By: nehaCS

• checking for strings in open row set

  Hello All, I am trying to connect to the table which is in different server. I am using open row se…

  SQL Prog

  2 replies

  13 years, 10 months ago

  By: SQL Prog

• Keylookup -what is the harm

  Hi Experts, I know that key lookup happens , if any one of the select column that…

  chaithu559

  4 replies

  13 years, 10 months ago

  By: Steve Jones - SSC Editor

• Updating a column

  Hello All, I have 2 different servers. In that 2 servers I have 2 tables one from each.I need to up…

  SQL Prog

  2 replies

  13 years, 10 months ago

  By: SQL Prog

• Cumulative Total

  I have a table with this values: key year month value ------------------------ 1 2011 1 100 1 2011 …

  antonela

  7 replies

  13 years, 10 months ago

  By: TheSQLGuru

• Number of clients per week on average during year

  I've got an interesting little problem that I can work my way around for a one-off exercise, but I'…

  phual

  6 replies

  13 years, 10 months ago

  By: phual

• Order column with multiple dots in number

  Hi All, I have the following table: SELECT level INTO #myTable FROM(VALUES('1'),('1.1'),('1.2'),(…

  WesselN

  7 replies

  13 years, 10 months ago

  By: Mark Cowne

• How to get the overall average

  Hi Forumer's How could i get the overall average for Jan to Dec transaction i want to incorporate i…

  Kaniguan_SQL

  6 replies

  13 years, 10 months ago

  By: Kingston Dhasian

• Untrusted Foreign Key

  I am finding a few foreign keys in my database that are not trusted select object_name(parent_obj),…

  JohnnyDBA

  4 replies

  13 years, 10 months ago

  By: okbangas

• Help geting TSQL correct result

  I have a table with an id and code(char(3)) 100, XXX 100, yyy 100, zzz 101, abc 101, XXX I'm trying…

  wrgarfield

  3 replies

  13 years, 10 months ago

  By: vinu512

• Datetime and sp_executesql Issue

  Here's part of code i've been trying to run in a procedure, cursor is already defined: DECLARE @fo…

  RovanSQL

  10 replies

  13 years, 10 months ago

  By: Gazareth