T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Self Join

  Hi all In the Employee Table, (EMPNo,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) Example DAta EMPNO…

  farooq.hbs

  6 replies

  14 years, 1 months ago

  By: thinesh.mscss

• Updating a field twice in one statement

  Hi, I'm having to write an anonymisation script for our production DB's so we can bring them into t…

  s_osborne2

  2 replies

  14 years, 1 months ago

  By: s_osborne2

• Need help with my date logic function

  Hello All, I need help with a function. I give my report users the options below so that my functi…

  Chrissy321

  6 replies

  14 years, 1 months ago

  By: Chrissy321

• Trigger with db_send_mail and try catch

  So I have an after trigger that sends an email. I want the insert to happen whether the trigger wo…

  pamozer

  13 replies

  14 years, 1 months ago

  By: Orlando Colamatteo

• Why cant I reference a column in a SQL Cursor?

  Greetings... I am NO SQL expert - good at writing very simple queries - but now I have to do someth…

  blandry

  77 replies

  14 years, 1 months ago

  By: blandry

• NEED HELP USING OPENXML IN T-SQL PLEASE HELP!!!

  Here is an code example of my problem.... My question is How do I get the scores? ie: 50, 300, 71…

  greg.perry

  2 replies

  14 years, 1 months ago

  By: greg.perry

• Duplicate delete using Common Table Expressions

  CREATE TABLE Test ( ContactID INT, SalesOrderID INT, OrderYear DATETIME ) insert into Test(ContactI…

  Smash125

  6 replies

  14 years, 1 months ago

  By: vinu512

• Remove successive rows with same column value

  Hello everyone, I'm a beginner in SQL and i have difficulty to find solution for the folowing probl…

  Med Anwar

  22 replies

  14 years, 1 months ago

  By: Med Anwar

• Write all the records of a table to a text file on the local disk with in T-SQL (SP)

  We ant to Write all the records of a table to a text file on the local disk with in T-SQL. We do no…

  Joe-420121

  16 replies

  14 years, 1 months ago

  By: Joe-420121

• how to separate value columns my matching two flag

  Hi SQL Gurus, I have a requirement here to transform the table and need your advise on this. Below …

  yingchai

  7 replies

  14 years, 1 months ago

  By: yingchai

• RS with two date columns from a single date column

  [not sure that Subject made sense but I couldn't think of a good description for this] I have the f…

  Brian Ki

  9 replies

  14 years, 1 months ago

  By: Jeff Moden

• retrieve only month and year (last two digits) part of datetime field

  I found this statement on line for retrieving only MON-YYYY portion of datetime field. SELECT CO…

  polkadot

  26 replies

  14 years, 1 months ago

  By: polkadot

• Run query it takes 16 seconds run stored procedure never finishes

  I have a stored procedure that never finishes. I run the query inside the stored procedure and it …

  pamozer

  14 replies

  14 years, 1 months ago

  By: pamozer

• BCP cmds BUILDING up in cursor

  I have a cursor which with each loop selects a BLOB and outputs it to a file using EXEC master..xp_…

  Edward-445599

  1 replies

  14 years, 1 months ago

  By: CapnHector

• Count aggregate rows

  Can someone help me figure out the logic on how to deliver the count after I aggregated the rows? F…

  bostonjoey

  5 replies

  14 years, 1 months ago

  By: CapnHector