Thursday, 25 June 2020

Troubleshooting in SQL

1. SSRS Error 

Round () need to be done in  SQL itself 

2. Default Date In SSRS 

Start Date
=CDate(Format(DateAdd("d",-50,Now()), "MM/dd/yyyy") + " 07:00:00")

End Date 
=CDate(Format(DateAdd("d",0,Now()), "MM/dd/yyyy") + " 06:59:59")
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Troubleshooting in SQL

1. SSRS Error  Round () need to be done in  SQL itself  2. Default Date In SSRS  Start Date =CDate(Format(DateAdd("d",-50,Now()), ...

  • Troubleshooting in SQL
    1. SSRS Error  Round () need to be done in  SQL itself  2. Default Date In SSRS  Start Date =CDate(Format(DateAdd("d",-50,Now()), ...
  • String
    #include<stdio.h> int main() { char str[]={"hello world"}; int i=0; while(str[i]) printf("%c",str[i++]); ...