T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• WHERE Filter

  Hi to all. I haven't posted for a while and it is now time to wear my sql cap again I have a quer…

  2Tall

  8 replies

  12 years, 7 months ago

  By: 2Tall

• Rand() function error

  CREATE FUNCTION ufntGenerateRandValue ( @minValue int, @maxValue int ) RETURNS int AS BEGIN DECLARE…

  manoj005

  15 replies

  12 years, 7 months ago

  By: starshayiz

• Select statements included within a function cannot return data to a client

  Hi, i'm trying create on function, but the sql print: Msg 444, Level 16, State 2, Procedure Retorna…

  luan.wp

  5 replies

  12 years, 7 months ago

  By: starshayiz

• Conditional Delete not working

  Why does this delete all my records, reguardless of company? delete Plant_Master where EXISTS(Selec…

  dwilliscp

  9 replies

  12 years, 7 months ago

  By: dwilliscp

• Splitting Data by day

  Hi All, I have an issue while splitting the data by day in the given period. The Function I am usin…

  Ram:)

  5 replies

  12 years, 7 months ago

  By: Jeff Moden

• Dropping DF_ constraints

  HELP!! I have a deployment script that is building tables and setting default values to a column. …

  Angelindiego

  2 replies

  12 years, 7 months ago

  By: Angelindiego

• Dealing with Daylight Savings Time

  Hi all, I'm having an issue regarding dates that are stored in one format vs another, as far as Day…

  kramaswamy

  5 replies

  12 years, 7 months ago

  By: GSquared

• Audit Triggers

  Hi, I need to create two triggers on my small lookup tables for audit purposes. The triggers are fo…

  krypto69

  7 replies

  12 years, 7 months ago

  By: GSquared

• CREATING A COLUMN TO RETURN THE MAX VALUE FOR EACH GROUP WITHIN A SUBQUERY

  I would like the column PROJECT_LEVEL to consists of the MAX value within the column DASHBOARD_STA…

  cnjsvision74

  1 replies

  12 years, 7 months ago

  By: Eugene Elutin

• Help with a "simple" XML example, please

  Don't laugh too hard but I'm definitely out of my element and need some help in the form of an exam…

  Jeff Moden

  24 replies

  12 years, 7 months ago

  By: GSquared

• SELECT INTO synonym raise error

  Hello - I have a situation where my only means of importing some badly needed data into one of my …

  SQL_ME_RICH

  6 replies

  12 years, 7 months ago

  By: Luis Cazares

• What's the best way to pass parameter into a dynamic sql in my case? Thanks.

  My final dynamic @sql would be: Select DocID, Code, Ref, Title, DocType, FileName, InitialSignOffD…

  halifaxdal

  12 replies

  12 years, 7 months ago

  By: MMartin1

• How to multiply rows in one table based on the value on another table

  Data: declare @t1 table (Id int) insert into @t1 (Id) select 1 union select 2 union select 3 decla…

  _simon_

  6 replies

  12 years, 7 months ago

  By: _simon_

• How to filter if data was not there

  I have a query (shown below) that I have been asked to filter so that only stock activity that has …

  dwilliscp

  3 replies

  12 years, 7 months ago

  By: MMartin1

• Item grouping for packing slips

  Hi Everybody We ship books - no more than 10 books per box. And Other items (toys, etc.) – no mo…

  justforgroups2004

  3 replies

  12 years, 7 months ago

  By: MMartin1