SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Need help to visualize Tree View using table Data

  Hi everybody, I need a T-sql query to return the existing table data return as a Tree View structur…

  uravindarreddy

  2 replies

  9 years, 10 months ago

  By: uravindarreddy

• Convert and Combine Currencies

  Hi, I have a table of invoices with different currency types, AUD, USD, EUR, INR, RUP, CND etc... t…

  ringovski

  4 replies

  9 years, 10 months ago

  By: Sergiy

• Refresh roles list for IS_ROLEMEMBER?

  Hi all. I'm trying to drop users from roles via T-SQL, then check to ensure the user has been dropp…

  kpwimberger

  1 replies

  9 years, 10 months ago

  By: kpwimberger

• take some data from excel through sql

  Hi I have a problem I want to have a .csv File with the following format , some fields like ‘actors…

  gxdatareal

  12 replies

  9 years, 10 months ago

  By: sestell1

• T Sql - just current Version wanted.

  Good day experts, I am new to Sql and i want to modify the query below to return current VERSION.P…

  tmmutsetse

  4 replies

  9 years, 10 months ago

  By: drew.allen

• Estimated Execution plan and getdate() in the where clause ??

  Estimated Execution plan I am looking at improving the efficiency of someone's SQL. Adding Indexes …

  Ells

  2 replies

  9 years, 10 months ago

  By: Ells

• How to update multiple rows based on inserted records

  Hello, I'm working on a commercial application based on C# and SQL Server 2012 I need to know how t…

  Mando_eg

  2 replies

  9 years, 10 months ago

  By: Mando_eg

• Does T-SQL have a means of iterating over the columns of a table?

  We've got an unusual request, and I think my managers are approaching this from a programming POV r…

  Rod at work

  59 replies

  9 years, 10 months ago

  By: R.P.Rozema

• schema insert not working as planned schema as tablename

  I have a script that is building dynamic sql. It generates this statement SELECT * into [Feeds].A…

  John1.5.nlt

  5 replies

  9 years, 10 months ago

  By: Alvin Ramard

• Error Handling with multiple Stored procedures

  I've created a process to delete all client information from our database based on the CustomerID o…

  BWCA

  2 replies

  9 years, 10 months ago

  By: Jack Corbett

• Query to compare two views and find non-matching record ??

  I have attached the word document which will show proper views(columns). Please check the attach wo…

  rk1980factor

  32 replies

  9 years, 10 months ago

  By: sestell1

• t-sql 2012 date 1900-01-01

  In a t-sql 2012 statement where values are inserted into a table, the data is stored in the date co…

  wendy elizabeth

  4 replies

  9 years, 10 months ago

  By: Jeff Moden

• Question about how Lag function will work on Sql server 2012

  Hi All I have facing problem to display information like Lag function, but Lag is not working on sq…

  zahid.techk

  4 replies

  9 years, 10 months ago

  By: J Livingston SQL

• Question About Getting Max Dense_Rank Number

  I have the following issue: I'm trying to get the MAX number from a dense_rank query. Basically, I …

  copling

  7 replies

  9 years, 10 months ago

  By: copling

• Dynamic SQL Agent Jobs - Schedule disabled before it can run (SetJobNextRunDate?)

  Hi. I am running SQL 2012 sp2 64 bit (v 11.0.5343.0). I am dynamically creating SQL Agent jobs usin…

  Mike Hutton

  1 replies

  9 years, 10 months ago

  By: Jason A. Long