T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need TSQL Suggestions to Optimize this Query....

  Hi, I have a query I need to optimize. I already added a bunch of relevant indexes, and reduced i…

  sql_jr

  12 replies

  14 years, 6 months ago

  By: Grant Fritchey

• I want to truncate table before inserts data

  Hello, I have remote server and local server I have linked remote server I normally inserts data f…

  asif mustak bhura

  2 replies

  14 years, 6 months ago

  By: corder

• need sql query to convert a column of a table into meaningful data

  splitter needed

  freecoder

  44 replies

  14 years, 6 months ago

  By: freecoder

• How do I add a decimal to a number

  Hi All, How do i add a decimal? I have a value 123456 and i have to display it as 1234.56. Please H…

  kevin4u06

  6 replies

  14 years, 6 months ago

  By: kinggion79

• Query syntax - Is a single query possible

  I have two tables an Item Master table and an Item Transaction table (IMItmIdx_SQL and IMInvTrx_SQl…

  mpdillon

  7 replies

  14 years, 6 months ago

  By: drew.allen

• Problem with performance of Geospatial Query

  I'm having an issue with the performance of what must be one of the most text-book uses of the Geos…

  HowardW

  14 replies

  14 years, 6 months ago

  By: HowardW

• C# code calls sp which calls another sp

  Gang, I'm writing some C# code to extract FILESTREAM data back out of the datastore and I am encoun…

  Larry Kruse

  5 replies

  14 years, 6 months ago

  By: sturner

• Return SQL Server service user in T-SQL

  Hi all Is it possible to get the name of the user running the 'current' SQL Server instance in T-SQ…

  Phil Parkin

  6 replies

  14 years, 6 months ago

  By: Phil Parkin

• Trigger to insert records on a linked server else in a local server

  Hi, 1. There is a plan to write a trigger on a table in Server1 which inserts records on a table in…

  kbsk333000

  21 replies

  14 years, 6 months ago

  By: Johan Bijnens

• Transfer logins

  Hi all Something that is confusing is the transfer of logins. I understand Microsoft have provided…

  Kwisatz78

  1 replies

  14 years, 6 months ago

  By: okbangas

• Convert Time Stamp in Query

  I'm trying to query a databse that stores records with date/time stamp format - I need to return re…

  Bron Tamulis

  5 replies

  14 years, 6 months ago

  By: Jeff Moden

• Date Range Parameters

  I have three columns TransID, PubstartDate and PubEndDate in a table.. I need SQL to determine Tran…

  varunkum

  11 replies

  14 years, 7 months ago

  By: drew.allen

• Finding "sort of" duplicate records - multiple column aggregate??.. HELP

  I have a table full of customer transactions. I need to dump "possible" duplicates into a differen…

  stephenmbell

  5 replies

  14 years, 7 months ago

  By: drew.allen

• TABLOCKX differences (involving MERGE)

  How are these two statements different with regard to locking the table: -- Variation 1 BEGIN TRAN…

  mgoldshteyn

  4 replies

  14 years, 7 months ago

  By: mgoldshteyn

• Putting a condition on a subgroup to query result

  Hi, I have a organization table below which shows the relationship between a parent and child relat…

  yingchai

  22 replies

  14 years, 7 months ago

  By: JonFox