SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Assistance with CROSS APPLY with multiple tables

  I am tasked with deciphering a shed load of COGNOS pseudo code - basically it runs against Oracle D…

  Jabba1963

  10 replies

  10 years ago

  By: Jabba1963

• Drill Down - Help

  Hi, I have a small data set that I have created and inserted into a temp table by looking for dupli…

  dramaqueen

  8 replies

  10 years ago

  By: Umer Akram

• t-sql 2012 inset, and update

  In a t-sql 2012 database table, I need to be able to determine if a row exists in a table, update, …

  wendy elizabeth

  1 replies

  10 years ago

  By: Thom A

• Converting Date

  Hi, I am not sure if this is possible but can you convert a string nvarchar(50) to a date. I need t…

  dramaqueen

  3 replies

  10 years ago

  By: dramaqueen

• Reference to non-existent column does not error

  I'm in the process of re-writing some inefficient, looping code from a former developer and I've st…

  John Rowan

  3 replies

  10 years ago

  By: John Rowan

• Nested quotes help

  how can i get the [ ] characters around the username? nested quotes is probably my least favorite t…

  jsqldba

  4 replies

  10 years ago

  By: jsqldba

• Update variable having timestamp value in it.

  Hi everyone, I am writing one T-SQL code where i have below requirement , suppose a variable contai…

  Abhi kr

  3 replies

  10 years ago

  By: Abhi kr

• t-sql 2012 datatype

  In sql server 2012, I would like to know what datatype can hold the maximum number of characters? (…

  wendy elizabeth

  13 replies

  10 years ago

  By: Grant Fritchey

• Generate Repeating Set of Row_Number values

  Hello - I have a table that contains a set of rows, where each row can represent a query to run. I…

  will_william

  3 replies

  10 years ago

  By: Alan Burstein

• aggregate function in subquery

  I'm facing some problem with a SQL query. Probably solution is pretty easy but I'm new to SQL, here…

  Pro100

  5 replies

  10 years ago

  By: drew.allen

• How to get list of stored procedures statistics

  Hi, I'm trying a way to find the list of stored procedures statistics. Am looking for Name of SP Us…

  SSCNewbee

  3 replies

  10 years ago

  By: Gail Shaw

• Join 4 tables and get data based on a bitwise column

  I've 4 tables namely LoginType, UsrReportType, UsrList, Log_UsrAccess. LoginType (Id) table has a b…

  User7766

  5 replies

  10 years ago

  By: User7766

• Sequence generation

  Hi I had accountno as field for each account no there is number of transactions happening AccountN…

  SQL006

  13 replies

  10 years ago

  By: TheSQLGuru

• Multiple joins to same table in view

  Hello , In my system (CRM software) i have a definitions table which contains (tableID,valueIndex,v…

  kobi.burkis

  7 replies

  10 years ago

  By: Luis Cazares

• Permissions Issue with Bulk Insert and Execute as...HELP!

  Hi All, I have a need to copy some files into a filetable during a deploy process to a nightly env…

  Ness

  4 replies

  10 years ago

  By: Jeff Moden