T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• need query help - need to get prior rolling 6 months from today's date

  This is starting to drive me to drink!! I have my date field in my table as [201206], I'm able to g…

  SQL_NuB

  2 replies

  13 years, 10 months ago

  By: SQL_NuB

• You do not have permission to use the bulk load statement

  Hi, I've got 2 users, an administrator and Bob. Both are SysAdmin When I'm logged in as administrat…

  giles.clapham

  6 replies

  13 years, 10 months ago

  By: chrisfradenburg

• CSV splitted in ROW'S

  HI ; How to split the csv values in rows , this is my sample string UNIPAR LLC , IAE Power Product…

  sqlfriends@sql.com

  4 replies

  13 years, 10 months ago

  By: Jeff Moden

• Search for TExt of Stored Procedure - Replacement for syscomments

  What would the SQL Server 2005 and above eqivilent command for the following? SELECT * FROM syscom…

  Welsh Corgi

  11 replies

  13 years, 10 months ago

  By: WILLIAM MITCHELL

• whether commited transaction will get rollback again

  hi waiting for the reply thanks kumar

  Kumara1011

  12 replies

  13 years, 10 months ago

  By: Gail Shaw

• trimming a text string

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

  polkadot

  44 replies

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months ago

  By: Sarwan

• Invoice

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

  3935

  13 replies

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months ago

  By: Leonard Rutkowski