T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Pivot Table with multiple columns

  I current have a query like this... select * from ( select case sacoy when 100…

  Suth

  6 replies

  10 years ago

  By: spaghettidba

• Must Not Exist Constraint

  This is a single table problem with two columns and 5 data integrity rules. 1.) The First Column is…

  svanduffelen 83303

  9 replies

  10 years ago

  By: svanduffelen 83303

• Problems inserting file into database table

  Hi, I've tried all sorts of variants on the OPENROWSET theme to import a file (not file contents, t…

  emily 38901

  2 replies

  10 years ago

  By: emily 38901

• language translation in SQL Server 2008 R2

  Hi All, I am looking to help on Language translation option in SQL Server 2008 R2 Here is my requ…

  gracebite1981

  1 replies

  10 years ago

  By: Eirikur Eiriksson

• replace a Date A with Date B if Date A is null

  Is it possible to replace a Date Value if null with another date in a table? Example : DATEPART(mm,…

  dumbuyab

  1 replies

  10 years ago

  By: Lowell

• Find out the SQL Server restart date/time with TSQL

  Hi, I am just wondering if there is way to figure out when SQL Server was last restarted using TSQ…

  Roust_m

  6 replies

  10 years ago

  By: johnnyagsalog

• Distinct with a MAX()?

  I have a table that holds Folders and the documents with a version number. What I am trying to do …

  ldummer

  4 replies

  10 years ago

  By: Sean Lange

• Transpose Rows to columns

  Hollo, I am in need of some coding help..... I'm trying to transpose rows to columns at the same ti…

  ajspencer

  4 replies

  10 years ago

  By: Alan Burstein

• Querying Active directory

  Hi Since they have change AD structure i'm getting trouble to make my query work as i wanted. Below…

  asene

  15 replies

  10 years ago

  By: asene

• T-SQL Coding - How do you code error handling logic in your SQL Server stored procedures?

  T-SQL Coding - How do you code error handling logic in your SQL Server stored procedures?

  Arjun SreeVastsva

  6 replies

  10 years ago

  By: Dwain Camps

• Update JOIN Question

  Hi all, I have the following 2 tables, paydataimport and pprwages: CREATE TABLE [dbo].[PayDataImpor…

  pop

  20 replies

  10 years ago

  By: Jeffery Williams

• Select Max Date, Sub Query on 2nd Tier Join

  It would be appreciated if anyone could assist with the following select problem I am trying to sol…

  L30

  6 replies

  10 years ago

  By: L30

• Query help

  I have a query: SELECT TOP (100) PERCENT gp.OrganisationCode, gp.Name, gp.Address1, gp.Address2…

  ayh1

  3 replies

  10 years ago

  By: ayh1

• Get Surrounding text in a string?

  I need a function or MSSQL query that returns the surrounding text in a string. So, let's say I hav…

  markpringle

  9 replies

  10 years ago

  By: Jeff Moden

• Locking and blocking - WITH (READPAST) Does not work as expected

  Hello I am trying to insert records into a fairly large table (>25Mil records). The table contai…

  RobinC-661862

  13 replies

  10 years, 1 month ago

  By: Henry B. Stinson