T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to get current date between?

  Hi, I have a query that will go into an ssis package (eventually). The package will run every night…

  krypto69

  7 replies

  11 years, 1 months ago

  By: krypto69

• Replacing Table Names In Over 100 Procs

  I've been tasked with migrating half of a database to a new instance. Unfortunately for me, there a…

  joshdbguy

  8 replies

  11 years, 1 months ago

  By: mister.magoo

• Query Help - Update DateTime field with DateInserted from previous record

  Some assistance is needed. Hopefully, I can explain what I'm trying to do and someone can help me …

  Skip

  2 replies

  11 years, 1 months ago

  By: Skip

• Urgent! Need help on query!

  Hi all, there are two tables as below: Table 1 IDValue F001A,B,C F002B,C,D F003A,C Table 2 ID…

  pengyunkai

  4 replies

  11 years, 1 months ago

  By: pengyunkai

• If Else logic

  Hi, Sample data Declare @IsSalaryApproved bit = 0; declare @t table (Id int, CompanyID int,IsSalary…

  KGJ-Dev

  3 replies

  11 years, 1 months ago

  By: KGJ-Dev

• SQL

  Hello All, When I run the query below it works fine, but when I un-comment the listed fields I get …

  davidsalazar01

  6 replies

  11 years, 1 months ago

  By: davidsalazar01

• MIN across multiple columns with a GROUP BY

  Hi, How to get the lowest U.Price along with FX and Rate. ID-U.Price-FX-Rate 1280 19.1196 EUR 3.85 …

  kiran 4243

  4 replies

  11 years, 1 months ago

  By: serg-52

• query/script/stored procedure which will return a single table with three columns

  Hi I have multiple databases in the server and all my databases have tables: stdVersions, stdChange…

  Nomvula

  4 replies

  11 years, 2 months ago

  By: Lowell

• Inserting FK information into a temp table

  Hi, I need to insert FK information into a temp table using database name and table name as a param…

  Roust_m

  14 replies

  11 years, 2 months ago

  By: Jeff Moden

• Multiple Condition CASE Statement or Sub-Queries

  I have a temp table I want to delete records from if the enterDate >arcDate (today's date) joine…

  sclayton 889

  6 replies

  11 years, 2 months ago

  By: sclayton 889

• Rebuild Index Online last phase

  I'm running SQL Server 2008 R2 with latest patch. I'm performing all index maintenance online. Ca…

  rr_littletons

  2 replies

  11 years, 2 months ago

  By: Reginald-376782

• Split Function on the basis of Contact Number

  Hi, I need some help with a split function. i have records of multiple users, the last value of eve…

  Shafat Husain

  6 replies

  11 years, 2 months ago

  By: serg-52

• update/insert

  I have the following: iddue_dateupdate_datemonth 2004/14/20192/4/20142 2006/16/20204/6/2014…

  marybeth1975

  3 replies

  11 years, 2 months ago

  By: Jeff Moden

• Can any one help me to optimize this query? Thanks.

  Hello, I have inherited a lengthy query which I hope to optimize it, part of the query is posted he…

  sonchoix

  5 replies

  11 years, 2 months ago

  By: sonchoix

• Get closest int

  Hi, I’m trying to write a query that will select closest value to Amount field in #TestValue withou…

  legeboka

  2 replies

  11 years, 2 months ago

  By: ScottPletcher