T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Getting Output value from sp_executesql for XML

  Hi All- I've been trying to solve this one for days with no avail. I'm using sp_executesql to run …

  Rogman

  3 replies

  14 years ago

  By: GSquared

• help with SQL query please

  I have table with below structure Create table ClientDetails (ID int, ClientID int, InterviewDate…

  Lucky9

  19 replies

  14 years ago

  By: vinu512

• sum operation

  Hi. i have a table ProductTrack.Table is like below: ProductTrackId PK ProductId int SizeI…

  sa.ordekci

  3 replies

  14 years ago

  By: Kingston Dhasian

• Getting the error - Transaction count mismatch

  How to fix this error ? Transaction count after EXECUTE indicates a mismatching number of BEGIN an…

  rockybhai

  2 replies

  14 years ago

  By: CapnHector

• Update sql database table by Datatable which I have made

  I have made a datatable. Now i want to update that datatable records in existing sql database table…

  hmsanghavi

  2 replies

  14 years ago

  By: hmsanghavi

• Link on DOT NET TECHNOLOGY

  We are following sqlservercentral for all the updates on sqlserver, can a similar kind of DOT NET l…

  pawan.boyina

  1 replies

  14 years ago

  By: vinu512

• Time out loading data into a Local Table Variable

  Hi, We have a stored procedure that has run fine for years. Last night it started to take an age t…

  giles.clapham

  1 replies

  14 years ago

  By: Cadavre

• Sql Update Query Perfomance Issue

  I making a string builder of thousands of update query. At last I execute those queries in chunks(s…

  hmsanghavi

  1 replies

  14 years ago

  By: Johan Bijnens

• UPDATE statement using SELECT

  I CREATED THE FOLLOWING TABLE. CREATE TABLE SCRAMBLE (FNAME VARCHAR(10), LNAME VARCHAR(10) ) INS…

  DBA_Learner

  8 replies

  14 years ago

  By: Jeff Moden

• divide column

  hello friends i have task teacheridtlnametfnameschoolidschoolname 2 john smith …

  surma.sql

  1 replies

  14 years ago

  By: ColdCoffee

• SQL Query to show previous and next date?

  I'm trying to figure out how to write a MS SQL query that will return the closest 2 events (the pre…

  dan-737342

  4 replies

  14 years ago

  By: ColdCoffee

• changing columns value to field names

  Hi , table A: Prop_name Prop_type STR_value Num value Date_value Bin_value Comment_1 D …

  komal145

  3 replies

  14 years ago

  By: Sean Lange

• String extraction

  Hi friends, From the given string I need to extract the right most value after the '/' example: giv…

  jahnavidutt

  2 replies

  14 years ago

  By: Lynn Pettis

• SQL Query help

  I have table with below structure Create table Employee (ID int, Division int, DateofBirth Dateti…

  Lucky9

  8 replies

  14 years ago

  By: Lucky9

• nth occurance of a alphabet

  Hi, I have a table like below and I want to find the max occurrence of alphabet 'A' in a col3 and m…

  NLV

  7 replies

  14 years ago

  By: GSquared