Viewing 15 posts - 691 through 705 (of 2,894 total)
[
...
Im guessing Im going to have to go for adding them into a permanent table rather than a temp if IDENTITY go this way?
That is exactly what I've been talking...
February 25, 2013 at 5:28 am
Abu Dina (2/25/2013)
create table #SSC(ID INT IDENTITY (1, 1), Code CHAR(1))
insert into #SSC
select 'A' union ALL select 'B' union all select 'P' union all select 'V'...
February 25, 2013 at 5:19 am
question: do you want to generate just a code, so you can use it somewhere else or you want it to be a part of some procedure, so temp tables...
February 25, 2013 at 4:39 am
To create the number of tables dynamically you will need to use dynamic sql (using sp_executesql or EXEC ()). However, it will not work for you, as temp tables created...
February 25, 2013 at 4:33 am
We have no idea what data you have in your tables, so only the guess:
You join on dates, so it may be that some dates in your expected data are...
February 22, 2013 at 5:28 am
I still could not run your CTE due to type mismatch error. (I guess when you do CHAR concatenation in the recursive CTE you should cast to NVARCHAR). However,...
February 20, 2013 at 3:27 am
One of the reason you don't have much of answers is that your posted code cannot be executed without error...
INSERT INTO FreightContents VALUES('FJ#1000210','104001-00-3')
...
results with error:
Msg 213, Level 16,...
February 19, 2013 at 9:14 am
Are you sure that there is no default on the column?
sp_help [yourtablename] to see ones.
How your application is talking to DB, are you using N-Hibernate by any chance?
February 13, 2013 at 8:42 am
gopilqs (2/13/2013)
Any one Help my career Path?
Corently am Working with capgemini india Pvt Ltd. on Mainframe technology, I have 4 years of Exp in mainframe Technology.I Would like to...
February 13, 2013 at 7:19 am
If it's really URGENT, then you better to present your issue in a way it could be quickly addressed. Please have a read tips from the link at the bottom...
February 13, 2013 at 5:10 am
just small change to get record with MAX(Forecast), more sample data added:
DECLARE @t TABLE(L1 INT,L2 CHAR(1), L3 CHAR(1), dt Date, Forecast NUMERIC(10,5))
INSERT INTO @t(L1,L2,L3,dt,Forecast)
VALUES
(1, 'a', 'x', '01-dec-2012', 7.2),
(1, 'a', 'x',...
February 12, 2013 at 11:20 am
First of all I can suggest you to read article from the link found in the bottom of my signature. It will help your question to be answered by other...
February 12, 2013 at 9:46 am
Could you please provide DDL and insert sample data script? Tips how to do so are in the link at the bottom of my signature.
February 11, 2013 at 5:59 am
ScottPletcher (2/7/2013)
Eugene Elutin (2/7/2013)
ScottPletcher (2/6/2013)
No, I wouldn't use OR just because that makes a view updateable -- UPDATEs aren't typically done using views like that anyway.
What is the problem with...
February 11, 2013 at 5:43 am
Welcome to the forum.
I would strongly suggest you to read the tips from the link at the bottom of my signature.
Following the above, will help you to post...
February 11, 2013 at 5:34 am
Viewing 15 posts - 691 through 705 (of 2,894 total)