Is the AD group still setup as a login to the server?  If so - then it doesn't matter if the group is enabled or disabled, in fact - that...

If you already have an SSIS package setup to build the Excel files - then you should be able to put everything else in the script directly into SSIS.  It...

I am assuming a standard letter size - 8.5 x 11.  If so - confirm the pallete size of the report does not exceed 11 - left margin - right...

Okay - I see the problem here.  The issue is that we are replacing a single character from Viet to multiple characters in VNI.  The way the replace works it...

• This reply was modified 5 years, 10 months ago by Jeffrey Williams. Reason: Modified the second function - need to return nvarchar(max) and set @replaceString to nvarchar(max) to handle converted strings that are larger than 4000 characters

In SQL Server - if you try to use a date string in DD/MM/YYYY format where the language is set to US (either for that connection or server) it will...

Hi Jeffrey

The field I'm using for the parameter is a date/time field and the parameter is set to date/time type.  It's allowing me to enter UK dates at Preview...

I am a bit confused - if your parameter is setup as a date/time parameter then it shouldn't matter the 'format'.  The parameter will be defined as a date/time and...

The original function was to convert from VNI to VIET.  You changed this to convert from VIET to VNI.  Here are the results from my system:

May 6, 2020 at 3:38 pm

#3749394

You are looking at a cross-tab or pivot of the data:

 Select EmpNo
      , Sales = sum(Case When JobNo = 'Sales' Then...

Are you saying your DEV system is setup with an availability group and you need to refresh the DEV database(s) from production on a daily basis?

I see no reason to...

Are you referring to 'Drop Table If Exists'?

How was this system created - is it a new system where you restored the databases from backups?  If so - check the owner of the database and change it...

I pulled the list of viet character encodings from http://vietunicode.sourceforge.net/charset/

Using that list to build the table you can then use that table to convert to/from multiple character encoding.  The function...

• This reply was modified 5 years, 10 months ago by Jeffrey Williams.
• This reply was modified 5 years, 10 months ago by Jeffrey Williams. Reason: Updated insert into table to use unicode prefix on the strings to insure correct character representation
• This reply was modified 5 years, 10 months ago by Jeffrey Williams.

I am not sure about the full process you are attempting here - but it looks to me like a situation that might work better as a master package and...

I have a pretty "dumb" question, but I want to get the consensus on this

I have a table that is going to store Location data (address, geocoding, etc). Location...