rhythmk (6/26/2012)

---

Methew (6/26/2012)

---

i want to divide records on daily basis like here

IF OBJECT_ID('TempDB..#mytable1','U') IS NOT NULL

DROP TABLE #mytable1

CREATE TABLE #mytable1

(

ID INT IDENTITY(1,1) ,

UName NVARCHAR(50),

alert_datetime DATETIME

)

SET IDENTITY_INSERT #mytable1 ON

INSERT INTO #mytable1

(ID,...

Ok i used @dwain.c suggestion

i might not think about data integrity.....If yes then solved my problem

dwain.c (6/12/2012)

---

Well, it's not like Inserted.ID is going...

The only issue is for data integrity....i dnt want mixing of data...Is Inserted.ID is good option OR SCOPE_IDENTITY?which one i should use?

Single transaction mean with in a store procedure?

What if i do not have Identity column id first table?If i have only uniqueidentifier....?

What if i create a time stamp in first...

My host Provider have to upgrade it for me.They have 2008 and above.

My question was as a developer what changes should i made to my script?should i change tables,SP's etc...

Thanks alot...you solved my problem.

Let me clear you first.i want to show related search.For example if you search for PIZZA i will show you PIZZA near to your location.This is search.Now related search is,i...

i need like this

PIZZA HUT PIZZA PIZZAggg

PIZZA HUT AD PIZZA ABC

PIZZA HUT PK...

PIZZA HUTPIZZAPIZZA555

PIZZA HUTPIZZAPIZZAggg555

PIZZA HUT ADPIZZA ABCPIZZA555

PIZZA HUT PKPIZZA INDOPIZZA555

PIZZA HUT SINGAPORE PTDLTDPIZZAPIZZA555

PIZZA HUT SINGAPORE PTE LTDPIZZAPIZZA555

PIZZA HUT UAEPIZZA PHPPIZZA555

If you see i have bolded and underlined same data(mean duplicated result)....i...

Ok here is my detail...If you please run this code,it will give you duplicate data in same rows as well as in different row....i do not want any record to...

If i pass search parameter like 'pizza',i am getting result like this which i do not want

COMPANY CategoryName comp_kws ...

RBarryYoung (5/21/2012)

---

formatting your code:

IPSearchLight.GeoLocator loc = new GeoLocator();

loc.Database_Path_or_URL = "GeoLiteCity.dat";

string VisitorIP = Request.ServerVariables["REMOTE_ADDR"];

...

RBarryYoung (5/20/2012)

---

Methew (5/20/2012)

---

@Young:

i do not know the internal structure(and i do not know how to know/check its internal structure)...i have this file GeoLiteCity.DAT.I am passing IP address of current user...

@young:

i do not know the internal structure(and i do not know how to know/check its internal structure)...i have this file GeoLiteCity.DAT.I am passing IP address of current user...