T-SQL

• Topics

  Started by

  Posts

  Last post

• Stored Procedure that uses a parameter in a WHERE x IN(@param1)

  PLEASE tell me what needs to be done to make something like this work? DECLARE @PARAM1 VARCHAR(2000…

  Budd

  16 replies

  9 years, 6 months ago

  By: Eirikur Eiriksson

• Splitting Records

  Hi all i have the following question. Can i split a recordset with one id and one field in 3 fields…

  DimitrisAgelidis

  8 replies

  9 years, 7 months ago

  By: Ed Wagner

• stored procedure running slower than sql query

  Hi I have one stored procedure and its taking 10 mins to execute. My stored procedure has 7 input p…

  sahana

  17 replies

  9 years, 7 months ago

  By: kvishu83

• create a table on a 2nd SQL server via linked server

  I guess the title explains everything, but I was wondering if anyone had a method of my being able …

  Mike Metcalf

  7 replies

  9 years, 8 months ago

  By: Lowell

• Any way to clean up mutually exclusive OR conditions?

  I have a where clause with some mutually exclusive OR expressions. With a procedural language that …

  xr280xr

  16 replies

  9 years, 8 months ago

  By: drew.allen

• create single quotes around @variable

  Hello, I have a problem to create a variable. The variable must be enclosed by single quotes. In th…

  p.verkley

  12 replies

  9 years, 8 months ago

  By: MMartin1

• scriptdb - useful for getting db into source control

  Just a quick note to let you all know about a (free) app I wrote that will script all the objects a…

  jezemine

  5 replies

  9 years, 10 months ago

  By: web2doormarket

• One more SQL puzzle

  Take 2 tables Table1 id Name 1 AAA 2 AAA 3 AAA Table2 id Name null BBB…

  Sandeep-248595

  10 replies

  9 years, 11 months ago

  By: Jeff Moden

• function for highest value across columns

  Hi, I have a table with 4 integer columns and need to know whether there is a function that will re…

  EamonSQL

  6 replies

  9 years, 11 months ago

  By: Sergiy

• SET NOCOUNT ON isn't working

  I have two different SQL Server 2000 servers. Both are running the same version of SQL Server. I ha…

  SQLBill

  10 replies

  9 years, 11 months ago

  By: Sergiy

• SQL: How to combines two results into one after case statement

  Hi Experts, Can someone help me out? When I run the query , I am getting the duplicate of subtotal …

  Newbi

  2 replies

  9 years, 11 months ago

  By: Umer Akram

• Error 8601

  Greetings, One of my customers is getting an error which states: 'Internal Query Processor Error: T…

  sbendayan

  4 replies

  9 years, 11 months ago

  By: VastSQL

• Need help on query performance

  I have a stored procedure that is running fine but I would like to improve the query speed. a.repor…

  jc85

  76 replies

  9 years, 12 months ago

  By: Sergiy

• No Result on the Query

  Hi, I have been working on a query and failed to get it working after a full day. I am not sure whe…

  gazy007

  3 replies

  10 years ago

  By: Phil Parkin

• How to Reduce the Logical Reads, to imporve the Performance of the Query

  Hi, I heard abt the Logical/ Physical Reads In Sql Server. Could any one please explain me What are…

  santoooo

  12 replies

  10 years ago

  By: ferrari_martin