SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Linked Server from Test to Production

  I am just reading data from one dB and inserting into another database. Is it ok to create linked …

  PJ_SQL

  7 replies

  10 years ago

  By: Eric M Russell

• Getting the error "Maximum stored procedure, function, trigger, or view nesting level exceeded"

  I have a SSRS report when generated, getting the error Server: Msg 217, Level 16, State 1, Line 1 M…

  VSSGeorge

  21 replies

  10 years ago

  By: Lynn Pettis

• Count of records in all tables, specify DB

  I am stuck guys. Ok I need to create a stored procedure that will get a count of records in each t…

  Jeffery Williams

  8 replies

  10 years ago

  By: Jeffery Williams

• Operand type clash: date is incompatible with int

  I have this query DECLARE @TheDate DATE IF @TheDate IS NULL SET @TheDate = GETDATE() SET @FileN…

  hoseam

  5 replies

  10 years ago

  By: Eirikur Eiriksson

• SQL to return From/To dates with gaps based on running balance

  I have a temp table that has data like this: I need to come up with t-SQL that will show the date…

  gcresse

  3 replies

  10 years ago

  By: gcresse

• Looking for a Query Statment

  I have to put together a Query statement and I am looking for a way to do something with an Everyth…

  SpaveNation

  6 replies

  10 years ago

  By: SpaveNation

• The datepart microsecond is not supported by date function dateadd for data type date.

  DECLARE @End_Date DATE ,@The_Date DATE SET @NetGross = 209 -…

  hoseam

  5 replies

  10 years ago

  By: TheSQLGuru

• Best practices to add Primary key to existing tables

  Any solution to add primary key to the existing tables with contains around 1000 rows(int,not null)…

  GA_SQL

  1 replies

  10 years ago

  By: Lowell

• optimizing query

  Hello, have 2 tables from linked server. result is 1 : n, but in case some issues can be n:n, but t…

  tony28

  4 replies

  10 years ago

  By: gsspsuxj

• BCP text file is adding an extra line at the end of the file

  I am using a BCP statement to output file to text so it can be uploaded to another application. Ho…

  outsider32

  15 replies

  10 years ago

  By: Jeff Moden

• Find difference between two records

  I need to keep history for each record in my table. I created another same structured table with ac…

  MuhammadShafiq

  7 replies

  10 years ago

  By: Jeff Moden

• Unable to select from function

  I am unable to select from the following function - even though it looks like I'm doing everyting c…

  backintheday

  4 replies

  10 years ago

  By: Jeff Moden

• Copy some data from one table to another

  Hello, I have two existing tables: Table 1 and Table2. Both tables have some data. So I want to cop…

  Virtual Reality

  9 replies

  10 years ago

  By: Wayne West

• t-sql 2012 sort order

  In t-sql 2012, I have the following select statement currently; SELECT PERNUM , RTRIM(LASTNAME) + …

  wendy elizabeth

  8 replies

  10 years ago

  By: Lynn Pettis

• Sequence and Pivot based on pattern or islands

  Hi all Apologies for the subject not sure how best to describe what I am hoping to achieve. I have …

  richardm 53436

  9 replies

  10 years ago

  By: J Livingston SQL