T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Help with Query

  I have a tracking DB filled with various data (id#, description, cost, Vdoc#, Idoc# and Cdoc#) All …

  aj_jm964

  10 replies

  15 years, 2 months ago

  By: Lynn Pettis

• Help with seemingly simple query

  Hi guys, I'm having a lot of trouble with this query so thought I would get some help here. I have …

  elogen

  4 replies

  15 years, 2 months ago

  By: Sachin Nandanwar

• Break Date Into Date Range

  I have a table that lists "Holidays": DECLARE @Holiday TABLE (HolidayId int identity(1,1) primary …

  BSavoie

  3 replies

  15 years, 2 months ago

  By: BSavoie

• There is insufficient system memory in resource pool 'internal' to run this query.

  Hello I get the above error while executing an .sql file that contains about 30mb of simple inserts…

  Dinculescu Mihai

  6 replies

  15 years, 2 months ago

  By: Koen Verbeeck

• Proc Performance

  I have a proc that has this Create proc myproc @param1 int = null, @param2 varchar = null, @param3 …

  Khades

  14 replies

  15 years, 2 months ago

  By: Jeff Moden

• Select column values as comma seperated format

  Hello, I need code that will select a single column from a table and put in into a variable in comm…

  David Kranes

  5 replies

  15 years, 2 months ago

  By: Jeff Moden

• Create stored procedure for parsing Comma Delimited string.

  Hello, I currently have a stored procedure written for Oracle that I need to port to SQL Server. B…

  David Kranes

  4 replies

  15 years, 2 months ago

  By: David Kranes

• Update with Row Lock -How to Optimize this

  I have a set of update statements with explicit row lock mentioned. On investigating I see that thi…

  facticatech

  6 replies

  15 years, 2 months ago

  By: dant12

• multiple join conditions and OR

  This is a theoretical question. I frequently use multiple join conditions separated by AND. Recentl…

  goofbauer

  4 replies

  15 years, 2 months ago

  By: goofbauer

• Issues with OpenXML under heavy load

  We uee BizTalk to call a stored procedure and insert records into a table. One of the parameters i…

  Mike01

  4 replies

  15 years, 2 months ago

  By: tertiusdp

• Future Forecast for performance

  Hello friends, How can we estimate how much time a particular sproc is supposed to take if the tabl…

  sql_butterfly

  9 replies

  15 years, 2 months ago

  By: TheSQLGuru

• Bulk Insert on SQL Server 2008 R2

  Hi , I recently came across with bulk insert , i need your help to resolve them. i have the followi…

  subbu_e

  7 replies

  15 years, 2 months ago

  By: subbu_e

• substring funcation.

  i'm doing a little string parsing. Does anyone else find it odd that when using the substring funct…

  BaldingLoopMan

  14 replies

  15 years, 2 months ago

  By: Jeff Moden

• Problems with BCP

  Hi guys I have a problem with bcp because I am trying to import a csv file, however one row has no …

  ulisseslourenco

  1 replies

  15 years, 2 months ago

  By: george sibbald

• is a charindex(val1,val2) > 0 or a '%' + val1 + '%' = val2 better/faster?

  I have some data like 'location1' as label ,'a lot test here like PC,87,89,25,38;35,87,13,D6 etc' …

  dandenson

  2 replies

  15 years, 2 months ago

  By: dandenson