"Define query parameters" popup in Dataset properties -> Refersh field, not displayed for Sps in SSDT 2010 (Works fine in BIDS) "Dynamic Date" in a suscribed SSRS report "How to get distinct values of sharepoint column using SSRS" "Invalid namespace" when using SSMS to connect to ...
Can I create a SSIS package to get only row 12 to row 123 from an excel sheet..?? Can I have multiple instances of SSIS on a server? Can I preserve carriage returns in a string variable from SQL Server? Can I query SQL Server Agent Job Step Configuration Parameters Can I Reference ...
We will use PowerShell this time to do this task. If you have SSMS 17, you may need to read the next article to install PowerShell: What is new in SSMS 17; PowerShell and DAX PowerShell is very useful to deal with files, folders, services and the operative system. That is why we...
Can we select Bottom 1000 rows of a database Table from SSMS 2008 R2? Can we set value in a variable inside a select statement can we use CTE for selecting data from excel Can we use While loop in CTE? can we write DDL command in Stored Proced...
"Define query parameters" popup in Dataset properties -> Refersh field, not displayed for Sps in SSDT 2010 (Works fine in BIDS) "Dynamic Date" in a suscribed SSRS report "How to get distinct values of sharepoint column using SSRS" "Invali...
'Return' statement in a Function,Get,or Operator must return a value...Question "An error occurred during local reporting processing. Object reference not set to an instance of an object." "Define query parameters" popup in Dataset properties -> Refersh field, not displayed for Sps in SSDT...
Add Time in SQL HH:MM:SS to another HH:MM:SS Adding a column to a large (100 million rows) table with default constraint adding a extra column in a pivot table created uisng T-SQL Pivot Table query Adding a partition scheme to an existing table. Adding a Value to a 'date' Colum...
'Return' statement in a Function,Get,or Operator must return a value...Question "An error occurred during local reporting processing. Object reference not set to an instance of an object." "Define query parameters" popup in Dataset properties -> Refersh field, not displayed for Sps in SSDT...
Getting script to write output to console and a log file Getting SQL version info from list of server names Getting the Active directory AD groups and user names with Powershell Getting the Error 'The Given Key was not present in the dictionary' while running AD module PowerShell Gettin...
Add Time in SQL HH:MM:SS to another HH:MM:SS Adding a column to a large (100 million rows) table with default constraint adding a extra column in a pivot table created uisng T-SQL Pivot Table query Adding a partition scheme to an existing table. Adding a Value to a 'date' Column...