Guest User

Untitled

a guest
Jan 17th, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. SELECT * FROM OPENQUERY([MYSQLCONN],
  2. 'SELECT e_id, TDate, Entry, `Exit` FROM timemgt.daymaster
  3. WHERE TDate >= ''''' + @frmDate + ''''' ')
  4.  
  5. SELECT * FROM OPENQUERY([MYSQLCONN],
  6. 'SELECT e_id, TDate, TIME_FORMAT(Entry, ''%T'') AS ''Entry'',
  7. TIME_FORMAT(`Exit`, ''%T'') AS ''Exit'' FROM timemgt.daymaster
  8. WHERE TDate >= ''2017-01-01'' AND TDate <= ''2017-01-01''')
  9.  
  10. DECLARE @frmDate VARCHAR(10)
  11. DECLARE @toDate VARCHAR(10)
  12. SET @frmDate = '2017-01-01'
  13. SET @toDate = '2017-01-01'
  14.  
  15. SELECT * FROM OPENQUERY([MYSQLCONN],
  16. 'SELECT e_id, TDate, TIME_FORMAT(Entry, ''%T'') AS ''Entry'',
  17. TIME_FORMAT(`Exit`, ''%T'') AS ''Exit'' FROM timemgt.daymaster
  18. WHERE TDate >=''' + @frmDate + ''' AND TDate <= '''+ @toDate +'''')
  19.  
  20. WHERE TDate >= ''''' + @frmDate + '''''
  21.  
  22. WHERE TDate >= ' + @frmDateString + '
  23.  
  24. declare @sql as nvarchar(max);
  25. set @sql = 'select * from openquery(
  26. SERVERNAME,
  27. ''
  28. select etc
  29. where SomeDateField > = ' + @dateString + '
  30. etc
  31. ''
  32. )
  33. ';
  34.  
  35. exec sp_executesql @sql;
Add Comment
Please, Sign In to add comment