T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 months ago

  By: Evil Kraig F

• Exotic join

  I am trying to analyze the behavior of joins with theta operators. I have created two tables with s…

  chowdarysurendranath.c

  2 replies

  14 years, 2 months ago

  By: jcb

• Guidance on returning result set for previous month

  I have a report subscription that returns the previous month's referrals for attorneys. I have most…

  Paul Morris-1011726

  8 replies

  14 years, 2 months ago

  By: Cadavre

• Little Help With Select Statement.

  Hello Everyone, I am having a little trouble with a select statement, I am trying to make a list of…

  Duran

  10 replies

  14 years, 2 months ago

  By: GSquared

• Help with Case in where clause

  Can someone help me to get this query to work? DECLARE @option bit ,@begindate datetime ,@enddate d…

  atl21002

  4 replies

  14 years, 2 months ago

  By: happycat59

• table variables in function slower in 2008

  i have a function that returns a table that executes in 40 secs. in 2000. I created the fucntion i…

  rgretz

  4 replies

  14 years, 2 months ago

  By: andrew gothard