appleglaze28

Posts

Reputation

Joined 14 Years Ago

Last Seen 14 Years Ago

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

Ranked #31.8K

~242 People Reached

Favorite Forums

Favorite Tags

	Eliminate 1 Duplicate Record with 1 Unique Column 14 Years Ago 14 Years Ago Share on Facebook Share on Twitter Share on LinkedIn I need to eliminate a record with almost exactly the same data except 1...for example: I have 4 Fields for Employee table: Employee Stat First Name Last Name Employee ID Active James Smith JOS Resigned James Smith JOS For some reason the table I'm querying has these data. How can … Databases mssql 0 1 87
	Set a counting for number of field base on a specific common data in a certain field 14 Years Ago 14 Years Ago Share on Facebook Share on Twitter Share on LinkedIn I have a question I want to query a datamart with transactional data. I have 3 fields the unique one is the product. I want to get a query where i set a number from the range of how many unique item there is on field three against field 1 … Databases mssql 0 1 36
	Concatenate distinct column 1 with none distinct countepart in column 2 14 Years Ago 14 Years Ago Share on Facebook Share on Twitter Share on LinkedIn I'd like to ask a lil help from everyone. I have this problem. I have like items in column 1 & 2: COLUMN 1 COLUMN 2 0001 0043 0001 0056 0001 0078 0002 0043 I just need 1 row per distinct item in column 1 but I need the items … Databases mssql 0 7 119