Thanks For your answer. i want display 11,13 only not two because it appears once.

Thanks

i get this


and i will try to add it in the select and it will still give me nothing

Good Day All

i have the Following that table


ID | ACTV |VENU |STUD | TRIES
=====================================
1 1 4 162 0
2 4 5 104 0
3 8 5 138 0

Thank yo very much guys. The Problem was that i was Closing the connection in the function ExecuteScalarInThread

Thanks

Good Day All

i have the Following Function


private static void OMEGA_calcActvEqv()
{
SqlConnection conn1 =...

That is wonderful it worked.

Thanks

Good Day all

i have the Following Query

DECLARE @CurrentTime DATETIME
SET @CurrentTime = CURRENT_TIMESTAMP
select tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description],...

Good Day All

I have a ASP.NET app. There is a button one of the pages. I have placed a Break point in the Click event and when i click the Button it does not even go to the Break Point it shows...

Its the same thing. UNC and the Mapped drive is the same thing. so that will not help. i thought there was another way.

Good Day All

am restoring a Database Programatically in Sql. Now if the backup is located in the remote machine i use a Share





but i will get the Following Error

Good Day all

i have created a Global Variable as depicted in the following Pic

http://www.tiyaneproperties.co.za/SSIS/pic1.JPG

The Following Screen-shot shows how i created my Variable and...

Good Morning

This is not an Application, so i will not have a BLL or DAL. i have all the Rights to write to the File System. all i need is help to BCP the given query

Good Day All

I have the Following Query

DECLARE @CurrentTime DATETIME
SET @CurrentTime = CURRENT_TIMESTAMP
select tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description],...

Good Day All

I have a Package created and hosted in a Machine(Theresa) that has SQL 2008 and i have my Development Machine(Vuyiswa) that has IIS and am Debugging from the my machine. i have a...

The Server name cant be localhost. The Server name is the instance of SQL not the name of the Computer. a lot of people confuses this. There is a Difference between Data Source and servername. The...

This Query works


select distinct nP.id, nP.NodeID, nP.parent, nP.Description, nRef.ID refParent
from #Nodes nP
left outer join #Nodes nRef on nP.Parent = nRef.NodeID -- look up the reference...

Thanks now i have Changed my Code to look like this and its working perfect in SQl when i test it.


select distinct nP.id, nP.NodeID, nP.parent, nP.Description, nRef.ID refParent, np.type
from...

Good Day all

it is Probably a long day, i cant think Straight now.

i have a table that looks like this


Nodeid Parent Description Type Curr...

Where did you put your Database File ?

You are Welcome. Mark the Thread as Resolved and give one of us a Reputation is we deserve it

Kind Regards

Vuyiswa Maseko

Good Day All

I have a File Format Defined like this



and i use it like this

BULK INSERT dbo.TBL_CMPS FROM 'C:\\UNISA_IMPORT\\Final_Import\\Campuses.csv'
WITH (

You are Welcome

Look at this Post and tell me if there is still a problem

http://www.daniweb.com/forums/thread138587.html (http://www.daniweb.com/forums/thread138587.html)

Kind Regards


Vuyiswa Maseko

Mark the Post as Resovled and give Reputation if i deserve it :)

Kind Regards

Vuyiswa Maseko

It is Very Difficult to Help someone who has not Started something. but logically this means that you need to use a Wizard control and Record the selected Questions and at the end give the results of...

This is not A Correct Approach for a login. This is simple you are Suppose to count the Records that matches the Where Clause and you have included having and Group by clause and that is incorrect....

Good Day

Why dont you mark your Post as Resolved because your post had been resolved here

http://forums.asp.net/p/1477628/3439861.aspx (http://forums.asp.net/p/1477628/3439861.aspx)

Good Day

These are two different Technologies,there might be a lot of tools that can convert this for you , but i myself i dont trust them , because a lot of them are not going a good Job. I will...

First thing, go to your toolbox and Add a Calender control , set the visibility to false, and add a textbox where there value will be passed too and a link button to invoke the calender. in the...

How many web config do you have in your Project ?

Do something for me, so that i can know what is the problem exactly. go to one of the aspx file and right click -- Open with --> Notepad and Tell...

Your SQL Table Must have a Identity Column first change the Defination of your table to this

CREATE TABLE mytable
(
id INT IDENTITY(1,1) PRIMARY KEY not null,
Fname...

No Problem and dont Forget to mark the post as resolved and give me my reputation. am going home now enjoy your weekend

Kind Regards

Vuyiswa Maseko

Here is your Solution

SqlConnection con =new SqlConnection(@"User id=sa;Password=oops;Server=VUYISWA\SQLEXPRESS;Database=Vuyiswa");

SqlCommand cmdinsert = new SqlCommand();
...

ok

Can you Post your TextFile and a Create Script of your SQl Table and i will give you an Exact code to write.

kind Regards

Vuyiswa Maseko

Remove the First Column and let SQl add it for you as an identity Column.

What is the Problem ?

Am glad you got your Solution . Mark your Post as Resolved

Kind Regards

Vuyiswa Maseko

Dont Worry about the REfreshing, add the Grid into an Update Panel to remove the Page Flickers

sandeep_1987 wrote :


mmh i see what you are Saying. It can be done ,but there another way that...

I think you didnt Search enough, look at this


http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html...