Viewing 15 posts - 8,056 through 8,070 (of 10,144 total)
CirquedeSQLeil (3/31/2010)
Chris Morris-439714 (3/31/2010)
Paul White NZ (3/31/2010)
HR read your posts???
SSC HR...
Oh. They monitor these threads?
You work for SSC (redgate)?
It was probably a report, Jasey-wasey. I work for a posh...
March 31, 2010 at 9:31 am
Paul White NZ (3/31/2010)
You are a dark horse Mr Morris.
Neigh, lad.
Paul White NZ (3/31/2010)
Not like Sug, he's a big softy.
About 1/5 of Madness...oh wait a minute no that was Suggs...oh...
March 31, 2010 at 8:52 am
nguyennd (3/31/2010)
Yes, i think it will return blank but i can't belive why it return NULL 😀
Well I never. I reckon you've found...a bug.
Couldn't find anything on Google, not in...
March 31, 2010 at 7:43 am
techdur (3/31/2010)
I will try these suggestions. I am sure there is pre-existing data, which should not be there!Thanks much.
No worries. Post back your findings, you can practically guarantee that...
March 31, 2010 at 7:31 am
Of course - in fact there are two very easy ways.
1. Remove the INSERT statement which contains the dupe
2. Remove the original row from the target table
It's not going...
March 31, 2010 at 6:41 am
GilaMonster (3/31/2010)
Had one this morning that started "Gentlemen, ..."I resisted temptation (mostly) and answered it.
Please share, Gail 🙂
March 31, 2010 at 6:37 am
Paul White NZ (3/31/2010)
HR read your posts???
SSC HR...
March 31, 2010 at 6:32 am
nguyennd (3/31/2010)
When i run this SQL
select SUBSTRING('??????????',20,1)
It return NULL but i want it return blank.
It should return an empty string. It correctly returns an empty string on instances of...
March 31, 2010 at 6:25 am
nguyennd (3/31/2010)
I don't know, but i use SQL 2008
1. What is the result when you run this:
select SUBSTRING('??????????',20,1)
2. Is this the result you expect to see?
3. If the result is...
March 31, 2010 at 5:10 am
You can do it but the performance is often really poor. Instead, LEFT JOIN both tables, and use conditional processing of the output (in the SELECT) to return the data...
March 31, 2010 at 5:08 am
The error message tells you that the table already contains a row with the values of '37', 'FSIS' for OrganizationNumber and OrganizationCode respectively. The primary key constraint is preventing you...
March 31, 2010 at 5:03 am
Using 2005 and 2008,
select SUBSTRING('??????????',20,1)
returns an empty string.
Where does NULL come into this? Are you expecting NULL to be returned when the first expression e.g. 20 is greater...
March 31, 2010 at 4:54 am
nguyennd (3/31/2010)
I have a SQL code
select SUBSTRING('??????????',40,1)select SUBSTRING('??????????',20,1)
Why result are
select SUBSTRING('??????????',40,1) => ''(blank)select SUBSTRING('??????????',20,1)=>NULL
huhu
No problem here, the behaviour is exactly as described in BOL where the start expression is greater...
March 31, 2010 at 4:30 am
Paul White NZ (3/31/2010)
Chris Morris-439714 (3/31/2010)
Ooh don't...one of those really ticked me off a few weeks ago :blush:
Grates on me like fingernails on a blackboard. Did you vent on-thread?...
March 31, 2010 at 3:42 am
Viewing 15 posts - 8,056 through 8,070 (of 10,144 total)