T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• date question Convert or Cast Statment

  I can't get the Convert or Cast to work please help DATEADD(month,-3,DATEADD(D, -1, DATEADD(M,DATED…

  twdavis-893252

  8 replies

  13 years, 1 month ago

  By: twdavis-893252

• Help with placing condition - SQL Statement

  HI All .. I would be grateful if you could help me out with the SQL. I want to 'pivot' the data b…

  aarionsql

  7 replies

  13 years, 1 month ago

  By: aarionsql

• Calling dynmic sql from function

  Hi All, I need to do some complex calculation, where I must use dynamic sql. The problem is, I need…

  arup chakraborty

  3 replies

  13 years, 1 month ago

  By: Lynn Pettis

• SQL Query not working correctly

  For some reason these two statements are not returning the same data.. first is NULL and the second…

  dwilliscp

  3 replies

  13 years, 1 month ago

  By: Gail Shaw

• SELECT... COLLATE doesn't work with an IN clause

  This query does not work: SELECT * FROM INT_AUX_LISTING WHERE FIRST_NM IN ('Jean') COLLATE Latin1_G…

  jeanlibera

  8 replies

  13 years, 1 month ago

  By: Henry Treftz

• Trigger to capture data before and after an update

  Hi, I have been charged with the task of sending an Email any time a table has been updated. So, I …

  lbrady

  14 replies

  13 years, 1 month ago

  By: lbrady

• contains column_list as variable

  Hi, I'm having a problem with contains search function for example: declare @Column_list varchar(ma…

  bostjan-1030521

  3 replies

  13 years, 1 month ago

  By: Sean Lange

• Joining tables with two tables but displayed in only one row

  Hi All, Here is my problem: Suppose there are two tables A and B. A has Student Details. B has subj…

  prady_1988

  4 replies

  13 years, 1 month ago

  By: prady_1988

• insert values

  This my emp table i want to insert value in other table into emp_no table emp_id att_day …

  paramjit4

  13 replies

  13 years, 1 month ago

  By: paramjit4

• BETWEEN ages

  hi, i want know how to get the ages between 25-28 (from ages 18 until 45) when i do age between(25,…

  yaniv.zisano

  20 replies

  13 years, 1 month ago

  By: Dwain Camps

• Impersonate accounts

  Hi, I've a stored procedure that checks a few vital operational functions. One thing I do is to ch…

  adb2303

  4 replies

  13 years, 1 month ago

  By: Nicholas Cain

• troubleshoot--SP--TSQL optimized for 2000k

  I have a developer who has a SP which takes 10 ~ 24 hours which usually took minutes. This SP crea…

  Minnesota - Viking

  1 replies

  13 years, 1 month ago

  By: Grant Fritchey

• Return a value from a stored procedure

  Quick and probably easy answer for most of you. I want to created a stored procedure that simply is…

  TeraByteMe

  18 replies

  13 years, 1 month ago

  By: TeraByteMe

• Consective Days Absent

  Hello - I need some help in writing a SQL Query for students who are absent for consecutive days fo…

  aptlogix

  14 replies

  13 years, 1 month ago

  By: Evil Kraig F

• Trimming Data From A Record

  I need to trim values returned from rows in the following way (1) I need any characters leading up …

  xenophilia

  11 replies

  13 years, 1 month ago

  By: xenophilia