End user has entered ‘goodmorning’ and ‘good morning’ interchangeably and it was causing logic failure at application level. So task was to replace ‘goodmorning’ with ‘good morning’ in database wherever it is there.
2017-04-28 (first published: 2017-04-10)
723 reads
Hello,my table contains 2 columns .EmpID varchar(10),ReportingToID varchar(10)how to write a query that returns all the employees under a ReportingToID ...?the key here is i want all the employees that are under a ReportingToID tree.i don't know the exact number of levels under a ReportingToID empID ManagerIDabc ""def abcghi abcjkl ghiklk jklmmm jkl Thank YouSai
2005-01-14
Hello All,I want to know whether it is possible to initialize an input variable in a user-defined function. If so, then how it should be used in a select query?create function dbo.udfgetloc (@locid int, @typ int = 0)returns varchar(10) asbegin declare @str varchar(10) if @typ = 0 select @str = query else select @str = queryreturn […]
2004-04-21
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers