Viewing 15 posts - 8,371 through 8,385 (of 15,381 total)
trisno (5/13/2013)
I want to export data in table to txt
SELECT [StatBeginTime]
,[MDASum]
,[BureauName]
,[MDA]
...
May 13, 2013 at 12:33 pm
You are going to have a nearly impossible time doing this set based because your primary key includes tx_date. I wonder if your cursor actually does what you think it...
May 13, 2013 at 12:30 pm
The reason you did not get any responses in your original thread (http://www.sqlservercentral.com/Forums/Topic1451201-150-1.aspx) will be the same reason you don't get any here. You didn't post enough information for anybody...
May 13, 2013 at 12:15 pm
That is great Brandie. What a great idea that blossomed into something really spectacular. I suspect that those kids will remember that...
May 13, 2013 at 10:04 am
Great job posting ddl and sample data!!!
This should accomplish what you are after.
update a
set Address1 = a2.Address1,
Address2 = a2.Address2,
city = a2.city,
stateAdd = a2.stateAdd
from #List l
join #Addredss a on a.ID =...
May 13, 2013 at 9:53 am
hamed1337 (5/12/2013)
http://www.dkunderground.org/forums/topic/751-mssql-sql-server-2008-installation-dekaron-db-setup/And i even tried with sql 2008 but i encountered some errors while executing querys
Have you tried setting the compatibility mode to 2000?
May 13, 2013 at 8:43 am
Eugene Elutin (5/13/2013)
Install RedGate DB search - it's free!http://www.red-gate.com/products/sql-development/sql-search/
+1
Once you install it you will ask yourself how you ever managed to find anything without it. I use it daily.
May 13, 2013 at 8:40 am
Mr. Kapsicum (5/13/2013)
Toreador (5/13/2013)
May 13, 2013 at 8:38 am
justfillingtime (5/13/2013)
BOOM! Thanks Sean Lange. Sorted.
You're welcome. Glad that worked for you.
May 13, 2013 at 8:05 am
carsten.crystaldive (5/12/2013)
Hi,I'm already sorry (especially if Sean is answering again) ... I am quite new to this whole posting stuff, but I am trying my best ...
LOL no worries. You...
May 13, 2013 at 8:03 am
Instead of using triggers for this could you create an INSERT sproc that receives parameters with more characters? That would seem to be a little less kludged than making the...
May 13, 2013 at 7:36 am
I would guess that they used some sort of stream writer. You are going to have to write an application for this. There is no t-sql that can do this...
May 13, 2013 at 7:29 am
justfillingtime (5/13/2013)
Got a quick Select Top 10 question. I'm running a simple query to find top ten people who have contacted us in the past month.
The problem...
May 13, 2013 at 7:09 am
Danny Ocean (5/13/2013)
I think nobody check the question before published and everybody should get point for this.
You just got your point back by posting. If you want some points, you...
May 13, 2013 at 7:03 am
Not quite sure why you are using dynamic sql in the middle of your cursor. I am very confused by the case expression in your update. You either use the...
May 10, 2013 at 12:46 pm
Viewing 15 posts - 8,371 through 8,385 (of 15,381 total)