Viewing 15 posts - 301 through 315 (of 326 total)
turn on the package logging to have a better picture..
it says conversion error; may be the data for column "folderSchoolDate" have special characters that require unicode settings to be set..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 31, 2012 at 10:24 am
http://www.sqlservercentral.com/Forums/Topic1337063-391-1.aspx
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 31, 2012 at 5:10 am
shahsn11 (7/31/2012)
I might not be able to put my question in proper way so let me put the same question other way around.
-------- //some logic
-------- //some logic
where empid = (select...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 31, 2012 at 5:03 am
can you provide the DDl and more clarify your problem ...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 30, 2012 at 11:03 am
can you provide the DDl and more clarify your problem ...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 30, 2012 at 10:53 am
declare @b-2 int =null
declare @id int=6
declare @i int=0
while (1=1)
begin
select @id= ISnull((select d from #datatable where D=@id),(select b from #test where a=@id ))
select @b-2=d from #datatable where d=@id
if(@b is...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 30, 2012 at 4:08 am
create table #test (a int,b int)
insert into #test values(1,0),(2,1),(3,1),(4,2),(5,2),(6,2),(7,4)
create table #datatable(
D int, Name varchar(20),somedata varchar(20))
insert into #datatable values
(1 ,'A' ,'xxx'),
(2 ,'B' ,'yyy'),
(5 ,'C' ,'zzz')
declare @b-2 int =null
declare @id int=5
declare @i...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 30, 2012 at 4:02 am
Koen Verbeeck (7/30/2012)
Something like this?
SELECT ID, Name, Type, CountType = COUNT(Type)
FROM Table1 t1 INNER JOIN Table2 t2 ON t1.Type = t2.Type
GROUP BY ID, Name, Type
create a dataset using the above...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 30, 2012 at 2:34 am
Lokesh Vij (7/28/2012)
Alan Kwan (7/27/2012)
Just tried the code you provided, still the same error.Try using SSIS then. Its a simple transfer from xls to SQL 🙂
not just the best, also...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 28, 2012 at 11:24 am
demonfox (7/28/2012)
Lokesh Vij (7/27/2012)
First of all, your table ISIR should have enr_id added otherwise it does not make any sense to have two dateadded fields for one stu_id
Yes agree with...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 28, 2012 at 2:48 am
Lokesh Vij (7/27/2012)
First of all, your table ISIR should have enr_id added otherwise it does not make any sense to have two dateadded fields for one stu_id
Yes agree with this...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 28, 2012 at 2:29 am
Lokesh Vij (7/27/2012)
Here is one more...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 28, 2012 at 2:25 am
try the data viewers to analyse the nature of data , if it's the conversion issue you may have corrupted data.
-- you can put the logging events for the task...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 28, 2012 at 1:24 am
WITH test_credit AS(
SELECT * FROM Enroll WHERE Credits>15)
SELECT * FROM Enroll b
LEFT JOIN
ISIR a ON b.Stu_Id=a.Stu_ID
LEFT JOIN test_credit c
ON c.stu_id=a.Stu_ID
WHERE a.DateAdded is null
OR (b.Credits<40)
AND c.credits is null
This should do...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 27, 2012 at 2:24 pm
My mistake ; better not put surprises ...
thanks for correcting ..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 27, 2012 at 2:04 pm
Viewing 15 posts - 301 through 315 (of 326 total)