Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~608 People Reached
Favorite Forums
Favorite Tags
Member Avatar for lebanese007

Hi all, This is my first time... and i'm not an sql guy by any means, but i can insert, update, blah blah... I have a question to ask, i have a table that has UniqueInt | Date1 | int1 | Date2 | varchar 1 I have duplicate records that …

Member Avatar for Zadj
0
169
Member Avatar for sahoong

How do you write a store procedure to meet the following conditions: PROXIMITY SERACH PROCEDURE COMPANY table PK company_id int company_name varchar(100) premise varchar(10) street varchar(30) town varchar(100) postcode char(7) x_loc int y_loc int COMPANY_KEYWORD table PK, FK1 company_id int PK keyword varchar(100) The data above shows an extract of …

Member Avatar for Zadj
0
131
Member Avatar for sprdthword

I am trying to dig data from a table that has a field named begdate and another one named enddate. They hold obvious values, but I need to have the query find the record that has a begdate that matches whatever the previous Sunday was to the day the request …

Member Avatar for Zadj
0
60
Member Avatar for Zadj

Hi, I'm trying get some summary results from two related tables. I'm looking to find the most efficient way to return this data in one result set. The tables can be summed up as follows: [code] MainTable MainID INT, Description VARCHAR(50) Eg: MainID Description 1 John 2 Adam 3 Fred …

Member Avatar for nav33n
0
138
Member Avatar for Zadj

Hi, I've run into a situation where I can not see how to write efficient code to perform a check that I need to do. I am running on MSSQL 2005 The check is to compare a varchar passed in to the stored procedure against the words in a table. …

Member Avatar for Zadj
0
110