T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• INSERT INTO SELECT WITH ORDER BY

  I have a question 🙁 IF i insert into a table with identity column. EX DECLARE @AAAATABLE TABLE( K …

  nguyennd

  39 replies

  15 years, 12 months ago

  By: Paul White

• Select statement with Group BY

  Hi, if we are trying to add the several columns in select statement and only one condition in group…

  Vinay Theethira

  5 replies

  15 years, 12 months ago

  By: Paul White

• data points

  Hi, I've performed some joins on tables and also performed some ETL tasks to get data from one serv…

  tripri

  1 replies

  15 years, 12 months ago

  By: Jeff Moden

• help using 'like' condtions

  Hi , I would like to join two tables A and B. Table A has a column Drug and table B has column drug…

  dheer

  3 replies

  15 years, 12 months ago

  By: WayneS

• Help needed

  please help me below is the source table new proj id old proj id 1084d 1084/ 1084e 1084a 1084f 108…

  rahulsony111

  5 replies

  15 years, 12 months ago

  By: rahulsony111

• XACT_ABORT and RAISERROR relationship

  One of our developers feels that invoking RAISERROR in a stored proc where XACT_ABORT is on should …

  Barkingdog

  2 replies

  15 years, 12 months ago

  By: Barkingdog

• Query Help

  HI, I need help writing a query. Where in a table ABC.... there is code column codes (ab, bc, cd, d…

  ssc_san

  3 replies

  16 years ago

  By: falgunoza

• Looking for best practices for ensuring a unique value on the many side of a a one-to-many relationship

  Let's say I have two tables - a Persons table and an Addresses table. One person can have zero to m…

  Charles Cherry

  7 replies

  16 years ago

  By: Eugene Elutin

• How can I use union and for xml in one sql statement?

  This is a sample of a stored procedure I have: (select users.fullname + ', ' as [text()] from users…

  brett 4501

  4 replies

  16 years ago

  By: R Michael

• Problem in Stored Procedure

  Hello ! Guys Here is a SP that I have constructed . USE IRISDW_B4_FEEDRUN IF OBJECT_ID('Pr…

  Shintu

  1 replies

  16 years ago

  By: ChrisM@Work

• time taken to perform etl process

  Hi, I got a database of 20gb . Now i want to perform ETL process on that database so as to copy tha…

  tripri

  4 replies

  16 years ago

  By: Greg Edwards-268690

• Updating Stored Procedure

  Hello ! Guys here I have a SP which is performing well, but I need to modify something in it. I …

  Shintu

  3 replies

  16 years ago

  By: Shintu

• Help with a weird query

  Hi everyone, Today I came across with a kinda tricky query. I was asked to retrieve codes that are …

  chileu17

  12 replies

  16 years ago

  By: chileu17

• msdb.dbo.Sp_send_dbmail issues related to the width of the email

  I have the @query_result_width = 32761. It appears in the email as it appears below. Is there a way…

  BaldingLoopMan

  1 replies

  16 years ago

  By: Eralper

• How to capture changes?

  Hi, For example, I have a table like this: IDvalue 15 25 37 47 57 67 79 89 95 1…

  pcgm

  15 replies

  16 years ago

  By: pcgm