Viewing 15 posts - 271 through 285 (of 557 total)
Jeff Moden (2/16/2016)
ben.brugman (2/16/2016)
Still working on situations where we want to select a specific period and subscribers at that moment.Please see the following article for that...
Did read your article. Thanks.
The...
February 18, 2016 at 1:44 am
Changing the collation is a huge effort in my opinion.So if it is not needed, don't do it.
If there is not 'connection' with other databases, there is no need.
There is...
February 17, 2016 at 4:43 pm
Hello Jeff,
Thanks for your scripts.
Did have a gap and island method which was a tad bit slower, so I am happy with the script.
But I did make some alterations.
during testing...
February 16, 2016 at 9:48 am
WhiteLotus (2/14/2016)
Any steps that I miss out ? or can I use Backup – Restore ?
No you can't.
Within the management studio there is a possibility to copy a database.
But I...
February 15, 2016 at 6:06 am
Jeff Moden (2/12/2016)
[font="Arial Black"]EDIT EDIT: Also just noticed that Ben was also right there (excluding exact matches).[/font] That's what I get for not reading further down. :blush:
Yeah, that's...
February 15, 2016 at 6:00 am
For your last example:
select * from #t as a where
A.t > @pointfrom AND @pointto > A.f
Ben
February 12, 2016 at 6:36 am
--
-- Create a table with content. (Containing periods of hours, days, months and 24 hour periods)
--
DECLARE @test_a table(a_start datetime
...
February 12, 2016 at 6:14 am
Although with my collation change, I did it within the database, probably the next time I would test if copying all the data to a database with a 'correct' collation...
February 12, 2016 at 1:41 am
As allready said, the splitter by Jef Modem is a very usefull tool in general and also for this situation.
In the example below I have removed the spaces in the...
February 11, 2016 at 9:41 am
I do use the following 'BLOB' of code to 'track' usage. (Edit : Sorry, tables only).
This is run repeatedly and shows the usage of tables between two calls.
Here the code...
February 11, 2016 at 6:43 am
Stix83 (2/11/2016)
here is my joining statement:
sELECT B.CONTACT AS CONTACT,
B.MAIN AS PHONE,
B.CELL AS CELL,
B.DATE_OF_CONTACT AS...
February 11, 2016 at 6:20 am
WhiteLotus (2/10/2016)
I am migrating database from server A to server B . The collation in Server A is SQL_latin1_general_CP1_CI_AS and server B is
Latin1_General_CI_AS
So the database from server...
February 11, 2016 at 5:17 am
Steve Jones - SSC Editor (2/9/2016)
February 11, 2016 at 2:06 am
ChrisM@Work (1/25/2016)
How can the code return incorrect results, Ben? Am I missing something here?
The name of the month is language dependend. This often leads to trouble.
When storing a date in...
January 25, 2016 at 10:05 am
Viewing 15 posts - 271 through 285 (of 557 total)