T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Don't Want to Change Consecutive Records

  Using this table: --===== If the test table already exists, drop it IF OBJECT_ID('TempDB..#Job…

  ducksql@gmail.com

  4 replies

  13 years, 5 months ago

  By: ducksql@gmail.com

• Data Split and insert into another table

  Hello, I have a table which has leave data EmpCode, Leave_from, Leave_to, Status , addnl status. eg…

  durai nagarajan

  2 replies

  13 years, 5 months ago

  By: durai nagarajan

• Break On Group

  Hi Folks i am sure someone has already answered this one, but i cannot seem to find any info if my …

  JC-3113

  2 replies

  13 years, 5 months ago

  By: JC-3113

• Weird system view?

  when i search for something i accidentally i found this when i run this Query sp_helptext 'sys.obj…

  thava

  1 replies

  13 years, 5 months ago

  By: Gail Shaw

• Impact of Huge inserts

  hi, will the select become slow if huge number of records inserted through ETL? thanks, regards, ami

  Anamika

  7 replies

  13 years, 5 months ago

  By: Brigadur

• tsql - xml question

  it is possible make a query and the result will be: <?xml version="1.0" encoding="utf-8"?> &…

  xRafo

  6 replies

  13 years, 5 months ago

  By: LutzM

• Possible Loop Query

  I need to set up a process to query against multiple tables and then insert the data from these tab…

  8-Bit Ninja

  11 replies

  13 years, 5 months ago

  By: 8-Bit Ninja

• exclude certain entries but not all when something is found

  I have a sql query I run but I need to exclude some data from it and I'm having a hard time figurin…

  lawson2305

  9 replies

  13 years, 5 months ago

  By: ChrisM@home

• Temp Table Name confusion with Nested Procedures?

  Normally I ask this type of question on Ask SSC, but I thought I'd try one here for a change. I hav…

  mtillman-921105

  15 replies

  13 years, 5 months ago

  By: mtillman-921105

• execute string

  Hi All, I have a very interesting situation. I am pulling following string (see Coulmn1) using subs…

  kausmail

  6 replies

  13 years, 5 months ago

  By: Cadavre

• HELP Please - SQL CASE COUNT Query - Consolidation Techniques

  Hi Guys, I am scratching my head a little on this one - as I need to get a solution quite quickly, …

  SteveEClarke

  6 replies

  13 years, 5 months ago

  By: SteveEClarke

• Difference between Partition and index for table

  Hi, I want to know what is the difference between partitioned table and indexed table. indexing …

  vaithi.saran846

  6 replies

  13 years, 5 months ago

  By: Gail Shaw

• Modify the column data

  Hello All, I have a column in a table which holds the amount. Right now the data is like this 5000.…

  SQL Prog

  1 replies

  13 years, 5 months ago

  By: Steve Jones - SSC Editor

• insert multiple tables data into single table ????

  HI All, I want to insert multiple tables data into single table. EX: i have 3 tables ::table1 , …

  Lavanyasri

  3 replies

  13 years, 5 months ago

  By: John Mitchell-245523

• Calculating percentages

  Hello. Given this query on my DB SELECT CASE WHEN PreFragmentationPercent BETWEEN 0 AND 4 THEN '1…

  ken.trock

  4 replies

  13 years, 5 months ago

  By: Revenant