Viewing 15 posts - 7,591 through 7,605 (of 8,756 total)
mike 57299 (8/4/2014)
I am trying to generate a hex value automatically at time of insert. The column used for the hex # is an identity column. ...
August 4, 2014 at 1:03 pm
SQLRNNR (8/3/2014)
Eirikur Eiriksson (8/3/2014)
Jeff Moden (8/3/2014)
TomThomson (8/3/2014)
Jeff Moden (8/2/2014)
Grant Fritchey (7/16/2014)
You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.
Heh......
August 3, 2014 at 1:51 pm
Jeff Moden (8/2/2014)
Eirikur Eiriksson (8/2/2014)
The datetime format is still the same upto and including 2014.😎
Thanks Eirikur. I've never looked at it but figured it might be so. That...
August 3, 2014 at 12:25 pm
Jeff Moden (8/2/2014)
Grant Fritchey (7/16/2014)
You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.
Heh... what's really cool about Grant is...
August 3, 2014 at 10:33 am
Jeff Moden (8/3/2014)
TomThomson (8/3/2014)
Jeff Moden (8/2/2014)
Grant Fritchey (7/16/2014)
You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.
Heh... what's really cool...
August 3, 2014 at 9:59 am
LutzM (8/3/2014)
after a semi-internal discussion the answer we agreed on is:Yes.
If you need a more detailed answer please provide a more detailed question.
Seriously? I thought that this time it was...
August 3, 2014 at 8:25 am
Please to read the links Lynn provided, it makes things so much easier if one has a proper structure and data sample.
For the fun of it (and feeling lucky...
August 3, 2014 at 8:12 am
If the appearance of the resume adds a value to it then selecting a font isn't enough. One should properly layout the document using the likes of Scribus, InDesign or...
August 3, 2014 at 6:58 am
Where was that Crystal Ball again when one needs it, certain I've seen it somewhere...
😎
August 3, 2014 at 6:47 am
Further on Lutz's last post, the solution to your problem is down to the actual, literal and exact data, at this point without the actual, literal and exact data...
August 3, 2014 at 6:42 am
The only modification I made to Lutz's code was to add the NULLIF, set to return NULL (Empty/Unknown) if the string value 'NULL' (four letter word) appears in the column.
😎
August 3, 2014 at 5:52 am
Did you get this resolved? It only takes a minor change from previously posted code
😎
SELECT
AC.name AS 'Acct',
(SELECT column_id AS 'Item/data()'
FROM sys.columns AS ITEMS1
WHERE ITEMS1.object_id = AC.object_id
FOR XML PATH ('Items'),...
August 3, 2014 at 5:47 am
Using Lutz's code with the addition of NULLIF to also handle literal 'NULL' value
😎
create table #t (EmpID char(5), Name varchar(10), WorkDate date,Status varchar(5),WkdHrs int)
insert into #t
values
('00010', 'JOSEPH', '20140710','P', 8),
('05200', 'ANTHONY',...
August 3, 2014 at 5:01 am
Quick question, can you supply the table structure and sample data in a consumable format?
😎
August 3, 2014 at 4:54 am
saxena200 (8/2/2014)
our data contains tables which have cyclic dependency, there are transaction and master tables but its not necessary that...
August 2, 2014 at 3:44 pm
Viewing 15 posts - 7,591 through 7,605 (of 8,756 total)