For the majority of data retrievals, there are workarounds. In SQL, sub-queries can be used, although joins are also an option in the majority of
Category: SQL Server
SQL Server Administration, Development and Maintenance
SSRS Catalog Queries
Since it is hard to acquire a complete view of the SSRS landscape from the hierarchical web interface, the following query provides some basic information
DATE FORMAT in SQL
SQL date formatting is a common task. When creating reports or getting data, everyone tries to convert the date. In SQL Server, the date can
Split alpha-numeric string into multiple columns in SQL Server
To break the string into numerous columns, a certain pattern should be used. Splitting a string can be done using various delimiters such as a
BULK INSERT in SQL Server
In SQL Server, bulk insert imports a data file in a user-specified format into a database table or view. We’ll be able to import CSV,
SSRS Expressions on Field Values
Usually, the Stored Procedures that were called in the SSRS report contain practically all of the formatting and conversion already. However, you can still convert
Big Data and SQL 