SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• That old conversion failed Date Time error

  Hi All, Apologies if I have committed a sin but am starting a new thread after updating another as …

  Kazmerelda

  8 replies

  10 years ago

  By: Kazmerelda

• I'm missing something obvious but I'm not sure what.

  I'm working on this SP and am getting an error at the end, Msg 102, Level 15, State 1, Procedure p_…

  craig.bobchin

  3 replies

  10 years ago

  By: ChrisM@Work

• generate unique id for each row within a range

  Hi All I want to assign one unique id to each row in a table and the range is from 1 to 99999. ther…

  bismsit.29

  20 replies

  10 years ago

  By: Jeff Moden

• Grant user with read only access to all user DBs

  I have about 1917 databases in the server. I have already created the login for users. All users ne…

  Chitown

  5 replies

  10 years ago

  By: Orlando Colamatteo

• Find hierarchyID from different parts of a node?

  I started working with the hierarchyID data type. So far it's been pretty great working with the b…

  Y.B.

  12 replies

  10 years ago

  By: Jeff Moden

• Optimize SP

  Hi, I have created this SP and I am wondering if anyone can help me optimise the sp and its taking …

  maxlezious

  13 replies

  10 years ago

  By: TheSQLGuru

• Change t-sql 2012 to not use a cte

  I would like to change the following t-sql 2012 from a cte to sql that does not need a cte. I would…

  wendy elizabeth

  6 replies

  10 years ago

  By: Jeff Moden

• DATEADD shortcut

  I inherited some old code with what appears to be some kind of shorthand/shortcut for doing DATEADD…

  autoexcrement

  12 replies

  10 years ago

  By: Phil Parkin

• Add two columns to make one total

  okay guys, I am stuck. I have two columns that I need to add and make one total for a report. there…

  lkennedy76

  25 replies

  10 years ago

  By: drew.allen

• Conditional column display

  Hello all, I've run into an issue in a stored proc. Within the Select statement, I need to conditio…

  nat_s

  4 replies

  10 years ago

  By: nat_s

• Copy image from one folder to another with sql server except duplicate image

  Hello, I am planning to implement a script to copy image from one folder to another with sql server…

  Virtual Reality

  11 replies

  10 years ago

  By: Virtual Reality

• Getting values which dont join

  If I have the following example tables: CREATE TABLE [dbo].[Status] ( [StatusID] [INT] N…

  Maddave

  6 replies

  10 years ago

  By: Maddave

• SQL Server backup fails with network UNC share

  I am currently trying to take backup of a database to a network UNC share, but its giving me error.…

  hemal_301080

  1 replies

  10 years ago

  By: michal.lisinski

• SQL Server connection issues / visibility of database.

  Periodically(roughly every month to 6 weeks) and from differing sources ( Windows Service Applicati…

  simonsmithbsa

  3 replies

  10 years ago

  By: simonsmithbsa

• Need to add and grant permissions to all the tables,procs from a database to a database role

  Hi, I have a database role currently in my database and i am trying to add the all the objects(tabl…

  sravan.here

  2 replies

  10 years ago

  By: sravan.here