T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• beginner requesting help with trigger that updates a table when an insert occurs in another

  First, I read Jack Corbett's intro to triggers and am attempting to stick with set based sql. The p…

  xenophilia

  10 replies

  14 years, 5 months ago

  By: Lowell

• Formatted Text when select.

  I have a production database, in one table there is number of operations, this column contains '/' …

  ßhavin

  4 replies

  14 years, 5 months ago

  By: ßhavin

• Query same customer to determine datediff between two orders in same table

  Hi- I have a table that has every order placed. Something like this customer_id, order_code_id, or…

  paulgill

  8 replies

  14 years, 5 months ago

  By: paulgill

• Delete duplicate data from two tables where there is premary key reference

  I have tow tables 1.Contact(FirstName,MiddleName,LastName.ContactId) 2.Sales(ContactId,TotalDue) S…

  Smash125

  4 replies

  14 years, 5 months ago

  By: jcb

• Create foreign key script

  I can generate a forign key script in the management studio. For example: ALTER TABLE [Student] WI…

  sqlfriend

  3 replies

  14 years, 5 months ago

  By: Recurs1on

• I am trying to avoid cursors, what other option can I use?

  Hi, I need to update the records in table1 when these records exist in table2. I need to run the up…

  josetur12

  6 replies

  14 years, 5 months ago

  By: Evil Kraig F

• t-sql update(help me)

  tbl_indicator grp_nbr, sect_nbr, indicat 001234 100 p 002345 101 s tbl_group grp_id, grp_nbr, sect_…

  mtkr

  5 replies

  14 years, 5 months ago

  By: roryp 96873

• Point in time query against dimension

  I have several dimensions tables with the standard housekeeping columns of RowStartDate, RowEndDate…

  aaa121

  4 replies

  14 years, 5 months ago

  By: SQL Padawan

• Join - that may not be possible

  Hey all, Well we have all been there. A database design and data that is pooorly designed and no w…

  danielfountain

  12 replies

  14 years, 5 months ago

  By: Paul White

• Need Help to write Purge Job on Large table

  Hi Friends , i need help in writing Purge Script on One table Name Logins, Requirement is we need 9…

  madhuu1905

  1 replies

  14 years, 5 months ago

  By: Loundy

• Prioritizing Stored Procedures

  HI I there a way in SQL 2008 to prioritizing stored procedures, like DB2. Example, we have a sp th…

  Shaun Dayaram

  6 replies

  14 years, 5 months ago

  By: Grant Fritchey

• Unique key concept:Shubham Saxena@Bajaj Capital

  Dear Friends, help me find out null comparision logic for example: select case when null=null then …

  shubham.saxena67

  5 replies

  14 years, 5 months ago

  By: Paul White

• Help with DatePart or Dataadd view script?

  Hello - I'm tying to create a SQL View that will allow users to query the data in excel file. I ne…

  david.ostrander

  19 replies

  14 years, 5 months ago

  By: Loundy

• Create a Unique ID for Rows

  I have a table. It desn't have any Id which will be generated automatically. my table (Table1)has 3…

  neelubawa33

  6 replies

  14 years, 5 months ago

  By: Andre Guerreiro

• Help With Select Statement

  I have hopefully a fairly easy question which I think I am just missing something. We have a securi…

  jamie_collins

  4 replies

  14 years, 5 months ago

  By: Evil Kraig F