T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Split the values from ('1,2,3,4') to ('1','2','3','4') or (1,2,3,4)

  Hi, I need to pass comma separated values in my procedure but i have problem. Example: Declare @st…

  panneermca35

  10 replies

  14 years, 3 months ago

  By: ChrisM@home

• How to return 0 if not exists, or the result if exists?

  Hi all, Little problem I am facing. How to return a 0 value if there is no result, or the result it…

  boeledi

  4 replies

  14 years, 3 months ago

  By: ChrisM@home

• create ipaddress table

  Hi all, trying to learn a tsql dev stuff so decided to look at changing our ip document from a wor…

  Staggerlee

  8 replies

  14 years, 3 months ago

  By: sturner

• Trim a string

  Hello I have a select column with the format 'Physician->Scotland->Scotland North->NOS431 …

  kev43barrie

  9 replies

  14 years, 3 months ago

  By: GSquared

• Modulo operator problem

  I have a problem with modulo operator. I have records that meet the criteria x%2=0 but i dont get a…

  memymasta

  36 replies

  14 years, 3 months ago

  By: Cadavre

• Need Optimization the Query

  SELECT E.EmployeeID, …

  tamil.selvanmca

  2 replies

  14 years, 3 months ago

  By: Koen Verbeeck

• Conversion failed when converting from a character string to uniqueidentifier.

  Greetz! I'm trying to use a uniqueidentifier in a where clause and I've been unable to get past thi…

  MothInTheMachine

  3 replies

  14 years, 3 months ago

  By: Paul White

• Need help with Unpivot

  I have a sproc that counts the number of records where certain columns from matching records in 2 t…

  dndaughtery

  4 replies

  14 years, 3 months ago

  By: dndaughtery

• Intersecting records

  I need to find intersecting records from a table in the form of count., How many User Id count wher…

  WangcChiKaBastar

  11 replies

  14 years, 3 months ago

  By: WangcChiKaBastar

• insert and update-Trigger

  Hi, I would like to create a trigger for insert and update whenever change the table or a record is…

  info 58414

  3 replies

  14 years, 3 months ago

  By: Paul White

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

  By: corder

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

  splitter needed

  freecoder

  44 replies

  14 years, 3 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, 3 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, 3 months ago

  By: drew.allen