T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• how to use dates in case statement..........

  this qry displaying the result of total two months in july column what is wrong in that. I need ind…

  dastagiri16

  3 replies

  13 years, 8 months ago

  By: nigel.

• Favorites In Asp.Net using C#

  Hi all, i want to implement Favorites functionality in my web site.how it is possible? i want to ha…

  MuhammadShafiq

  1 replies

  13 years, 8 months ago

  By: Ninja's_RGR'us

• Stored proceedure and cursor

  i want to search the no of characters in a field and to show the record having more characters matc…

  MuhammadShafiq

  17 replies

  13 years, 8 months ago

  By: MuhammadShafiq

• xml help

  I don't know whether it's the best way to do it or not, but i am using sp_makewebtask to export a f…

  Crystal Hammersley

  2 replies

  13 years, 8 months ago

  By: fondoflife

• Looking for help taking the RBAR from this problem

  Hello all, I'm working on a system that collects data from various configuration and statistics ser…

  clubbavich

  34 replies

  13 years, 8 months ago

  By: Jeff Moden

• how much $$$ saved !!!

  Hi All, I have fine tuned a stored procedure recently. The problematic area is I/O cost (not the ex…

  karthik M

  5 replies

  13 years, 8 months ago

  By: Ninja's_RGR'us

• MAx no of parameters in storedprocedure ??

  HI All , How many no of parameters[max no ] we can declare in sql serevr 2005 ?? Thanks

  Lavanyasri

  6 replies

  13 years, 8 months ago

  By: Lavanyasri

• Am I missing something here?

  Hi, I'm trying to research some performance issues that came up when we went to Win 7. I decided,…

  miapjp

  5 replies

  13 years, 8 months ago

  By: GSquared

• Row versioning

  Hi All, Does row versioning works on only UPDATE and no DELETE? Can anyone explain why only UPDATE …

  Oracle_91

  5 replies

  13 years, 9 months ago

  By: Oracle_91

• Retrieving a specific column as comma separated values

  I have two tables, EmployeeDetails EmployeeIDNameDepartmentManager 7James BondKicking b…

  Kaptnik

  2 replies

  13 years, 9 months ago

  By: Kaptnik

• Select history of records

  Hi All, Please find the below CREATE TABLE answers(question varchar(20), Answer Varchar(20),answere…

  Deepthy

  7 replies

  13 years, 9 months ago

  By: ChrisM@Work

• Sp within an sp help performance question?

  Hello, I am working in sql 2005. I have an sp (proc 0) that calls the sp below (proc 1) to find a s…

  ca-dev

  2 replies

  13 years, 9 months ago

  By: Grant Fritchey

• RE: Error Message when using Date Functions

  Hi, Could anybody please help me fix the error message? DtTemp is a smalldatetime variable. case …

  umas

  2 replies

  13 years, 9 months ago

  By: umas

• split a column and update a new column with part of the split data...

  I have a table with the following fields: RecordNum as int strDomainName as varchar(255) strShortNa…

  stupid48

  5 replies

  13 years, 9 months ago

  By: stupid48

• Nested Procedures with Paramters

  I am using SQL Server 2008 R2. I have created 3 stored procedures. Proc1 calls Proc2 which calls …

  jack.helfrich

  7 replies

  13 years, 9 months ago

  By: Sean Lange