T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• delete records in history table

  We are trying to delete records in some history tables to save space. This is a database setup usin…

  sqlfriend

  1 replies

  14 years ago

  By: Gullimeel

• table column names

  I am looking at a database designed by someone else. I see he named the columns like Date_SK, Date_…

  sqlfriend

  6 replies

  14 years ago

  By: SQLRNNR

• UPDATE with CASE Statement not updating all Records

  Does anything appear to be wrong with the following CASE Statement? It always updates the First Col…

  Welsh Corgi

  28 replies

  14 years ago

  By: Welsh Corgi

• Production issue with varchar(max)

  I thought varchar(max) will store 2 gb data, but here I have a comma delim string that I am passing…

  ramadesai108

  23 replies

  14 years ago

  By: clouwaerts

• is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

  ALTER VIEW [dbo].[neoset_dailySalesManReport] AS SELECT TOP (100) PERCENT s.entryDate AS 'date'…

  mixalissen

  3 replies

  14 years ago

  By: mixalissen

• Invoice_Dates

  Hi guys this is my query i wrote to get date in invoice . But i am getting today date . I need date…

  3935

  4 replies

  14 years ago

  By: Ant-Green

• Finding a future date in a calendar

  Greetings, I have a table that represents the calendar of days that employees work during the year.…

  gmrose

  24 replies

  14 years ago

  By: Jeff Moden

• Sum DISTINCT fields only

  What is the best way to sum the distinct fields only. I've got a select that returns duplicate rows…

  DVSQL

  13 replies

  14 years ago

  By: jshahan

• Need help with CURSOR or other logic to get my data

  Let first apologize since I have no idea how to start this small project. I have no code, because I…

  SQL_Enthusiast

  6 replies

  14 years ago

  By: SQL_Enthusiast

• Pivot Columns

  How can I Pivot the following? The objective is to get the columns listed horizontally and progamat…

  Welsh Corgi

  7 replies

  14 years ago

  By: Welsh Corgi

• need query help - need to get prior rolling 6 months from today's date

  This is starting to drive me to drink!! I have my date field in my table as [201206], I'm able to g…

  SQL_NuB

  2 replies

  14 years ago

  By: SQL_NuB

• You do not have permission to use the bulk load statement

  Hi, I've got 2 users, an administrator and Bob. Both are SysAdmin When I'm logged in as administrat…

  giles.clapham

  6 replies

  14 years ago

  By: chrisfradenburg

• CSV splitted in ROW'S

  HI ; How to split the csv values in rows , this is my sample string UNIPAR LLC , IAE Power Product…

  sqlfriends@sql.com

  4 replies

  14 years ago

  By: Jeff Moden

• Search for TExt of Stored Procedure - Replacement for syscomments

  What would the SQL Server 2005 and above eqivilent command for the following? SELECT * FROM syscom…

  Welsh Corgi

  11 replies

  14 years ago

  By: WILLIAM MITCHELL

• whether commited transaction will get rollback again

  hi waiting for the reply thanks kumar

  Kumara1011

  12 replies

  14 years ago

  By: Gail Shaw