Not sure about VB. From SQL I use syntax like below and it works fine. Provided, of course, that ACE driver is actually installed on the SQL Server, no one...

You need to explicitly convert getdate(), for example:

CONVERT(CHAR(8), GETDATE(), 112)

I was able to reproduce your problem when I added .01 to the original value. Maybe in the table you have 131281.01 but don't see it in the output?

            
April 15, 2019 at 9:57 pm
            
#3389692

            
            
                                                
        

From SQL you can try to use ACE driver. Something like this:

INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Text;Database=C:\Temp\;HDR=YES;FMT=CSVDelimited',
'SELECT * FROM [FileName.csv]')
SELECT Field1, Field2, Field3
FROM MyTable

Please note that target file must already...

Are we talking about nesting in CASE expression? If so, you can start another CASE after THEN. Something like this:

CASE lineid1
  WHEN 'APPROVED' 
  THEN...

Not sure if I got it correctly.... If you know sequence of characters you replacing use REPLACE() function. If you need to replace at certain positions, use STUFF() function.

Which aggregate you use is up to you. You need count - use COUNT. You can also use SUM to count things in CASE. Other than that follow the technique...

• This reply was modified 6 years, 5 months ago by rVadim. Reason: Fixed code

Check this: https://gallery.technet.microsoft.com/scriptcenter/42440a6b-c5b1-4acc-9632-d608d1c40a5c

 

As Ben had shown, you can use Insert...EXEC in the procedure to capture xp_cmdshell output into table. Then parse it in the function.

You can do file manipulation in the external...

• This reply was modified 6 years, 5 months ago by rVadim. Reason: Corrected code appearance

Sure, if number of columns is unpredictable you'll need dynamic SQL. But inside that dynamic SQL you may implement one of the crosstab techniques. The only other way I can...

Here is one way doing this:

SELECT 
  [COLUMNS] = 'TID',
  [2019-01-01] = MIN(CASE WHEN LDate = '20190101' THEN TID END),
  [2019-01-03] = MIN(CASE WHEN...

Your desired output doesn't seem right. There is no 'user2' in FName column, there is no 'user1' in LName. How come they appear in respecting output rows. It's a crosstab...

Also, if I'm not mistaken, default schema is ignored for sysadmins. They always get dbo.

I don't think schema will be created in CREATE TABLE even if you grant CREATE SCHEMA permission to the user. You'll need separate statement for that.

I attempted to answer today, May 27. Naturally selected #4....

This queston has timing issue. 🙂