Andomar

Netherlands

Age: 40

I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.

If you'd like to learn SQL properly, consider the awesome free SQL course from Stanford. The organization behind the course offers many other classes. I'm enjoying the Fantasy and Science Fiction course.

9h
comment INSERT INTO with variable for DB
A table or column name cannot be a variable. In effect you have to create a new SQL statement that expands the variables. One way to do that is dynamic SQL, like declare @sql varchar(max) = 'select ...'; exec @sql;
13h
comment SQL Concatenation Many to Many
@AdamMiller: Access does not support cursors.
1d
comment SQL Concatenation Many to Many
VBA is not available then. But that's a good thing: things are much easier in C#. Write a small function that combines rows and creates a comma-separated list for one column. That's very easy to do if you sort the recordset (using order by.)
1d
comment SQL Concatenation Many to Many
Looks like the method of choice is a VBA script: rogersaccesslibrary.com/forum/… This must be the most frequently asked question for SQL Server and MS Access for the past 10 years. It's just embarrassing.
1d
comment SQL Concatenation Many to Many
@TabAlleman: That won't fly in MS Access
1d
revised SELECT DISTINCT returns more rows than expected
edited tags
1d
comment Change NVARCHAR to VARCHAR column data type
That's weird. Have you tried G.Nader's suggestion: create a new table with the desired definition, copy your data over, drop the old table, and rename the new one?
1d
revised From Month Name and year Get date range of that month in sql
edited tags
1d
comment Change NVARCHAR to VARCHAR column data type
How could a row store existing data over its limit?
1d
comment From Month Name and year Get date range of that month in sql
@fancyPants: Maybe Amol means SQL Server, although the question is tagged MySQL
1d
comment Change NVARCHAR to VARCHAR column data type
Both nvarchar(max) and varchar(max) can be stored off-page, so they only contribute a pointer to the the row size limit. There must be something else going on here, could you post the table definition?
1d
answered From Month Name and year Get date range of that month in sql
1d
comment SQL query to find local max, min of date based data
+1 Some extra explanantion: the difference between the row_number() increases when the next row switches from A to B. When both rows have the same category the difference stays the same.
1d
revised SQL query to find local max, min of date based data
edited tags
1d
awarded Enlightened
1d
awarded Nice Answer
2d
revised Disabling the Query Tooltip in SQL Server When Viewing An Execution Plan
added 140 characters in body; added 4 characters in body
2d
revised Disabling the Query Tooltip in SQL Server When Viewing An Execution Plan
deleted 61 characters in body
2d
answered Disabling the Query Tooltip in SQL Server When Viewing An Execution Plan
2d
comment How to insert into selected columns of a table from a csv file
How is copying rows between two tables relevant when trying to import a CSV file?
1 2 3 4 5