T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• trimming a text string

  How would you trim a string like below, and return only the second backslash and whatever follows? …

  polkadot

  44 replies

  14 years ago

  By: Kumara1011

• how to sum up the rows into one distict row per specific column

  I have a question - how to sum up the rows into one distict row per specific column: so, I have a q…

  BikeDude

  4 replies

  14 years ago

  By: BikeDude

• Naming a date range based on a Start and end date

  Hello All, Given a start and end date I am trying to determine if the range defined by these dates …

  Chrissy321

  3 replies

  14 years ago

  By: ScottPletcher

• Performance issue Help

  Hi, I am having hard time troubleshooting query performance. As soon the I run the following query …

  Sarwan

  14 replies

  14 years ago

  By: Sarwan

• Invoice

  Hey Guys, How can i unique invoice using Query ? Because invoice formate is kind of Weird. Format :…

  3935

  13 replies

  14 years ago

  By: 3935

• Performance Issue that cause High CPU utilization

  Hi Forumers, Im just running this script but it takes time to process. more than 39,000 records tha…

  Kaniguan_SQL

  6 replies

  14 years ago

  By: ChrisM@Work

• Data Delete issue

  hello friends, I’ve created this proc but when I run this it takes a lot of time and I need your he…

  sqlquest2575

  8 replies

  14 years ago

  By: ChrisM@Work

• select statement and output parameter

  Hi, I am using SQL Server 2008 R2 I hav this code DECLARE @Document INT INSERT INTO C_Documents…

  anush_tar

  12 replies

  14 years ago

  By: anush_tar

• How to use scalar valued function in select statement

  Hello, I wanted to know how to use scalar valued function in select statement. Right now I have a s…

  SQL Prog

  8 replies

  14 years ago

  By: SQL Prog

• Cursor in cursor problem with choosing database in cursor

  I am trying to build a script for dynamic rebuilding of indexes. Hefereo I am planning to use a cur…

  info 281

  4 replies

  14 years ago

  By: Leonard Rutkowski

• Like or IN or exists ??

  Hi I am trying to find a logic to do this. I have to create package in SSIS,for source I want use S…

  SSNEW

  3 replies

  14 years ago

  By: GSquared

• COALESCE

  I thought COALESCE had 2 parameters. http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=zfj…

  ReginaR1975

  12 replies

  14 years ago

  By: GSquared

• Identify and compare text between characters

  Experts, interested in cleaning interesting (bad) data ;-). I want to compare the text between 1st…

  Learning1

  10 replies

  14 years ago

  By: iBar

• select 12^21

  hi simple question, what does the ^ do in t-sql? it's eluding me on google thanks EDIT: aha, bitwis…

  darth_vodka

  2 replies

  14 years ago

  By: Kumara1011

• TVP Physical Order

  I have a sproc that accepts a tvp. The tvp is defined as a one column user defined table type. The …

  BSavoie

  7 replies

  14 years ago

  By: Gail Shaw