Viewing 15 posts - 136 through 150 (of 3,221 total)
richpurdey (2/22/2013)
I wish to enhance my employability, I am already a time served Sys Admin/MCSE in the Financial Services sector.
Do...
February 23, 2013 at 2:27 pm
I read the previous comments, and except for a very few, posted by us "oldtimers" which bought back memories of my first programming tasks in 1960. (Hard to believe that...
February 23, 2013 at 7:27 am
L' Eomot Inversé (2/21/2013)
I was trying to put together a submission for QotD. But I thought I'd seen too many comments recently...
February 21, 2013 at 2:46 pm
HERE it is from a table (Now I used a temporary table BUT ONLY for illustration IN your situation it would be the real table)
/* I...
February 21, 2013 at 1:05 pm
If you import the data into a staging table, you could then execute:
DECLARE @D1 VARCHAR(20)
DECLARE @D2 VARCHAR(20)
DECLARE @D3 VARCHAR(20)
...
February 21, 2013 at 11:07 am
Before proceeding I suggest that you read this short, very short article by Jeff Moden. (It hopefully will assist you in increasing your understanding of your problem)
February 21, 2013 at 10:03 am
You may want to look at the procedure (in the Master DB) titled
[sys].[sp_MSforeachtable].
Review the T-SQL to determine if it will perform as you want it to, or if it does...
February 20, 2013 at 8:45 am
Believe what you may be looking for is the MERGE statement. For a discussion and example of how it works:
http://www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/
If you would/could post the table definition, some sample data...
February 18, 2013 at 6:59 pm
Lynn Pettis (2/18/2013)
Really? Answer to what?
Thanks ... I needed a laugh today
February 18, 2013 at 10:37 am
Not meaning any disrespect .. but use GOOGLE it returned
About 3,450,000,000 results when I used it.
here is one site that may be of use to you.
February 17, 2013 at 1:09 pm
To help those who want to, and can help you please define the tables, and provide some sample data.
To do this please click on the first link in my signature...
February 15, 2013 at 7:48 am
okbangas
My explanation might not be 100% accurate, but this is indeed the documentation I found when I ran into the issue demonstrated in the question. That it indeed may work...
February 14, 2013 at 3:41 pm
If you can NOT use the suggestion of opc.three
Read the following article by Jeff Moden:
February 12, 2013 at 6:11 pm
Thanks .. nice clear question about something I needed to learn ...
Now my question to you: Is the company sponsored employee & spouse/partner formal dinner and dance, a benefit enjoyed...
February 11, 2013 at 8:20 pm
Depending upon your exact needs, you could try the Express Edition, available as a free download.
http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx
or download a trial copy at:
http://www.microsoft.com/en-us/sqlserver/get-sql-server/try-it.aspx
February 10, 2013 at 6:26 am
Viewing 15 posts - 136 through 150 (of 3,221 total)