Bhupinder K. Modi
- Total activity 13
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 4
Activity overview
Latest activity by Bhupinder K. Modi-
Bhupinder K. Modi created a post,
Exporting to Sql server
The column names in the table in Sql server contain spaces. I cannot seem to export the worksheet Does the column names in the workbook should be exactly the same as the sqlserver...meaning case se...
-
Bhupinder K. Modi commented,
I am able to display null values in /mySql....Thanks for your help and guidance
-
Bhupinder K. Modi commented,
Thankyou kindly
-
Bhupinder K. Modi commented,
Hello Konsta The exact version is 7.4.6 Report_Date is Date type and Report_Time is Time data type in Sql server..... I am a able to tansfer null using your logic...importing new data in workbo...
-
Bhupinder K. Modi commented,
Thankyou for the code QuarterYear should be dynamic usign the following logic from sql server (SELECT CAST(CASE WHEN month(getdate()) in (9,10,11) THEN 1 --12020 is availability date Oct/Nov/Dec...
-
Bhupinder K. Modi commented,
Thanks Konsta All good here Hoping the same for you What Datameer version do you use? Version 7 Do you see 1900-01-01 instead of null values in random columns or in a certain one? The date is sh...
-
Bhupinder K. Modi created a post,
Need to export null values to date column in SQL server
When I am exporting null values from Datameer to Sql server I am getting 1900-01-01 . How can I change then to display NULL values in Sql server
-
Bhupinder K. Modi created a post,
Inserting data in workbook
I need to insert rows in worksheet with a specific format to be loaded to sql server. This is code in Sql server that needs to be DECLARE @LoopCounter INT = 1 WHILE ( @LoopCounter <= 17) BEGIN ...
-
Bhupinder K. Modi created a post,
Inserting data in workbook
I need to insert rows in worksheet with a specific format to be loaded to sql server. This is code in Sql server that needs to be DECLARE @LoopCounter INT = 1 WHILE ( @LoopCounter <= 17) BEGIN ...