Viewing 15 posts - 32,581 through 32,595 (of 59,102 total)
The first problem that I see is that the "delimiter" column of the format file has spaces in it that should not be there...
v----------- There's a...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 10:06 pm
Florian Reischl (9/11/2011)
Ha! Logged for future generations! Jeff condones a RBAR solution 😀
Heh... I could argue all day why it's not RBAR but I'll take the hit, for now. :-)...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 9:56 pm
You probably couldn't fix the problem even if you were able to figure out what to do because you don't have the source code to make the right kind of...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 9:52 pm
CELKO (9/11/2011)
There are no magi val universal "id" in RDBMS.
Sure there is... it's called an IDENTITY column and it has several purposes... one is to provide uniqueness in the...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 9:46 pm
I agree with Dave... simply not enough information to help. Please read the article at the link that Dave posted.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 9:20 pm
sunny.tjk (9/11/2011)
Not sure what you meant by the second table?
Quite literally... make a copy of the table at the schema level. Generate the CREATE TABLE statement for the original...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 9:18 pm
CELKO (9/11/2011)
Darn, I need to rewrite 150+ reports of mine. Too bad they actually do what they need, and fast too :-D.
You should not be writing reports...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 1:14 pm
winston Smith (9/9/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 12:57 pm
elham_azizi_62 (9/11/2011)
I use this code for export query result to excel file
set @x = 'bcp "SELECT top 10 [TBL_CustomerID],[TBL_CustomerTitle]
FROM [dbname].[dbo].[TBL_Customer]" queryout c:\test.xls -S...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 12:42 pm
Grant Fritchey (2/21/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 12:35 pm
lnelson (9/11/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 12:26 pm
LutzM (9/11/2011)
I guess Jeff asked to decide whether a CrossTab or a DynamicCrossTab would be required.
As usual, spot on, Lutz. Not my job to judge but nicely done with...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 12:06 pm
And what would you like to do if there are more than 2 (or even more) ID2's for a given File Number? Or are you willing to guarantee that...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 1:58 am
npeters 86796 (9/10/2011)
Thank you my friend this works perfectly.
Thank you for the feedback but I'm still curious... what do you have in place that guarantees that f.docdate will always be...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 1:54 am
I agree with Gail (Gila Monster)... we need to see the stored procedure that you're calling in the cursor. One of the very few things that Celko is likely...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2011 at 1:39 am
Viewing 15 posts - 32,581 through 32,595 (of 59,102 total)