T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Multiple Inserts Using SCOPE_IDENTITY() from the first insert

  I have a procedure where I do an insert by selecting data from a #temp table, i need one of the val…

  krushkoder

  8 replies

  14 years, 10 months ago

  By: krushkoder

• Case when statement

  How can I accomplish this? select case when Datename(dw,getdate()) = 'Sunday' then set @date…

  ramadesai108

  2 replies

  14 years, 10 months ago

  By: ramadesai108

• Pivot or Unpivot, or both

  Hello all; I have given the task to produce a report off audit table, i am stuck over here as I am …

  kazim.raza

  9 replies

  14 years, 10 months ago

  By: kazim.raza

• Looking for a word occurence count in a rowset scenario.

  Does anyone know of a quick and dirty way to do this any faster? I'm trying to find the Number of …

  Evil Kraig F

  8 replies

  14 years, 10 months ago

  By: Garadin

• A table with a nonclustered index but without primary key or clustered index

  I've discovered in one of our databases there is a large table (million rows) that has a non-cluste…

  peterzeke

  7 replies

  14 years, 10 months ago

  By: peterzeke

• linked server creation

  Hello, I have some problems when creating Linked server. we are using SQL 2005 developer Edtion sce…

  freewarefw

  1 replies

  14 years, 10 months ago

  By: crazy4sql

• Faster way of cleaning up a table.

  Hi, I've got two databases MyDB1 and MyDB2 with some of the tables of the same structure and some a…

  Roust_m

  6 replies

  14 years, 10 months ago

  By: SwePeso

• Convert to mm/dd/yyyy

  Hi, I have a table with DOB in the format Sep 27 1957 12:00AM I need to convert it into 09/27/1957…

  PSB

  7 replies

  14 years, 10 months ago

  By: rVadim

• Conditional Where statement

  I have a situation where I am getting values from a couple of views and feeding them into an SSRS r…

  Brad Allison

  3 replies

  14 years, 10 months ago

  By: drew.allen

• getting error while recreating constraints.

  Hi all, I have a table ABC in a database which holds 10 million rows and takes so much time while a…

  srilu_bannu

  2 replies

  14 years, 10 months ago

  By: srilu_bannu

• sub select

  Hi friends, I get the below error for a sub-select.. select count(*) from (select upper(s_name)…

  newbieuser

  1 replies

  14 years, 10 months ago

  By: Ken McKelvey

• Invoice Tables and pricing dates

  I am trying to query two tables, one which has invoice information, the other which has price histo…

  Jason Coleman

  9 replies

  14 years, 10 months ago

  By: Lynn Pettis

• Avoid a record that has first character as number in a column

  Hi, I want to avoid a record that has first letter as number in a column. This is my code: where…

  ramadesai108

  8 replies

  14 years, 10 months ago

  By: GSquared

• Not able to get the column in dynamic query

  hi, Can anyone tell me how to solve the below dynamic query? It says incorrect syntax near keyword …

  sqlusers

  1 replies

  14 years, 10 months ago

  By: spaghettidba

• Logical Problem -> Recursion?

  Hello all, i'm trying to find a solution for the following problem, maybe recursion is an answer. I…

  MDave

  1 replies

  14 years, 10 months ago

  By: LutzM