T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• How to do Recursive program to find Drilldown data

  I have to find all breakdowns (Drilldown) in my number sequence . Numbers are like 1 1.1 1.2 2 2.1 …

  sampathsoft

  2 replies

  14 years, 11 months ago

  By: Jeff Moden

• Give me simple example for Pivot and is applicable for text data?

  give me some example

  ramya.praba

  2 replies

  14 years, 11 months ago

  By: VSSGeorge

• Display column of different rows as column of a single row

  Hi All, I have a table with the columns empname,dateofbirth,group.An employee can be in different…

  sriram-435614

  25 replies

  14 years, 11 months ago

  By: LutzM

• update

  How can i update all records in a column by prefixing with letter "ASP". For example i have employe…

  Tara-1044200

  13 replies

  14 years, 11 months ago

  By: Jeff Moden

• Binary data field - COnvert

  I have a binary(8) field that I am trying to get data out of. The field value is 0x746F680000000000…

  David Stubler

  1 replies

  14 years, 11 months ago

  By: Evil Kraig F

• Subquery returned more than 1 value in a Set Statement

  I know I should be able to figure this out, but I am drawing a complete blank. Can someone help me …

  ducksql@gmail.com

  13 replies

  14 years, 11 months ago

  By: ducksql@gmail.com

• unique records based on one column

  I have a query that pulls parent login info and insert into another table. I want to select unique …

  sqlfriend

  3 replies

  14 years, 11 months ago

  By: sqlfriend

• Foreign key problem

  Hi, I created 2 tables part_sample and order_part and used foreign key constraint with default valu…

  sqlpassion

  1 replies

  14 years, 11 months ago

  By: ChazMan

• Multiple "x rows affected" after query has executed

  Hi All, When i execute a simple update statement, updating null values to be 0 (zero) in a single c…

  DBANewbie

  3 replies

  14 years, 11 months ago

  By: WayneS

• How to break string and insert each substring

  Hi All, I am using Sql server 2005. My table is like Empcode Date em001 2,3,7 em002 …

  imran-399399

  9 replies

  14 years, 11 months ago

  By: Jeff Moden

• Data Trimming Issue

  Hello, In my sql 2005 table's column, values for one column is in this form 350315357. I need to di…

  dallas13

  4 replies

  14 years, 11 months ago

  By: Wildcat

• Recursive Deletion using Triggers

  Hi, I am having 2 tables namely Table1 and Table 2 Table 1 ID PK Name Desc Table2 ChildID -&g…

  richu.thomas

  4 replies

  14 years, 11 months ago

  By: tfifield

• Get count for each row

  Hi, If given a table comprising of two columns, [ID] and [Value] for example, how do I for each row…

  landingnormand

  3 replies

  14 years, 11 months ago

  By: andrewd.smith

• insert error with computed column index

  Hi Guys, I have a computed column index on this table, and I'm getting a SET error on an insert. An…

  BenWard

  7 replies

  14 years, 11 months ago

  By: BenWard

• Grouping problem

  I can't even work out how to describe what I'm trying to do, so googling isn't going too well! My s…

  Tim Hobbs

  18 replies

  14 years, 11 months ago

  By: Jeff Moden