T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Barcode font 128b -SQL function

  Hi, I am looking for an SQL function that will generate the correct characters to make barcode font…

  Eliza

  20 replies

  10 years ago

  By: tonyoh888

• TSQL, Percentile with NTILE(100) for less then 100 obesrvations, how to display on 100 scale?

  Hi, all I have process and people want to know percentile rank (on scale of 100), I'm bit lost as I…

  mario17

  2 replies

  10 years ago

  By: mario17

• Merge statement

  I would like to have a 'counter' table which will hold the last used number and return a new number…

  _simon_

  12 replies

  10 years ago

  By: Kristen-173977

• Intermittant fault on script.

  Hi all, This is a bit of a bizarre problem and I'm not sure how to fix it.. I execute the followin…

  hb21l6

  4 replies

  10 years ago

  By: hb21l6

• Get date format in DB2 as expression in SSIS

  hi, I am working on a ssis package ,where I have date parameters as format below "2015-09-01-00.0…

  komal145

  1 replies

  10 years ago

  By: hb21l6

• Updating an existing table with max(value)+row number (partition by 2 columns)

  Hello Experts, I have 3 columns. I would like to update a table based on job_cd and permit_nbr colu…

  Naveen J V

  2 replies

  10 years ago

  By: David Burrows

• Escape Double Quote

  Good morning. I am trying to find all instances of a string that contain the letters FSC. While I a…

  mbrady5

  3 replies

  10 years ago

  By: AMIT GUPTA-263376

• List from 1 to @AnotherNumber

  I'm wondering if there is a better way to accomplish this task. @BoxesNeeded will change every tim…

  Skip

  3 replies

  10 years ago

  By: Eirikur Eiriksson

• Delete statement taking too much time..?

  Hi, Table Name: CSV_Details - Total records is 12138186 row(s), As below delete script taking more …

  SQL Galaxy

  13 replies

  10 years ago

  By: ChrisM@Work

• LOGSHIPPING WANT TO SYNC WITH SECONDARY DATABASE

  Hi, I want to configure the logshipping to secondary database. scenorio ===== Already the primary d…

  pradeep.k 50453

  1 replies

  10 years ago

  By: djj

• First Occurance of the string from text

  Hi All, I have text column .I want to find out first occurance of string based on logic.I defiend T…

  rsrvas

  15 replies

  10 years ago

  By: Luis Cazares

• Get blank ('') in datediff function

  drop table #temp CREATE TABLE #TEMP ( date1 DATE, date2 DATE ) insert into #TEMP values ('2011-06-1…

  Munabhai

  34 replies

  10 years ago

  By: sgmunson

• change name

  IS there a script I can change firstname lastname to lastname, firstname: for example John Smith, t…

  sqlfriend

  3 replies

  10 years ago

  By: Luis Cazares

• Possible pivot/CTE recursion restructuring of data

  Hello I have a table (folderstructure) with the following columns: pcmid, cmid, foldername pcmid is…

  DamianC

  2 replies

  10 years ago

  By: DamianC

• Only one record from table with multiple records

  Hi, I have a scenario where ID has three flags. For example ID flag1 flag2 flag3 1 0 1 …

  hegdesuchi

  5 replies

  10 years ago

  By: ChrisM@Work