T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• SQL Server Log file and Data file available free space in percentage

  Hi Team, kindly move my Question to SQL Server Forum, as i couldnt find it in the list. Hello Exper…

  vinod.mallolu

  8 replies

  8 years, 7 months ago

  By: Henrico Bekker

• Help to understand logic

  Hi all, Please help me to understand the logic written in the ORDER BY clause of the SQL query belo…

  VSSGeorge

  3 replies

  8 years, 7 months ago

  By: sgmunson

• Formula/T-SQL to convert number to time

  Hello, This actually may be more of a math problem than anything else.... apologies if inappropriat…

  scarr030

  8 replies

  8 years, 7 months ago

  By: ScottPletcher

• Convert decimal to percentage and percentage to decimal

  How to convert these value from VARCHAR to decimal  and remove percentage sign.DECLARE @b-2 V…

  kk_tech

  1 replies

  8 years, 7 months ago

  By: Thom A

• List repeated values only once

  I have the following dataset.  DECLARE @T2 TABLE( ID INT IDENTITY(1,1) ,Col1 CHAR(1…

  MK Morris

  4 replies

  8 years, 7 months ago

  By: sgmunson

• procedure execution aborts on error when called by job?

  hello there,I'd like to clear a situation that is driving me little bit crazy....Immagine a procedu…

  WolfgangE

  3 replies

  8 years, 7 months ago

  By: Eric M Russell

• How to declare and pass a variable inside the SQL String when using Stored Procedure.

  SP variable should be available inside the @Query String. See comment section. SP works but doesn't…

  kk_tech

  8 replies

  8 years, 7 months ago

  By: kk_tech

• Identifying all the values in a column that can be cast as numeric(3,1) in SQL Server 2008R2

  Hi All I don't have control over the SQL Server version I'm using to resolve this problem (so …

  GPO

  4 replies

  8 years, 7 months ago

  By: GPO

• Exists Condtion

  hi, Below the sample to play with Declare @test table(id int, VendorID int, CompanyId int);insert i…

  KGJ-Dev

  2 replies

  8 years, 7 months ago

  By: KGJ-Dev

• Help on query based on condition

  Hello friends hopefully you can assist meIn my query, I need to frame a condition likeCount of acti…

  VSSGeorge

  12 replies

  8 years, 7 months ago

  By: VSSGeorge

• Select case Logic

  Hi, Below are the sample to play with. Assume always there will be 2 rows in the temp variable. DEC…

  KGJ-Dev

  5 replies

  8 years, 7 months ago

  By: KGJ-Dev

• How to reterive user defined Table type (Table value parmeter) in query analyser

  Hi i have create one table in sql2008 Below one is my sample one CREATE TYPE [dbo].[GetPrograms…

  KMPSSS

  4 replies

  8 years, 7 months ago

  By: x

• Help using CASE statements

  Hi, I'm looking for some help with a query I'm writing (please bare with me, am an absolute beginne…

  danblank000

  5 replies

  8 years, 7 months ago

  By: John Mitchell-245523

• T-Sql Scripting Help!

  Hi all, I’m having a little trouble with coming up with a good way to amend an audit table (see en…

  Daniel.Bayliss

  2 replies

  8 years, 7 months ago

  By: Daniel.Bayliss

• Any way to assign a lower priority to a query / view?

  Hi all, I'd like to create a set of views which users will connect to through Excel (using the From…

  kramaswamy

  5 replies

  8 years, 7 months ago

  By: Grant Fritchey