SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• UPDATE statement help

  Hello, I'm looking for a SQL UPDATE statement to update all the historical class4 entries with the …

  jSqlB

  16 replies

  10 years, 4 months ago

  By: lnardozi 61862

• Case Statement Subquery to Set a bit value

  Hello SQL Friends, How can I set a value for a field based on transactions in another table? I am…

  kwoznica

  2 replies

  10 years, 4 months ago

  By: kwoznica

• FINDING RECORDS IN ONE TBALE NOT IN SYNC WITH ANOTHER TABLE

  Here is the data for the question I am facing: CREATE TABLE #NEWSOURCE(CUSTOMERID VARCHAR(5), CATEG…

  Nilssond

  4 replies

  10 years, 4 months ago

  By: Nilssond

• dynamic cursor

  Hi, I want to create a dynamic backup job for the AS databases on my servers. It should be dynamic…

  ratloser99 36160

  6 replies

  10 years, 4 months ago

  By: ratloser99 36160

• Need comma separated output

  Create Table #Test (id int identity,C1 bit , C2 Bit , C3 Bit) insert into #test Values (0,0,0) inse…

  squvi.87

  3 replies

  10 years, 4 months ago

  By: Eirikur Eiriksson

• t-sql 2012 passing lot of values in a parameter

  In t-sql 2012, I want to run a query where the value is normally an int value. I want to supply a l…

  wendy elizabeth

  15 replies

  10 years, 4 months ago

  By: SoHelpMeCodd

• Unique index on varchar(max) column

  Hi Team, CREATE TABLE search_T ( num INT, value VARCHAR(max) ,UNIQUE …

  Minnu

  3 replies

  10 years, 4 months ago

  By: ScottPletcher

• SQL Query question

  Hi all, I am having trouble to write a sql query to capture history of item so that I could do repo…

  ktlady

  2 replies

  10 years, 4 months ago

  By: ktlady

• Insert into select from - View

  CREATE VIEW [dbo].[test_view] AS INSERT INTO s_info ( s_num, s_name ) SELECT DISTINCT p_id, p_name…

  Minnu

  5 replies

  10 years, 4 months ago

  By: Jeff Moden

• Need some suggestions for database design for invoices in a multi-tenant app

  Hi all, I need some guidance on designing the schema for invoices in a multi-tenant application.I h…

  divyang_dv 42143

  11 replies

  10 years, 4 months ago

  By: Ant-Green

• Create View to allocate amount per month - financial year

  Hi All, I like to create an SQL view to divide amount 300,000 between 12 month starting from Month …

  jaggy99

  8 replies

  10 years, 4 months ago

  By: gpmaya

• Last N Group with Top n for each Group

  Hi, i have the following Table : PeriodDetails : PeriodID,CustomerID, CloseBalance. at the beginnin…

  abd_gam

  11 replies

  10 years, 4 months ago

  By: abd_gam

• Referencing function from another database in CREATE TABLE stmt

  I am trying to setup a globally available function, so that when user's add data I can strip out ou…

  chuck.forbes

  14 replies

  10 years, 4 months ago

  By: Jeff Moden

• Get previous row's value - with a twist!

  Hi all, I have a scenario where I am dealing with assets. Every business day we get a new asset val…

  mm7861

  16 replies

  10 years, 4 months ago

  By: J Livingston SQL

• grouping time periods with gaps

  Hello, this is a simplified sample to demonstrate the problem I am having: CREATE TABLE #Sample (ID…

  slatinsky

  2 replies

  10 years, 4 months ago

  By: Luis Cazares