I do not know what your national passport numbers look like but from the examples you show the requiredments are two characters followed by six numbers optionally followed by something...

Now you again use the " in the wrong position:

Look at my last post 😉

AFAIK you cannot do it from an sql batch. I probably would write a vba script that opens a word document and a db connection, executes the query and writes...

OK, now I see: It's not an SQL but an vb error: You try to use " inside the vb string argument. You have to escape these. I am not...

Hi Joe,

I don't understand what you want. Do you want to count the dates by week or by weekday?

Alexander

There are another two " in the last line to be substituted.

First try replacing the " by ' in

AND (LocationID = " & S

Thank you for your reply.

So, what are your decision rules? (Like the maximum string length being greater than x and the variance of the strings' length being greater than y)

Not sure that I understand what you aim at.

But if you want to filter in terms of a patterns like "999-XXX-99" where "9" is a placeholder for a number and...

AFAIK there is no difference regarding the handling of the database engine.

I prefer the inner join: Say you want to change the inner to an outer join. That ist easy...

There is a "nested triggers" server configuration option that allows/disallows triggers to act recursively.

If you don't want to change the server option: Change your logic using an if statement so...

Hard to tell, as I don't know what your data flow actually does.

But the error message says that you try to stuff a 50 character string in a 5 character...

Hi,

sorry for my problem not being too clear:

Actually I have a usage problem with SSMS: I often have to do ad-hoc queries and use SSMS to copy the data to...

Thank you for your reply.

That's what I would have hoped for, but I get an error saying that windowed functions are valid only in select and order by clauses.

I think...

No, unfortunately i haven't got a solution yet...