Viewing 15 posts - 1,561 through 1,575 (of 2,647 total)
If there are certain "fixed" things (number of lines in each set that you would consider a "row") you can have someone write something to parse out this file. My...
February 23, 2012 at 5:55 am
sjimmo (2/22/2012)
February 22, 2012 at 6:34 pm
Can you group it by the person and do a distinct count of degree with the same criteria you have in that query. Then add HAVING COUNT(DISTINCT degree) >...
February 22, 2012 at 3:21 pm
Jeremy... (2/22/2012)
Lynn Pettis (2/22/2012)
Wildcat (2/22/2012)
Hakuna Matata (2/22/2012)
Try this :
WHERE CONVERT(DATE,FM.Openeddate)=CONVERT(DATE,GETDATE())I don't recommend to use this
I agree with wildcat as it would cause a table scan. The convert function has...
February 22, 2012 at 2:52 pm
Lynn Pettis (2/22/2012)
Wildcat (2/22/2012)
Hakuna Matata (2/22/2012)
Try this :
WHERE CONVERT(DATE,FM.Openeddate)=CONVERT(DATE,GETDATE())I don't recommend to use this
I agree with wildcat as it would cause a table scan. The convert function has to...
February 22, 2012 at 2:51 pm
dnolan5323 (2/22/2012)
Thanks for the replies. Is there no way to use BCP and Bulk Insert to perform this task?
Not until you create a file that fits a row/column format.
February 22, 2012 at 2:31 pm
I'm not sure that you can do this without some more manipulation beforehand or "possibly" in SSIS. BULK INSERT is meant to insert large amounts of data that are...
February 22, 2012 at 2:25 pm
SQLKnowItAll (2/22/2012)
TT-131210 (2/22/2012)
I am getting error when I run this.
Mmm hmm... What version of SQL Server are you running?
HINT: Run this SELECT @@version
I believe ColdCoffee's suggestion is exactly what you...
February 22, 2012 at 1:15 pm
TT-131210 (2/22/2012)
I am getting error when I run this.
Mmm hmm... What version of SQL Server are you running?
HINT: Run this SELECT @@version
I believe ColdCoffee's suggestion is exactly what you need.
February 22, 2012 at 12:40 pm
I give up! What group is in the FROM line? 🙂
February 22, 2012 at 12:36 pm
Jeremy... (2/22/2012)
February 22, 2012 at 12:14 pm
andersg98 (2/22/2012)
UPDATE PROGRESS_NOTE
SET PROGRESS_NOTE.SUPERVISOR_MONIKER =...
February 22, 2012 at 11:43 am
At least you found the source of the problem and were able to rectify it! Happy Fat Tuesday!
February 21, 2012 at 2:42 pm
MyDoggieJessie (2/21/2012)
To tell you the truth I am blown away that there wasn't more information on this on BOL or MS forums...almost makes me feel special that I AM...
February 21, 2012 at 2:12 pm
Viewing 15 posts - 1,561 through 1,575 (of 2,647 total)