I think "Bad Managers" are considered as "You don't want to leave but you have to" type of problem in a company. I remember a time when I have this...

(Don't get me wrong, I know how to code, but I'm not that great.)

The test I give to a interviewee would be writing a code which would add, insert, update...

Yep, that's what I think too, I'm ending it right here, thank you!

Currently I'm looking at solutions on how to fix the error when the CSV file and our database are not equal in terms of column count. But I might need...

Hi Sir Jeff Moden,

Good Day.

Sir, If you dont mid asnwering again, I searched in the internet but to no avail. My current problem is, the data which I gave you,...

If I could only know how to check the number of rows in this kind of CSV, that would be great! but anyway, thank you for the insight sir! This...

The SQL Express back-end will give you the ability to build and use stored procedures (amongst other benefits) and provide better locking mechanism so the end users won't interfere with...

Hi Sir Jeff!

Thank you for your time!

Sir, I have uploaded the data files which you wanted. Thanks again!

Going back to the last thread that we have discussed sir, IF ever...

Yes Sir, I created a XML file, here is the screenshot.

Do take note i change my terminator from '","' to ','

and here sir is the textfile

I would like to ask...

I tried using your code sir, first, i uploaded the data as temp table in my database (into #TestCSVImport). I also renamed the column names of the CSV file to...

I just learned open rowset!

SELECT *

FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 12.0 Xml;

Database=C:\DataFiles\EmployeeData1.xlsx',

[vEmployee$]);

Thank You Mr. Jeff Moden

And I would like to take this opportunity to say that your Profile Photo never fails to amuse me, even RBAR!

And, to the topic, I would...

could anybody answer this please?

I'm not quite sure when and where the data will be 4 or 6 columns since the data source is a scientific device which measures temperatures. It has its own...

So I marked your reply as the answer, I used hostname as the source.

ALTER TRIGGER [dbo].[SaveUsers]

ON [dbo].[Employee]

AFTER UPDATE

AS

BEGIN

-- SET NOCOUNT...