T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need hale parsing the following string example

  Hello, looking for t-sql that would be able to parse the following strings and convert them to just…

  oradbguru

  7 replies

  14 years ago

  By: oradbguru

• Try Catch error

  Could someone explain to me why this try catch still returns an error if the job is not running? I…

  GregoryF

  1 replies

  14 years ago

  By: HowardW

• Query to return 1 or unique value

  Hello, I am using SQL 2k8 R2. My colleague would like query that will return unique value if all th…

  Hardy21

  5 replies

  14 years ago

  By: Cadavre

• Extract related values recursively

  I have a table like this : salesinvoiceidsalesreceiptid aA1 aB1 bB1 bC1 cC1 dD1 At any point…

  sridhar_kola

  6 replies

  14 years ago

  By: Dwain Camps

• is nvarchar(2000) is big or BIGINT is big in size

  Hi Experts, I have a column of nvarchar type. is it good to create index on this. …

  chaithu559

  3 replies

  14 years ago

  By: Gail Shaw

• Insert into two different tables

  Hi, i have two tables and i want to insert data in these two table with one click IF OBJECT_ID('Te…

  MuhammadShafiq

  9 replies

  14 years ago

  By: MuhammadShafiq

• Bulk Insert/BCP .xml file containing Chinese characters

  Hello specialists. I am attempting to load an xml file that contains Chinese/Russian characters int…

  david.tyler

  1 replies

  14 years ago

  By: Jesse Reich

• Need to come up with Matrix Based on Columns and Rows

  Post removed. For better, quicker answers on T-SQL questions, click on the following... http://www.…

  Welsh Corgi

  3 replies

  14 years ago

  By: Lynn Pettis

• Help with getting top 5 forum posts

  Hi all, I have the following table called Forum_Posts: PostID (pk) Subject Body CreatedDate ThreadI…

  Mark Eckeard

  9 replies

  14 years ago

  By: Mark Eckeard

• Error: Reference to an undefined name while creating xml schema

  trying to design a schema for a project where we will be exchanging data with another organization.…

  jwmott

  2 replies

  14 years ago

  By: jwmott

• Procedure with dynamic SQL

  I have below table: CREATE TABLE [dbo].[test_table]( [NAME] [varchar](255) NOT NULL, [SERVICE] [v…

  nehaCS

  4 replies

  14 years ago

  By: Lynn Pettis

• T-SQL help with parameters

  I have 4 temp tables and the final result I need to retrieve is ONLY ID column results as 1 and 6. …

  etirem

  8 replies

  14 years ago

  By: David Webb-CDS

• Comparing the dates on multiple rows

  Lets say I have 5 records with a sell date. I want to show a count of all the records with a sell …

  tmitchelar

  4 replies

  14 years ago

  By: tmitchelar

• Insert Statement inside Function

  Yes I know that's not possible for very good reason. Now let's explain to you my issue. I have a in…

  DZN61

  9 replies

  14 years ago

  By: ChrisM@Work

• Doing inserts within a select statement?

  Hello, Im selecting values from a table a: SELECT a.col1, a.col2, a.col3, a.foreignkey-value FROM m…

  erikpoker

  18 replies

  14 years ago

  By: DZN61