Forum Replies Created
Viewing 15 posts - 1,096 through 1,110 (of 8,731 total)
-
RE: use exec(@sql) in if exists and get output parameters dynamic sql
mnr123 - Thursday, July 20, 2017 8:10 AM -
RE: Extracting specific data range
Take a look at the DATEADD() function.
-
RE: Distinct query with all columns
Is there an additional column (or columns) that might make the duplicate rows unique?
If so, you could normalize the table to reduce the duplication of data.
I hope the... -
RE: How to get top and bottom rows from where condition
Will you have gaps in your Id column?
-
RE: Are the posted questions getting worse?
Sergiy - Wednesday, July 19, 2017 1:53 AM -
RE: Call Stored Procedure From Another Stored Procedure
I don't know if I missed a change in the syntax, but the parameters shouldn't be in parenthesis when calling a procedure.
You also have a ELSE BEGIN...END block without... -
RE: Year, Month and Days from date of birth table
EasyBoy - Tuesday, July 18, 2017 10:56 AMLuis Cazares - Tuesday, July 18, 2017 9:35 AMRE: Year, Month and Days from date of birth table
I wonder if something like this would work.
DECLARE @Date datetime = '20150702'SELECT YEAR( DATEDIFF(DD, @Date, GETDATE())) - 1900,
MONTH( DATEDIFF(DD, @Date, GETDATE())) - 1,RE: Add where clause after a stored procedure.
adonetok - Tuesday, July 18, 2017 6:35 AMCan you copy it to...
RE: Question on CASE statement
melinda.savoy - Tuesday, July 18, 2017 6:30 AMYou're welcome....
RE: DevOps
DBA_007 - Tuesday, July 18, 2017 6:03 AMRE: Question on CASE statement
melinda.savoy - Tuesday, July 18, 2017 6:03 AM
In the pic above of the SQL results above I am needing...
RE: Max. Degree or Parallelism
alex.sqldba - Tuesday, July 18, 2017 5:57 AMRE: Max. Degree or Parallelism
alex.sqldba - Monday, July 17, 2017 11:43 AMRE: Max. Degree or Parallelism
Sreekanth B - Monday, July 17, 2017 9:47 AMViewing 15 posts - 1,096 through 1,110 (of 8,731 total)
