Viewing 15 posts - 11,596 through 11,610 (of 26,486 total)
Would also help if you would post the code involved.
May 31, 2012 at 1:11 pm
Here is my problem with Natural Keys (not saying they are wrong), they tend to not stay unique. Your case in this thread is a good example. I...
May 31, 2012 at 1:10 pm
joshd 1807 (5/31/2012)
What I'm trying to do is create a case statement that makes a field two names based on a specific condition.
One...
May 31, 2012 at 1:03 pm
Sean Lange (5/31/2012)
kramaswamy (5/31/2012)
hey all - got a theoretical question.I see three ways of going about solving this problem:
1. Keep ClientID as the Clustered Index, but remove the Unique clause.
This...
May 31, 2012 at 1:00 pm
andersg98 (5/31/2012)
CREATE TABLE #temp
(
[Friday1] CHAR(10) ,
[Friday2] CHAR(10) ,
[Friday3]...
May 31, 2012 at 12:54 pm
andersg98 (5/31/2012)
CREATE TABLE #temp
(
[Friday1] CHAR(10) ,
[Friday2] CHAR(10) ,
[Friday3]...
May 31, 2012 at 12:52 pm
Nidhi G (5/31/2012)
What if we declare 8 variables and then put the values in those. That will be good for...
May 31, 2012 at 12:50 pm
Nidhi G (5/31/2012)
I am trying the values for the result set in a temp table.I created the below temp table:
create table #temp (datevalues datetime)
To put the dates into 8 variables.
DECLARE...
May 31, 2012 at 12:42 pm
Nidhi G (5/31/2012)
I am trying the values for the result set in a temp table.I created the below temp table:
create table #temp (datevalues datetime)
WITH
e8(n) AS (SELECT (ROW_NUMBER() OVER (ORDER BY...
May 31, 2012 at 12:37 pm
Unless something has changed with COPY ONLY full backups, it was my understanding that they could not be used as the base for a recovery.
May 31, 2012 at 11:37 am
Grant Fritchey (5/31/2012)
donnapatriciakelly (5/31/2012)
I work in the Business Intelligence area, and deal with all sorts of source systems. ...
May 31, 2012 at 11:06 am
You could use SSIS to transfer data from a SQL Server database to an Oracle database.
May 31, 2012 at 10:58 am
donnapatriciakelly (5/31/2012)
I work in the Business Intelligence area, and deal with all sorts of source systems. Getting data...
May 31, 2012 at 10:47 am
rossss (5/31/2012)
Lynn Pettis (5/31/2012)
I would go with separate stored procedures. Each one should do a single function, get or insert.
What's your reasoning behind this though? Don't get me...
May 31, 2012 at 10:44 am
Lynn Pettis (5/31/2012)
Eugene Elutin (5/31/2012)
This one...
May 31, 2012 at 10:29 am
Viewing 15 posts - 11,596 through 11,610 (of 26,486 total)