Do you have a table with this structure?

You should really read on normalization to properly design your tables.

That sounds like a good and bad news. And the good news sound great.

Thank you for the update, Steve.

In an unrelated topic, have you ever seen a code and want...

Is that a constant? Does returning to the previous version solves the problem?

My guess is that the problem has to do with blocking or some kind of waits.

This is one of the reasons to use the appropriate data types for your columns. This validation might not work if you have 2 or more points in your string.

I...

It seems weird that you have appointment dates in the same table as your admissions. I hope that your real data doesn't looks like that.

Here's an option based on what...

SQL Server keeps track of every change made to the database in the transaction log. The problem is that you can't use it to query tables based on the dates...

I did part of the job for you. You should be able to complete the rest.

CREATE TABLE table1(

Col1 varchar(8000))

INSERT INTO table1

VALUES

('Fornecedor 14105 -...

And I was asking where do the insert values come from, not where they go.

Have you tried using the QUOTENAME()function?

It can be really helpful for this kind of things.

Where are those 4500 lines of inserts coming from?

The second one gives permissions on certain system views and functions. Especifically, Server-scoped dynamic management views and functions.

It isn't a big security risk, but you definitely don't need that grant.

http://serverfault.com/questions/191661/what-can-user-do-with-view-server-state-permissions

http://dba.stackexchange.com/questions/27485/security-and-performance-implications-of-view-server-state

Do you need to do it once? Or do you need to do it automatically at any time?

SSMS has an option to script your procedures as dynamic SQL, you just...

For SSRS, it should be something like this:

=Sum(IIF(Fields!column1.Value = 1, column2, 0))

Maybe this version will help you.

CREATE FUNCTION dbo.CleanNames( @Name varchar(8000))

RETURNS TABLE WITH SCHEMABINDING

AS

RETURN

--===== "Inline" CTE Driven "Tally Table" produces values from 0 up to 10,000...

...

This editorial reminded me of this site:

http://www.tylervigen.com/

Did you now that US spending on science, space, and technology correlates with Suicides by hanging, strangulation and suffocation? Or that Divorce rate in...