Viewing 15 posts - 916 through 930 (of 5,502 total)
Jack Corbett (10/1/2011)
I just hope I can honor that award the way that all the MVP's...
October 1, 2011 at 12:58 pm
You could also spend some time and google for some more hints. This is a common question and there are several solutions out there.
October 1, 2011 at 2:21 am
You might want to look into CROSS APPLY.
Sounds like one possible solution to the problem.
For details please follow the advice given by Lynn.
October 1, 2011 at 2:18 am
I guess the problem is not really caused by XQuery but rather by the values for the date variables: Both show the same date but the query will find no...
October 1, 2011 at 2:02 am
Or turn the pivot into a classic CrossTab (as described in the related link in my signature).
It's much more flexible and seems to be faster, too.
September 25, 2011 at 2:06 am
You mmight try to get the list of column names via the sys,columns table:
SELECT name
FROM sys.columns WHERE object_id=object_id('#temp')
ORDER BY column_id
But if you want to insert data...
September 25, 2011 at 1:51 am
Usually, stuff like this is related to missing permissions, e.g. access to the file system.
But without knowing what the sproc and SSIS package do, it's hard to tell.
September 25, 2011 at 1:39 am
Depending on your definition of "week1" and the like, a classic CrossTab should do it. Have a look at the related article referenced in my signature.
If you need further explanation,...
September 23, 2011 at 11:56 am
If you want to list a known number of languages, you could use the CrossTab method as described in the related link in my signature.
In case you're trying to pivot...
September 22, 2011 at 12:35 pm
The only reference I have is BOL.
Why the function return the data the way it does is beyond me.
Regarding the function [fnDDMMYYYYHHMMSStoDate]:
Wouldn't it be easier to simply use CONVERT...
September 21, 2011 at 3:18 pm
Depending on what you consider as "less data" you could use
ROW_NUMBER() OVER (PARTITION BY Empid ORDER BY EmpName desc, City desc, nuumber desc)
September 21, 2011 at 12:26 pm
L' Eomot Inversé (9/21/2011)
...Difficult to disagree with that - but it could be worse, at least they aren't trying to use DB2.
I don't know why I suddenly think about the...
September 21, 2011 at 11:49 am
Gianluca Sartori (9/21/2011)
:-D:hehe:
Today we had an Oracle consultant (BI systems engineer, not a DBA) in our offices and I was discussing some (very serious) issues with an Oracle database....
September 21, 2011 at 11:14 am
I think you can remove this block:
OR A.[MESSAGE] LIKE '%[$][0-9] OFF%'
OR A.[MESSAGE] LIKE '%[$][0-9][0-9] OFF%'
OR A.[MESSAGE] LIKE '%[$][0-9][0-9][0-9] OFF%'
OR A.[MESSAGE] LIKE '%[$][0-9].[0-9][0-9] OFF%'
OR A.[MESSAGE] LIKE '%[$][0-9][0-9].[0-9][0-9] OFF%'
OR A.[MESSAGE] LIKE '%[$][0-9][0-9][0-9].[0-9][0-9]...
September 20, 2011 at 2:10 pm
Why don't you use referential integrity (foreign key) with cascade delete?
September 20, 2011 at 2:03 pm
Viewing 15 posts - 916 through 930 (of 5,502 total)